I need a forumla to look at sheet 1 coloum J and see how many unique record there are. ie.
Coloum J
John
John
Andy
Mark
Mark
Mark
Irvine
Irvine

the answer would be John Andy Mark Irvine. Please could someone help me the formula I have had some trouble with it.

Also once its found unique records I need it to do a counit if for each of them in that coloumn

the answet being
b2 b3
John 2
Andy 1
Mark 3
Irvine 2

plus all this info needs to be paste in B2 sheet 2

Help please spent 4 days on this cant make heads or tails of it.