LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
news.zen.co.uk
 
Posts: n/a
Default Returning one text value in a long list?

I have a long list of names and would like excel to automatically return
just one of each name. For example, a list of 500 names, 10 different names
appearing 50 times each. How could I get excel just to list those ten names?


 
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
why won't vlookup work in a long list pkeegs Excel Worksheet Functions 9 August 2nd 05 02:28 PM
data validation list drop down text format too small Bruce Edwards Excel Worksheet Functions 3 May 22nd 05 07:28 PM
advanced filter - can't match a long text cell simpsons_rule Excel Discussion (Misc queries) 7 May 14th 05 11:00 PM
Filter long Text strings Cimorene Excel Worksheet Functions 0 December 1st 04 04:01 AM
Counting Repeated text or duplicates in a list Repeatdude Excel Discussion (Misc queries) 5 November 26th 04 07:10 PM


All times are GMT +1. The time now is 02:44 PM.

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

About Us

"It's about Microsoft Excel"