How about doing it with formulas?
Insert 2 more columns c + d
formula in c2 = if(a2<a1,a2,"")
formula in d2 = if (b2<b1,b2,"")

Copy these down and you can then hide A and B to display your required
output.

Chris

"Sean" wrote in message
...
I have a workbook open with about 22,000 rows in it. It has data like this

A B C D

SD FRED 3 9
SD FRED 4 2
SD FRED 6 27
SF SAM 3 6
SF SAM 4 8
SF SAM 6 1

Now A and B continually shows the same info and C and D are what changes,
I
want to clear the contents on columns A and B if it sees the same in A and
B
twice, before jumping to the next row. So the data would look like this
when
through

A B C D

SD FRED 3 9
4 2
6 27
SF SAM 3 6
4 8
6 1

Same data but it only shows me the vendor and the name once and then
continues on with the rest of the data. Any ideas anyone!!! Thanks in
advance

Sincerely

Sean