ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Lookup/sort values (https://www.excelbanter.com/excel-programming/349412-lookup-sort-values.html)

Paulymon

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