I would suggest that all the formula that you have suggested are a bit 'risky' in that if subsequently any rows are added at the top of the sheet, they would return incorrect results.
@kipper19
Here is another suggestion that you could try in your 2019 version.
If you are still not sure that you have a satisfactory answer from the various suggestions offered, please provide a larger set (say 8-10 rows) of
varied sample data and the expected results for that data, preferably with
XL2BB so that helpers can easily copy to test with that data.
23 10 22.xlsm |
---|
|
---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P |
---|
1 | | | | | R1 | R2 | R3 | R4 | R5 | R6 | R7 | R8 | R9 | R10 | R11 | R12 |
---|
2 | 10-Jun-23 1300m Hwavy 8 R11 RTG 66+ $2 | RTG 66+ $2 | | | | | | | | | | | | | | |
---|
3 | Hwavy 8 R2 RTG 67 | RTG 67 | | | | | | | | | | | | | | |
---|
4 | 10-Jun-23 1300m Hwavy 8 R3 RTG 68+ $100 | RTG 68+ $100 | | | | | | | | | | | | | | |
---|
5 | | | | | | | | | | | | | | | | |
---|
6 | abc | | | | | | | | | | | | | | | |
---|
7 | abc R12 def | def | | | | | | | | | | | | | | |
---|
|
---|