Hi,
I use this formula, =COUNTIF($B$2:B2,B2), to count the number of duplicates in a sorted column and it works well (the first row with the value returns a 1; if the next row has the same B value as the previous, it returns a 2; and if the 3rd row does as well, a 3...and so on). It gives me the information I need, but my supervisor is asking me to explain it to her because she hasn't seen it before and she doesn't completely trust it yet.
The problem:
Someone told it to me and I never asked for an explanation, I just accepted it. So I don't fully understand it either. But I can't ask her to "just accept it" like I did.
Can someone please break down the formula for me so I can explain it to my supervisor?
thank you,
kb
Bookmarks