hiding duplicates

[SalamanderSam14]

i have a sheet which has duplicated data on, I want to set it up so that if duplicted data appears then it will hide all bar one of them. eg

bob
bob
ben
bill
george
matt
bob

=

bob
ben
bill
george
matt

[martindwilson]

use auto filter,advanced filter,unique values only,filter in place

[SalamanderSam14]

where is that in excel 2010?

[martindwilson]

good question! probably under data

[martindwilson]

good question! probably under data,yep its the data tab (i don't have 2010 just had to check)

[grizzly6969]

another way would be to use Conditional Format >>> in cell A2 use this formula

=countif($A$1:A2,A2)>1

now format font to white --- highlight cell A2 and copy and highlight cells down as far as required and paste special / formats / ok