LinkBack URL
About LinkBacks
A different method, also an array formula:
G5: =SUM(IF(FREQUENCY(IF(($A$4:$A$22=F5)*($C$4:$C$22=1),MATCH($B$4:$B$22,$B$4:$B$22,0)),ROW($B$4:$B$22)-ROW($B$4)+1),1))
A different method, also an array formula:
G5: =SUM(IF(FREQUENCY(IF(($A$4:$A$22=F5)*($C$4:$C$22=1),MATCH($B$4:$B$22,$B$4:$B$22,0)),ROW($B$4:$B$22)-ROW($B$4)+1),1))
Spread the love, add to the Rep
"None of us are as smart as all of us."
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks