Hi all,
Having a slight issue in trying to achieve what I would like with the following data:
<tbody>
</tbody>
Having a slight issue in trying to achieve what I would like with the following data:
<tbody> </tbody> I would like to first check if the shot type is a winner or an error. If it is a winner, then copy and paste the value in column B into the Winner column(D), and put #NA () in the Error column. If the shot type was error then the value is copied in to the error column(E), and #NA () in to the Winner column (D). For column E I had thought I had achieved this with the following functions: For column D IF(A3="Winner",B3,NA()) IF(A3="Error",B3,NA()) <strike></strike>However, this won't work when the server changes and the value shifts to being in column C. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Can anyone help? (sorry I hope this makes sense!) | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
<tbody>
</tbody>