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

Removing duplicates
 

So this is what you want... Why didn't you say this the last time you
posted? Anyway, put some titles in the first row (like A, B, C, and D in row
1) click the 1 on the upper left of the spreadsheet, then click Data Filter
AutoFilter and click the B-column and select 5, then click the C-column and
select 5. There you go!

regards,
Ryan--

--
RyGuy


"Eric" wrote:

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