distinct recordset in worksheet

  • Thread starter Thread starter Grey
  • Start date Start date
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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount (multiple criteria) 3
Filter by criteria in one row - display that row and previous row 3
SELECT DISTINCT query 8
Loading recordset at runtime 4
Select Distinct query 8
Hitting the limits with Excel and need about 1 million rows of data.What is the best option for what 1
Create a distinct Join 3
Macro to copy value in field and insert it into filter 2

Back
Top