I have a worksheet which contains a list of names. Some names appear once,
some twice, some three times and so on. I would like a formula that would
return a list of all the names that appear say twice.

Anyone got any ideas?