Change ($A$5:$A$9<A5) to ($A$5:$A$9>A5)
=(SUMPRODUCT(($B$5:$B$9=B5)*($A$5:$A$9>A5))+1)+COUNTIFS($A$5:A5,A5,$B$5:$B5,B5)-1
Change ($A$5:$A$9<A5) to ($A$5:$A$9>A5)
=(SUMPRODUCT(($B$5:$B$9=B5)*($A$5:$A$9>A5))+1)+COUNTIFS($A$5:A5,A5,$B$5:$B5,B5)-1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks