| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Replacing MCONCAT with CONCAT_RANGE (UDF)
Currently using this formula:
=MID(MCONCAT(UNIQUEVALUES(IF(SUBTOTAL(3;OFFSET(E5: E1074;ROW(E5:E1074)-MIN(ROW(E5:E1074));;1));";"&E5:E1074;"")));2;8^8) Would like to replace the MCONCAT function with the CONCAT_RANGE --=CONCAT_RANGE(E5:E1074;";") -- UDF (Thank you to JulieD http://www.hcts.net.au/tipsandtricks.htm for pointing me in the direction of this UDF) Is this possible. I tried but could not get it to work. Thank you in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replacing MCONCAT with CONCAT_RANGE (in a complicated formula) | Excel Worksheet Functions | |||
| MCONCAT only Visible Cells | Excel Worksheet Functions | |||
| replacing TRUE/FALSE | New Users to Excel | |||
| MCONCAT | Excel Worksheet Functions | |||
| How do I stop excel replacing numerical values with the date? | Excel Discussion (Misc queries) | |||
Threaded Mode
