LinkBack URL
About LinkBacks
As presented then
E4 copied down
=COUNTIFS($A$2:$A$11,D4)/MAX(1,COUNTIFS($A$2:$A$10,D4,$A$3:$A$11,D4))
As presented then
E4 copied down
=COUNTIFS($A$2:$A$11,D4)/MAX(1,COUNTIFS($A$2:$A$10,D4,$A$3:$A$11,D4))
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
It works perfectly, thank you!
There are actually a few cases where it does not work. E.g., it returns a decimal value in this example for the count of "1" using the formula you suggested:
Attachment 735207
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks