LinkBack URL
About LinkBacks
You can use this formula in M12
=INDEX(B$7:B$15,SMALL(IF((A$7:A$15=K12)*(C$7:C$15=L12),ROW(B$7:B$15)-ROW(B$7)+1),COUNTIF(L$12:L12,L12)))
confirmed with CTRL+SHIFT+ENTER and copied down
That will cope with duplicate values in L12:L14
You can use this formula in M12
=INDEX(B$7:B$15,SMALL(IF((A$7:A$15=K12)*(C$7:C$15=L12),ROW(B$7:B$15)-ROW(B$7)+1),COUNTIF(L$12:L12,L12)))
confirmed with CTRL+SHIFT+ENTER and copied down
That will cope with duplicate values in L12:L14
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks