verify cell if is the same
 

I have 2500 row, i want to delete every second row
Except I have to verify if the cell ("A1") of the first row i
identical to the cell ("B1") of the second row.
If the cell ("B1") is identical of ("A1") delete the second ro
otherwise don't delete.
Pass to the third row check the cel ("C1") if is identical to ("D1"
delete the the fourth.
Until we dont we pass all the row.

Thank's
Benoi

--
Message posted from http://www.ExcelForum.com

verify cell if is the same
 

moving diagonally across the spreadsheet will exhaust the cells to check
when you reach the 256th row.

Maybe you could state exactly what you want to delete and what the actual
conditions to be checked are.

--
Regards,
Tom Ogilvy

"benny " wrote in message
...
I have 2500 row, i want to delete every second row
Except I have to verify if the cell ("A1") of the first row is
identical to the cell ("B1") of the second row.
If the cell ("B1") is identical of ("A1") delete the second row
otherwise don't delete.
Pass to the third row check the cel ("C1") if is identical to ("D1")
delete the the fourth.
Until we dont we pass all the row.

Thank's
Benoit


---
Message posted from http://www.ExcelForum.com/