LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default Filter out duplicate data

I'm trying to write a macro that will filter out duplicate entries in a
column so that I can use the entries in that column to populate a combobox.
Here's an example of what I'm trying to do.

A
A
B
B
B
B
C
B
A
C
C
D
D

I want to filter the above data using code so that the end result is:

A
B
C
D

This doesn't seem like it should be that diffucult, but I'm having problems.
Maybe I just need a nap.

Anyways, any help provided will be much appreciated.

Thanks,
Jason



 
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
Filter to Duplicate Entries Only John T Kennedy[_2_] Excel Discussion (Misc queries) 2 April 17th 08 04:38 PM
Filter duplicate data in excel spreadsheet eholz1 Excel Programming 2 August 20th 07 08:10 PM
TRYING TO SORT OR FILTER DUPLICATE DATA areezm Excel Discussion (Misc queries) 3 June 7th 06 08:49 PM
How do I filter out duplicate values in Excel 2000? missy2992 Excel Worksheet Functions 4 November 22nd 05 02:38 PM
Is there an easy way to filter duplicate rows of data in excel? Yumin Excel Discussion (Misc queries) 1 October 7th 05 08:15 PM


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