distinct recordset in worksheet

G

Grey

I have thousand of records input in excel worksheet. I need to filter out
records with some criteria. is there any default function (no need to write
any marco or VBA) for me to select records with criteria, such as distinct
records like SQL.

Million Thanks.
 
E

Earl Kiosterud

Grey,

Start with Autofilter. You can then copy the filtered (selected by
criteria) records and paste elsewhere. Or go on to Data - Advanced filter,
which will put them elsewhere for you.
 
Top