| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
unique sorting
Hi,
I have a large amount of data broken up into different columns on excel. Under my companies listings I have several listed dozens of times and some listed only once. Is there away I can sort the companies so I only get one mention of each company? I'm aware this can be done in access and dbase. Can it be done in Excel? Thanks, Bob |
|
#2
|
|||
|
|||
|
You can use an Advanced Filter to show the unique items in place, or in
a new list. There are instructions in Excel's Help, and he http://www.contextures.com/xladvfilter01.html Bob R. wrote: I have a large amount of data broken up into different columns on excel. Under my companies listings I have several listed dozens of times and some listed only once. Is there away I can sort the companies so I only get one mention of each company? I'm aware this can be done in access and dbase. Can it be done in Excel? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| Sorting Spreadsheet with Merged Fields | Excel Discussion (Misc queries) | |||
| find rows for unique data in 1 column and different data in other. | Excel Discussion (Misc queries) | |||
| compare unique identifiers in multiple ranges | Charts and Charting in Excel | |||
| sorting question | Excel Discussion (Misc queries) | |||
Linear Mode
