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: 1,670
Default Removing duplicates

Can anyone tell me if you can use 2 criterias and how to write it for
removing duplications. I am currently removing duplicates for one criteria
but now I want to refine this to remove more information and use just one
macro to do both.

ie:
row A B C
1 5 5 6
2 5 3 8
3 5 5 6
4 4 4 4
5 4 4 4
6 5 5 6

This is what I need ... in Column A remove duplication (I pick 5 out of the
list box) Now my info will look like this: (I have the macro working up to
this step)

row A B C
1 5 5 6
2 5 3 8
3 5 5 6
4 5 5 6

Next remove duplications from Column B (I pick 5 again from column B).
Now my info will look like this: (Have a second macro to do this step from
the one above)

row A B C
1 5 5 6
2 5 5 6
3 5 5 6

I would like this all to be done in one macro...Is it possible?
Autofilters do not work because all information will be graphed....

Eric
 
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
Removing duplicates Tdp Excel Discussion (Misc queries) 6 November 27th 08 12:33 AM
Removing Duplicates Danielle Excel Worksheet Functions 5 March 10th 06 07:56 PM
removing duplicates robhargreaves Excel Discussion (Misc queries) 1 July 24th 05 12:35 AM
Removing Duplicates sat Excel Discussion (Misc queries) 5 June 18th 05 11:18 PM
Removing Duplicates sat Excel Worksheet Functions 1 June 18th 05 11:18 PM


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