LinkBack URL
About LinkBacks
Yes, use the same formula and replace TRUE with FALSE.
=IFERROR(INDEX(C:C,AGGREGATE(15,6,ROW($B$3:$E$4)/(($B$3:$B$4=G3)*($E$3:$E$4=FALSE)),ROWS(I$3:I3))),"")
Yes, use the same formula and replace TRUE with FALSE.
=IFERROR(INDEX(C:C,AGGREGATE(15,6,ROW($B$3:$E$4)/(($B$3:$B$4=G3)*($E$3:$E$4=FALSE)),ROWS(I$3:I3))),"")
Last edited by AlKey; 04-07-2015 at 08:54 AM. Reason: Updated formula
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks