Forum Discussion
Solved
Formula to count based on creteria but next creteria count should start from 2, instead of 1
Hi, I've a situation. below is a table in which I have put a count in running count using COUNTIFS($A$2:A2,A2,$B$2:B2,B2) and then nested the same in F column to uniquely identify the sku IF(COUN...
This solution doesn't require those helper columns:
=IF(COUNTIFS($A$2:A2,A2,$C$2:C2,C2)=1,XMATCH(C2,UNIQUE(FILTER($C$2:$C$9,$A$2:$A$9=A2))),0)
This solution doesn't require those helper columns:
=IF(COUNTIFS($A$2:A2,A2,$C$2:C2,C2)=1,XMATCH(C2,UNIQUE(FILTER($C$2:$C$9,$A$2:$A$9=A2))),0)
@Amazing, That is incredible. Thank you so much Patrick.
- You are welcome!