Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have the following table of data:
1 a 6.1 1 b 6.2 1 c 6.3 2 a 6.4 2 b 6.5 2 d 6.6 3 a 6.7 3 d 6.8 3 e 6.9 how can I sort this to become: a b c d e 1 6.1 6.2 6.3 0 0 2 6.4 6.5 0 6.6 0 3 6.7 0 0 6.8 6.9 any help is greatly appreciated? cheers |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lookups | Excel Discussion (Misc queries) | |||
Lookups... | Excel Worksheet Functions | |||
nested if based on nested if in seperate sheet. how? | Excel Worksheet Functions | |||
two lookups? | Excel Discussion (Misc queries) | |||
LOOKUPS - Creating LOOKUPs where two different values must BOTH be satisfied. | Excel Worksheet Functions |