Davebro
Board Regular
- Joined
- Feb 22, 2018
- Messages
- 135
- Office Version
- 365
- 2021
- 2016
- Platform
- Windows
Is it possible to compare the numbers in text and say if column A is Up or down from column B.
(Class 1 is better than class 2).
(Class 1 is better than class 2).
Book2 | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Class 6 | Class 6 | |||
2 | Class 6 | Class 6 | |||
3 | Class 3 | Class 4 | Up | ||
4 | Class 4 | Class 4 | |||
5 | Class 5 | Class 6 | Up | ||
6 | Class 5 | Class 5 | |||
7 | Class 4 | Class 3 | Down | ||
8 | Class 4 | Class 4 | |||
9 | Class 4 | Class 4 | |||
10 | Class 6 | Class 5 | Down | ||
11 | Class 4 | Class 4 | |||
12 | Class 6 | Class 6 | |||
Sheet1 |