Need Excel Macro or Formula for finding duplicated cells more than 5 times and copy them into new sheet.
Can you please help me with that ?

For Example;


apple
orange
apple
banana
apricot
apple
orange
apricot
fruit
lemon
lime
plum
apple
banana
orange
apple
orange
orange

OUTPUT in new Sheet will be

apple 5
orange 5