Question on UDF LookUpConcat

[K2`]

Hello, awesome function.

I just have one quick question, might be an easy fix, but how do I change the "SearchString" to say lookup any value greater than 0?

Ref: http://www.excelfox.com/forum/f22/lo...d-results-345/

Thanks in advance!

[jgalper]

Rick,

The information I am applying this to can give me results (always numbers) such as single numbers (2) or multiple numbers (2,4) but I have many instances where the result set is a sequential set of numbers (1, 2, 3, 4, 5). Is there a way to modify the code so the single numbers and multiple numbers will still be the way the code is set up (2 or 2,4), but if they are sequential numbers, use the minimum and maximum (i.e. 1, 2, 3, 4, 5 would become 1 - 5 or 11, 12, 13 would become 11-13)?