Query in excel

  • Thread starter Thread starter Ashwini
  • Start date Start date
A

Ashwini

Hi,

I have list of list of around 5000 companies, but in that, companies are
repeated. How do I delete the repeated companies?

Sorting will not work in this.

Regards,
Ashwini
 
This newsgroup is for questions about Access, the database product that's
part of Office Professional.

If you're trying to do this in Excel, you'd be best off reposting to a
newsgroup related to Excel.

If, on the other hand, you're working in Access, linked to an Excel
spreadsheet, create a query and make it a DISTINCT query. The easiest way,
in my opinion, is to create the query, then go into the SQL view (how
exactly you do this depends on what version of Access you're running) and
change the SELECT at the beginning to SELECT DISTINCT.
 
If this is an Excel question, you're asking the wrong people. This is an
Access database forum.
 
Back
Top