Assist with formula
Assuming your data begins in A1 and is sorted as in your example:
In B1: =COUNTIF(A:A,A1)&" of "&A1
In B2: =IF(A2=A1,"",COUNTIF(A:A,A2)&" of "&A2)
Copy B2 down
Hope this helps,
Hutch
"Soth" wrote:
Hi-
I'm interested in a formula medthodology rather than pivoting and advance
filter.
I'd like to look up numbers that are duplicate and more than one duplicate,
then show the result of duplicate. e.g..
A B
1 3 of 1
1
1
2 4 of 2
2
2
2
3 2 of 3
3
Thanks
Soth
|