Hi,
I am looking for the following formula:
Col a col b
10 B
12
15. B
16
20. V
25
Column a represents numbers and column b represents letters B or V. I'm looking for a formula in column C that would calculate a division each time it encounters the first
B letter ignoring any subsequent B letters and the letter V. In the example above,
The calculation will be 20/10. Thx.
I am looking for the following formula:
Col a col b
10 B
12
15. B
16
20. V
25
Column a represents numbers and column b represents letters B or V. I'm looking for a formula in column C that would calculate a division each time it encounters the first
B letter ignoring any subsequent B letters and the letter V. In the example above,
The calculation will be 20/10. Thx.