Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup/sort values
If someone could advise me on an efficient way to do this I would appreciate
it. I have a sheet that shows the amount of time(col A) a machine is in mode (40, A0, 22, B0...)(col B). These columns cannot be sorted in the sheet that it's on. It's set up similar to this: A B 1 6:00 40 2 3:00 A0 3 2:00 22 4 5:00 40 5 1:00 B0 6 4:00 A0 I would like a second sheet that would display all of the machine codes in seperate columns like this: A B C D E 1 downtime code 22 A0 40 B0 2 2:00 3:00 6:00 1:00 3 4:00 5:00 So each time would be listed in a column for that particular downtime code. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
i wish to lookup values in column A, & add adjacent values in colu | Excel Discussion (Misc queries) | |||
Some sort of Lookup? | Excel Worksheet Functions | |||
Sort then lookup | Excel Discussion (Misc queries) | |||
Advanced Lookup (lookup for 2 values) | Excel Worksheet Functions | |||
How do I lookup and return different values when the lookup value. | Excel Discussion (Misc queries) |