Sure. Take out the spaces and change the dot to .
HTH,
Bernie
MS Excel MVP
"carl" wrote in message
...
Thank You Bernie.
Can I send you a copy of my sheet with a description of what I am trying
to
accomplish ?
"Bernie Deitrick" wrote:
Carl,
If you are going to use a UDF, you might as well write one that does
exactly
what you want. So instead of cobbling together non-custom UDF's, post an
example of what you have and what result you want.
HTH,
Bernie
MS Excel MVP
"carl" wrote in message
...
Currently using this formula:
=MID(MCONCAT(UNIQUEVALUES(IF(SUBTOTAL(3;OFFSET(E5: E1074;ROW(E5:E1074)-MIN(RO
W(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.