Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 23rd 05, 07:10 PM
Junior Member
 
First recorded activity by ExcelBanter: May 2005
Posts: 11
Default sort a list/remove additional entries

Okay, I have a coumn with like 10,000 lines. They have maybe 70 different names in them. I need to find out what all names od categories are in there. Without having to search line by line. Is there a way to do this?

Thanks,

Glowinafuse

  #2   Report Post  
Old May 23rd 05, 08:03 PM
Biff
 
Posts: n/a
Default

Hi!

Use an advanced filter to copy the unique values to a different location.

Biff

"Glowinafuse" wrote in message
...

Okay, I have a coumn with like 10,000 lines. They have maybe 70
different names in them. I need to find out what all names od
categories are in there. Without having to search line by line. Is
there a way to do this?

Thanks,

Glowinafuse


--
Glowinafuse



  #3   Report Post  
Old May 23rd 05, 08:24 PM
Ola
 
Posts: n/a
Default

To Count Unique items, see this link:
http://www.excelforum.com/showthread...wpost&t=373153

To Create a list with only the Unique items, see this link:
http://www.excelforum.com/showthread.php?t=372854

Hope it helps
Ola Sandström
  #4   Report Post  
Old May 23rd 05, 08:26 PM
bj
 
Posts: n/a
Default

check out <data<filter<advanced filter unique data

"Glowinafuse" wrote:


Okay, I have a coumn with like 10,000 lines. They have maybe 70
different names in them. I need to find out what all names od
categories are in there. Without having to search line by line. Is
there a way to do this?

Thanks,

Glowinafuse


--
Glowinafuse

  #5   Report Post  
Old May 23rd 05, 08:26 PM
CLR
 
Posts: n/a
Default

Click on an item in the column, then Data Filter AutoFilter.......then
click on the arrow at the top of the column......the drop-down box will have
one entry for each unique item on the list.........to get out of the
AutoFilter mode, just do Data Filter AutoFilter again, it's a toggle......


Vaya con Dios,
Chuck, CABGx3



"Glowinafuse" wrote:


Okay, I have a coumn with like 10,000 lines. They have maybe 70
different names in them. I need to find out what all names od
categories are in there. Without having to search line by line. Is
there a way to do this?

Thanks,

Glowinafuse


--
Glowinafuse



  #6   Report Post  
Old May 23rd 05, 10:32 PM
Gord Dibben
 
Posts: n/a
Default

Glow

You can use FilterAdvanced Filter to obtain a list of uniques in the column.

See Debra Dalgleish's site for info with pictures.

http://www.contextures.on.ca/xladvfilter01.html

Note: you can copy the list to another sheet or range.


Gord Dibben Excel MVP

On Mon, 23 May 2005 19:10:40 +0100, Glowinafuse
wrote:


Okay, I have a coumn with like 10,000 lines. They have maybe 70
different names in them. I need to find out what all names od
categories are in there. Without having to search line by line. Is
there a way to do this?

Thanks,

Glowinafuse




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I sort by row instead of by column? PercivalMound Excel Worksheet Functions 7 August 28th 06 10:41 PM
How do I sort a column of data and have each data row sort accordi Oedalis Excel Discussion (Misc queries) 1 March 17th 05 11:52 PM
"-" ignored in sort Mike H Excel Discussion (Misc queries) 8 January 2nd 05 07:48 AM
HELP! How do you--> Lock a set of rows but also link worksheets to FRUSTRATED Excel Discussion (Misc queries) 6 December 29th 04 10:05 PM
Excel Sort function should not sort the cell formatting! Lisa D.N.1 Excel Worksheet Functions 1 December 28th 04 08:37 PM


All times are GMT +1. The time now is 04:51 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright ©2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017