Hi
I have the following data:
<tbody>
1
A
B
2
WT/PT
WTE
3
1
4
1
5
2
6
2
</tbody>
In general, in column A, 1=WTE and 2=PTE.
In column B, I need cell B3 to say:
- if cell A3 contains "1", then "WTE". If cell A3 contains "2", then "PTE". If neither, then leave cell blank.
Any...