LinkBack URL
About LinkBacks
chococ 
Not sure if your results are as per expectation
There are 4 unique values for 666 and 2 for 777
Try
=SUMPRODUCT(($B$2:$B$10=D2)/COUNTIFS($A$2:$A$10,$A$2:$A$10&"",$B$2:$B$10,$B$2:$B$10&""))
Not sure if your results are as per expectation
There are 4 unique values for 666 and 2 for 777
Try
=SUMPRODUCT(($B$2:$B$10=D2)/COUNTIFS($A$2:$A$10,$A$2:$A$10&"",$B$2:$B$10,$B$2:$B$10&""))
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks