LinkBack URL
About LinkBacks
Hi All,
a possible alternative approach (for Excel 2010 or newer)
no need to be confirmed with control+shift+enter
=IFERROR(INDEX(B$2:B$3270,AGGREGATE(15,6,ROW($A$2:$A$3270)-1/($A$2:$A$3270=J2),COUNTIF($J$2:J2,J2))),"")
Regards
Hi All,
a possible alternative approach (for Excel 2010 or newer)
no need to be confirmed with control+shift+enter=IFERROR(INDEX(B$2:B$3270,AGGREGATE(15,6,ROW($A$2:$A$3270)-1/($A$2:$A$3270=J2),COUNTIF($J$2:J2,J2))),"")
Regards
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks