Hi everyone!

I have this formula below it will return multiple results is it
possilbe to modified it that it will return multiple results
_but_ignore_duplicates._ I would like it to be a stand alone formula no
helper cells or helper columns.


=INDEX(B$2:B$15,SMALL(IF(A$2:A$15=E$2,ROW(A$2:A$15 )-ROW($A$2)+1),ROW(A1)))


--
vane0326
------------------------------------------------------------------------
vane0326's Profile: http://www.excelforum.com/member.php...o&userid=14731
View this thread: http://www.excelforum.com/showthread...hreadid=546922