j5=IFERROR(INDEX($C:$C,SMALL(INDEX(($D$5:$D$17<>$G5)*10^10+ROW($D$5:$D$17),0),COLUMNS($J5:J5))),"")
Try this and copy across
j5=IFERROR(INDEX($C:$C,SMALL(INDEX(($D$5:$D$17<>$G5)*10^10+ROW($D$5:$D$17),0),COLUMNS($J5:J5))),"")
Try this and copy across
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks