Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting complex worksheets
Hard to explain what I need, but I have a complex worksheet full of
conditional formatting and linked data. I need a way of 'anchoring' a number of rows (inclusive of all cells within each row) to a specific cell in just one row, so that any sort function performed can sort the worksheet using this one specific cell, whilst keeping all other rows anchored to it in the same relative position with all formulas etc intact. A good summary example - a worksheet of individual staff, each staff member with multiple rows of data associated with them - how can you sort the worksheet alphabetically by staff member whilst keeping all of their personal data in the same relative position? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting complex worksheets
Select the entire table, then goto Data Sort Sort on 'staff member
column'. Regards, Per "Mark" skrev i meddelelsen ... Hard to explain what I need, but I have a complex worksheet full of conditional formatting and linked data. I need a way of 'anchoring' a number of rows (inclusive of all cells within each row) to a specific cell in just one row, so that any sort function performed can sort the worksheet using this one specific cell, whilst keeping all other rows anchored to it in the same relative position with all formulas etc intact. A good summary example - a worksheet of individual staff, each staff member with multiple rows of data associated with them - how can you sort the worksheet alphabetically by staff member whilst keeping all of their personal data in the same relative position? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
complex color fill conditions- if statements or complex formula? | Excel Discussion (Misc queries) | |||
Formula or macro needed for sorting complex data issue. | Excel Discussion (Misc queries) | |||
Complex Array sorting issue | Excel Worksheet Functions | |||
Complex Sorting | Excel Discussion (Misc queries) | |||
Complex Sorting Problem | Excel Worksheet Functions |