In my example Ashish appears multiple times (A1,A4,A7)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"nikko" wrote in message
...
Hi
Having some issues with below formula; any assistance / help will be
appreciated

1) wish to return multiple unique values, however below forula is
returning
the results twice if the identifier appears twice in the raw data
spreadsheet... Any idea how to resolve this?
INDEX('Closed To Date'!$A$1:$K$9926,SMALL(IF('Closed To
Date'!$A$1:$A$9926=$C$4,ROW('Closed To Date'!$A$1:$A$9926)),ROW(1:1)),10))

A1: K9926 - raw data
Col A - identifier, same identifier can appear twice or thrice in the raw
data spreadsheet


--
nikko