Hi Max

I'm trying to look-up my source data and only return the multiple unique
values.
However the formulas i'm using are returning the multiple values (including
dupes)

INDEX(Closed YTD_1'!$A$1:$M$9908,SMALL(IF('Closed
YTD_1'!$A$1:$A$9908=$C$4,ROW('Closed YTD_1'!$A$1:$A$9908)),ROW(1:1)),11))

any idea how this can be fixed?

--
nikko


"Max" wrote:

welcome, manxman.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"manxman" wrote in message
...
Thanks Max, that does the trick. Now I'll study for awhile to try and
understand your solution, and then see if I can get it to work on the real
data.