Query in excel

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
 
D

Douglas J. Steele

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.
 
J

Jerry Whittle

If this is an Excel question, you're asking the wrong people. This is an
Access database forum.
 

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

Run a Query that Excludes Values in A Table 4
News Advertised broadband speeds fall 41 per cent following rule change 6
What to use when Access can't handle the volume of data? 3
Query in excel 11
Sort of list within list within list 3
Combine the contents of a field so only one row is returned 4
Recommended UK companies for migrating from Access to SQL 2
Help with a query 2

Top