Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot verify XNPV with PV or HP-12C | Excel Worksheet Functions | |||
Verify if Comment exist in a cell | Excel Discussion (Misc queries) | |||
Verify email | Excel Discussion (Misc queries) | |||
Several Dates -Verify | Excel Worksheet Functions | |||
Verify starting cell for macro | Excel Programming |