LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Michael
 
Posts: n/a
Default Picking unique Items


Can someone help advise the macro or code to pull out unique items from an
array.

Don't want to sort and manually pick them out.

Eg.

Apple
Banana
Apple
Orange
Orange
Banana

Result required : Apple, Orange and Banana
 
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
retrieve unique items with 2 criteria Dave Breitenbach Excel Worksheet Functions 10 November 30th 05 11:16 PM
create an array with unique items IN MEMORY Werner Rohrmoser Excel Worksheet Functions 1 September 25th 05 02:55 PM
counting unique items tjtjjtjt Excel Discussion (Misc queries) 3 September 14th 05 05:47 AM
Finding unique items in data field for pivot tables [email protected] Excel Discussion (Misc queries) 2 July 15th 05 06:15 PM
Count of unique items meeting condition Tim C Excel Worksheet Functions 1 November 12th 04 03:03 AM


All times are GMT +1. The time now is 12:16 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"