LinkBack URL
About LinkBacks
In E2 Cell – Array Formula – Requires CTRL+SHIFT+ENTER
Formula:
=IFERROR(INDEX($B$2:$B$85,SMALL(IF($A$2:$A$85=E$1,ROW($A$2:$A$85)-ROW($A$2)+1),ROW($A1))),"")
Drag it down and right…
In E2 Cell – Array Formula – Requires CTRL+SHIFT+ENTER
Formula:=IFERROR(INDEX($B$2:$B$85,SMALL(IF($A$2:$A$85=E$1,ROW($A$2:$A$85)-ROW($A$2)+1),ROW($A1))),"")
Drag it down and right…
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks