Releases: Excel-DNA/XFunctions
Excel-DNA XFunctions v0.5-beta
The Excel-DNA XFunctions add-in provides implementations of the XLOOKUP and XMATCH functions that are compatible with the built-in functions introduced in August 2019.
Version 0.5 of the add-in is a test version that implements the two functions, and should run in any Windows desktop version of Excel, except possibly in some edge cases where the string locale is handled differently (please report if you have such examples).
If the add-in is loaded into a version of Excel that already supports the XLOOKUP and XMATCH functions, the add-in will register the add-in functions under the names XLOOKUP.FROM.ADDIN and XMATCH.FROM.ADDIN respectively.
To install just download the matching ExcelDna.XFunctions.xll or ExcelDna.XFunction64.xll binary for 32-bit or 64-bit Excel into any local directory, and the pick File -> Open to load, or press Alt+t,i to show the Add-ins dialog and install.
Please have a look and post bug reports on GitHub or on the Excel-DNA discussion group.
-Govert
Excel-DNA XFunctions v0.4-beta
The Excel-DNA XFunctions add-in provides implementations of the XLOOKUP and XMATCH functions that are compatible with the built-in functions introduced in August 2019.
Version 0.4 of the add-in is a test version that implements the two functions, and should run in any Windows desktop version of Excel, except possibly in some edge cases where the string locale is handled differently (please report if you have such examples).
If the add-in is loaded into a version of Excel that already supports the XLOOKUP and XMATCH functions, the add-in will register the add-in functions under the names XLOOKUP.FROM.ADDIN and XMATCH.FROM.ADDIN respectively.
To install just download the matching ExcelDna.XFunctions.xll or ExcelDna.XFunction64.xll binary for 32-bit or 64-bit Excel into any local directory, and the pick File -> Open to load, or press Alt+t,i to show the Add-ins dialog and install.
Please have a look and post bug reports on GitHub or on the Excel-DNA discussion group.
-Govert
Excel-DNA XFunctions v0.3-beta
The Excel-DNA XFunctions add-in provides implementations of the XLOOKUP and XMATCH functions that are compatible with the built-in functions introduced in August 2019.
Version 0.3 of the add-in is a test version that implements the two functions, and should run in any Windows desktop version of Excel.
If the add-in is loaded into a version of Excel that already supports the XLOOKUP and XMATCH functions, the add-in will register the add-in functions under the names XLOOKUP.FROM.ADDIN and XMATCH.FROM.ADDIN respectively.
To install just download the matching ExcelDna.XFunctions.xll or ExcelDna.XFunction64.xll binary for 32-bit or 64-bit Excel into any local directory, and the pick File -> Open to load, or press Alt+t,i to show the Add-ins dialog and install.
Please have a look and post bug reports on GitHub or on the Excel-DNA discussion group.
-Govert
Excel-DNA XFunctions v0.2-alpha
The Excel-DNA XFunctions add-in provides implementations of the XLOOKUP and XMATCH functions that are compatible with the built-in functions introduced in August 2019.
Version 0.2 of the add-in is an early test version that implements the two functions, and should run in any Windows desktop version of Excel.
To install just download the matching ExcelDna.XFunctions.xll or ExcelDna.XFunction64.xll binary for 32-bit or 64-bit Excel into any local directory, and the pick File -> Open to load, or press Alt+t,i to show the Add-ins dialog and install. Two test files that exercise the functions can also be found below.
WARNING! I have not tested this yet - expect fixes and changes.
Please have a look and post bug reports on GitHub or on the Excel-DNA discussion group.
-Govert
Changelog
v 0.2 - Fixes issue #1 where exact matches did not escape wildcards correctly
Excel-DNA XFunctions v0.1-alpha
The Excel-DNA XFunctions add-in provides implementations of the XLOOKUP and XMATCH functions that are compatible with the built-in functions introduced in August 2019.
Version 0.1 of the add-in is an early test version that implements the two functions, and should run in any Windows desktop version of Excel.
To install just download the matching binary for 32-bit or 64-bit Excel into any local directory, and the pick File -> Open to load, or press Alt+t,i to show the Add-ins dialog and install.
WARNING! I have not tested this yet - expect fixes and changes.
Please have a look and post bug reports on GitHub or on the Excel-DNA discussion group.
-Govert