Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lock sets of cells in a row and sort by date linked to each set
I have a set of qualifications linked to a name that need to be presented in
a row A = Name B = Qual Type 1 C = Expiry Date (eg 29/01/12) D = Qual Type 2 E = Expiry Date (eg 17/12/12) F = Qual Type 3 G = Expiry Date (eg 25/06/11) H = Qual Type 4 (has no expiry date) I want to sort each qualification into 'date expiry' order keeping it connected to the relevant Qual Type. Therefore, I want Qual Type 3 with it's exipiry date to move into Column B & C, Qual Type 1 with it's exipiry date to move into Column D & E and Qual Type 2 with it's exipiry date to move into Column F & G. I also want to keep Qual Type 4 (with no expiry date) at the end of the row. Not all Names would have all 4 qualifications, they would have between 1 & 4, this would mean that for some Column D & E are blank before the sort. I would have up to 1000 Names on the worksheet. Is this at all possible? Any ideas would be greatly appreciated. Thank you! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I leave linked cells that do not contain a date | Excel Discussion (Misc queries) | |||
Creating Multiple Worksheet Sets Containing Linked Cells | Excel Discussion (Misc queries) | |||
Excel - Lock date in multiple cells | Excel Worksheet Functions | |||
How do I sort linked cells ? | Excel Discussion (Misc queries) | |||
sort 2 or more rows of cells linked to one row of data | Excel Worksheet Functions |