I am using the Match/Index/Large functions in a range that has duplicate values which returns only the first value encountered meeting the criteria. I want to index the second duplicate value and also the third and fourth duplicate value without using helper cells. Every solved example of this problem I have found uses helper cells.
See the attached sample sheet, What I want is in row 5 which returns the 3 items in row 2 that have the value of 15. What I get with a standard Index/Match formula is in row 7 which returns the same item 3 times (the first item encountered with a value of 15).
The order that the duplicates are returned does not matter.
Thanks
Bookmarks