macro to condense rows of data to single row

Hello,

I need some help with writing a macro in excel 2007.
This is my case:

col A col B Col C
1 2 100
2 3 100
3 4 200
4 5 200

My result should be:

col A col B Col C
1 3 100
3 5 200

Assuming the numbers are in 3 columns, my macro should traverse the loop, condense as well as delete the redundant rows. Can anyone please help me with this.I apprectiate your help. Thanks in advance.

Originally Posted by StephenR

What is the logic behind this?

Col A is the Min "A" value for the matching column C values
Col B is the Max "B" value for the matching column C values