thanks for your quick responses!

unfortunately, i just realized that the example i gave doesn't reflect
the scope of my issue.....please refer to this modified example:

A B
1 0
1 1
1 2
2 2
2 2
3 2
4 2
5 3
5 4
6 4
6 5

desired result:

A B
1 0
1 2
5 2
6 2
6 4

my apologies for overlooking this...pls let me know if this example is
not clear....thx again!


--
jellybean
------------------------------------------------------------------------
jellybean's Profile: http://www.excelforum.com/member.php...o&userid=37399
View this thread: http://www.excelforum.com/showthread...hreadid=570856