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