detect in each group with their suits
https://www.excelforum.com/attachmen...1&d=1543781951
detect in each group with their suits
https://www.excelforum.com/attachmen...1&d=1543781951
Try putting =IF(ISNUMBER(MATCH(I$4,$A5:$G5,0)),"x","") in I5 and dragging down and right.
To get the count of each of the groups, formulas like =COUNTIF(I5:S5,"x") should do it.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks