Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting problem
This one has me stymied. My worksheet collects data in columns A and B
corresponding to ID and MonSales. This is repeated in columns C and D corresponding to ID and TueSales, and so on. Repeats of values in any column are allowed. My problem is that there are many instances where a row has no value of A or B. I have code that sorts A:B by A ascending, then B descending, but these 'blanks' go to the top of the sort. I don't know how to get rid of them. Deleting rows doesn't work because it interferes with the data in C:D, E:F, etc. Needless to say, this sorting needs to be done for each column pair. I would very much appreciate help with this. Thanks - Bri |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting problem | Excel Worksheet Functions | |||
Sorting Problem | Excel Discussion (Misc queries) | |||
Sorting problem | Excel Discussion (Misc queries) | |||
Sorting problem | Excel Programming | |||
Sorting problem | Excel Discussion (Misc queries) |