| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to delete correct # of rows
For (2) Col A does not increment as they are acct #'s; Col B let me know the
maximum # of rows I can delete. Below I showed in a third col what i would like to happen... SAMPLE DATA: ACCT_NO Requests Found action to take 289278995 1 delete 289278999 1 keep 289278999 1 keep 289278999 1 delete 870587008 1 delete 119387014 1 delete 158675527 2 delete 654375649 2 delete 569777245 2 delete 752478468 2 delete 752478468 2 delete 396378512 2 delete 396378512 2 delete 396378512 2 keep 396378512 2 keep 399778090 3 delete 399778090 3 delete 399778090 3 delete 208777882 4 delete 208777882 4 delete 208777882 4 delete 208777882 4 delete 208777882 4 keep 987178737 4 delete 987178737 4 delete 117468837 7 delete 117468837 7 delete 117468837 7 delete 117468837 7 delete |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dup check 2 columns - need it to delete correct one | Excel Worksheet Functions | |||
| inserting correct number of rows | Excel Programming | |||
| Inserting Rows and Maintaining Correct Balances | Excel Discussion (Misc queries) | |||
| How to delete rows when List toolbar's "delete" isnt highlighted? | Excel Worksheet Functions | |||
| Delete every 3rd row, then delete rows 2-7, move info f/every 2nd row up one to the end and delete the row below | Excel Programming | |||
Threaded Mode
