frankiejr101
Board Regular
- Joined
- Mar 7, 2008
- Messages
- 108
Not the usual. If A1:A7 is:
1
1
2
3
4
4
4
Then I'd like to have a formula that tells me how many duplicates it finds. So in this case B1 (where the formula would reside) would return a value of 2 since there were 2 sets of duplicates. Is this possible? Thanks!
1
1
2
3
4
4
4
Then I'd like to have a formula that tells me how many duplicates it finds. So in this case B1 (where the formula would reside) would return a value of 2 since there were 2 sets of duplicates. Is this possible? Thanks!