LinkBack URL
About LinkBacks
In H6.. use Array Formula as
Formula:
=SUM(IF($D$6:$D$16=$G6,1/COUNTIFS($D$6:$D$16,$G6,$C$6:$C$16,$C$6:$C$16)))
To confirm the formula, press Ctrl + Shift + Enter, Not just Enter...
In H6.. use Array Formula as
Formula:=SUM(IF($D$6:$D$16=$G6,1/COUNTIFS($D$6:$D$16,$G6,$C$6:$C$16,$C$6:$C$16)))
To confirm the formula, press Ctrl + Shift + Enter, Not just Enter...
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks