good morning fellas
needing a formula to auto sort as values in column H change. i had this before but cant seem to get my old formula to work.
needing a formula to auto sort as values in column H change. i had this before but cant seem to get my old formula to work.
Excel 2012 | |||||||
---|---|---|---|---|---|---|---|
G | H | I | J | K | |||
1 | data sample | expected results | |||||
2 | busy | 27 | material | 158 | |||
3 | fire alarm | 1 | machine maint | 98 | |||
4 | hot runner | 36 | robot | 60 | |||
5 | machine maint | 98 | other | 53 | |||
6 | material | 158 | hot runner | 36 | |||
7 | nozzell change | 6 | |||||
8 | robot | 60 | and so on. | ||||
9 | thermolater | 9 | |||||
10 | tool problem | 31 | |||||
11 | water leak | 9 | |||||
12 | other | 53 | |||||
13 | aa | 0 | |||||
14 | bb | 0 | |||||
15 | cc | 0 | |||||
16 | dd | 0 | |||||
17 | ee | 0 | |||||
18 | ff | 0 | |||||
Sheet1 |