Ignore duplicates
The following formula is in K and will return the value in A when the
conditions are met.
=INDEX(INDIRECT("$A$2:$A$5000"),MATCH(SMALL($H$2:$ H$5000,ROWS($IV$1:IV3)),$H$2:$H$5000,0))
Because A contains duplicate values these are returned to K
I want K to only return the same value once
What is the best way to achieve this?
|