LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 16
Default help with making a function to filter lists

hello. i am trying to sort through a list of data by displaying only one
occurance of a name from one column that has many repeating names into a new
column.

ex:

A B C
1 apple
apple
apple
pear
pear
apple
pear
orange
orange
orange
banana
banana

is it possible to show in column "B" only one "apple", one "pear", one
"orange", one "banana", etc? thanks in advance for your help.
 
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
Making wider drop down List for Filter [email protected] Excel Worksheet Functions 0 October 1st 07 02:32 PM
Filter lists JRTB Excel Discussion (Misc queries) 2 May 7th 07 10:38 AM
Making multiple selections from Excel drop down lists Andyroo Excel Worksheet Functions 7 August 17th 06 03:16 AM
Filter arrows on drop down lists HRman Excel Discussion (Misc queries) 0 April 5th 06 10:01 AM
Making individualized word lists from a SS Rod ElEd Excel Discussion (Misc queries) 2 March 22nd 06 10:52 PM


All times are GMT +1. The time now is 05:47 AM.

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"