distinct rows in a seperate worksheet

[Helpee]

Hi,
I need to select only distinct values from a column. Does anyone know how?

 

[Frank Kabel]

Hi
if you want to extract them use 'Data - Filter - Advanced Filter' and
check 'Unique entries'

 

[Gord Dibben]

Data>Filter>Autofilter?

Gord Dibben Excel MVP