Thread: Need help with Indexing and Small Function in MS Excel 2010
View Single Post
 
Old 11-07-2017, 09:47 AM
NBVC's Avatar
NBVC NBVC is offline Windows 10 Office 2013
The Formula Guy
  
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default
If there is a possiblity of repeated %Trace values, then you might need to use this array formula:

=INDEX(A$3:A$15,SMALL(IF($M$3:$M$15=$M18,ROW($M$3: $M$15)-ROW($M$3)+1),COUNTIF($M$18:$M18,$M18)))

confirmed with CTRL+SHIFT+ENTER not just ENTER and copied down and over.

This will get the unique matches for the repeated percentages
Reply With Quote