| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete dulipate rows by checking each and every cell in a row till end.
hi friends, iam trying to write macro for delete rows in a set of data by checking which row is greater than the other row and delete the lesser row. for example A B C D E F 1 1 0 1 1 0 1 2 1 0 0 1 0 1 3 0 1 0 0 1 0 4 1 0 1 0 1 1 5 0 0 1 0 0 1 FOR this data the marco should delete rows which are = to other rows answer should be like this A B C D E F 1 1 0 1 1 0 1 2 3 0 1 0 0 1 0 4 1 0 1 0 1 1 5 2ND row is delete because 1st row is greater than the 2nd row 5th row is deleted because 4th row is greater than the 5th row can any one plz help me rearding this marco. thanks sreedhar -- sreedhar ------------------------------------------------------------------------ sreedhar's Profile: http://www.excelforum.com/member.php...o&userid=27582 View this thread: http://www.excelforum.com/showthread...hreadid=471039 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy cell contents in empty rows below it till any unempty row com | Excel Discussion (Misc queries) | |||
| Delete rows on Cell | Excel Discussion (Misc queries) | |||
| Spell Checking with checking cell notes | Excel Discussion (Misc queries) | |||
| Checking specific cell, and identifing how many rows in the sheet | Excel Programming | |||
| Delete rows after used cell? | Excel Programming | |||
Threaded Mode
