View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Eric Eric is offline
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