LinkBack URL
About LinkBacks
Hi can someone explain to me why my formula in the yellow cells isn't working please.
Any advice would be great!
Thanks
Hi can someone explain to me why my formula in the yellow cells isn't working please.
Any advice would be great!
Thanks
=INDEX($E$7:$E$73,SMALL(IF($F$7:$F$73=C7,ROW($F$7:$F$73)-ROW($F$7)+1),COUNTIF($C$7:C7,C7)))
or
=IFERROR(INDEX($E$7:$E$73,SMALL(IF($F$7:$F$73=C7,ROW($F$7:$F$73)-ROW($F$7)+1),COUNTIF($C$7:C7,C7))),"")
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
=INDEX($E$7:$E$73,SMALL(IF($F$7:$F$73=C7,ROW($F$7:$F$73)-ROW($F$7)+1),COUNTIF($C$7:C7,C7)))
or
=IFERROR(INDEX($E$7:$E$73,SMALL(IF($F$7:$F$73=C7,ROW($F$7:$F$73)-ROW($F$7)+1),COUNTIF($C$7:C7,C7))),"")
Your ROW() offset must have the same size as the IF
that is awesome!!
Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks