Yes, they would have to download the add-in as well. With a VBA solution, they will have to enable macros or the UDF (User Defined Function) won't work.
Attached is a modified version of your example workbook. Please note that it is now a .xlsm file which means it contains VBA code. When you open it, you will have to enable macros.
In Sheet1 cell B3 is this UDF formula:
In cell B4 is this formula (not a UDF, it is a native Excel function in Excel 2007+):
This is the code used for the UDF:
How to use a UDF (User Defined Function):- Make a copy of the workbook the UDF will be tested on
- Always run new code and UDFs on a workbook copy, just in case the code doesn't run smoothly
- This is especially true of any code that deletes anything
- In the copied workbook, press ALT+F11 to open the Visual Basic Editor
- Insert | Module
- Copy the provided code and paste into the module
- Close the Visual Basic Editor
- In the desired cell, call the UDF like you would a regular formula: =UDFNAME(Argument1, Argument2, etc)
- I named this one ConcatIfs
Bookmarks