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