I have attached a test file that explains my requirement.
Thanks in advance
I have attached a test file that explains my requirement.
Thanks in advance
Hi,
Try the following in F2:
=SUMPRODUCT((A$3:A$12=D2)/COUNTIF(B$3:B$12,B$3:B$12))
f2=SUMPRODUCT((FREQUENCY(INDEX(MATCH($B$2:$B$9,$B:$B,0)*($A$2:$A$9=$D2),0),ROW($B$2:$B$9))>0)+0)-1
Try this and copy towards down
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Thanks for response - works perfectly!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks