![]() |
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. |
All times are GMT +1. The time now is 07:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com