Julie,

Will do, if I get the workbook from Carl.

HTH,
Bernie
MS Excel MVP


"JulieD" wrote in message
...
Hi Bernie

would be interested in any feedback with regards to the CONCAT_RANGE
function that you might have.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
...well i'm working on it anyway
"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
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.