Forum Discussion
Index Match-Returning Duplicated Results
Trying to compare to different machines and their results on similar samples. Trying to pull specific sample type results over to another sheet (hidden) But when it does it, it repe...
If without 365 for such sample
in I4
=IFERROR(
INDEX(
$E$2:$E$10,
AGGREGATE(
15,
6,
1 / ($C$2:$C$10 = $H$3) *
(ROW($C$2:$C$10) - ROW($C$1)),
ROW() - ROW($H$3)
)
),
""
)and drag it down till empty cells appear