V
vane0326
Hi everyone!
I have this formula below it will return multiple results is i
possilbe to modified it that it will return multiple result
_but_ignore_duplicates._ I would like it to be a stand alone formula n
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))
I have this formula below it will return multiple results is i
possilbe to modified it that it will return multiple result
_but_ignore_duplicates._ I would like it to be a stand alone formula n
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))