I have a single excel worksheet. I want to replace text in column F IF both Column C has a particular text ("apple" and Column F has a particular number ("56"). I want the replacement value for the Cell in Column F to be "1".
To summarize, if c3=apple and f3=56, I want f3 to be changed to 1.
But if c3 is anything but apple or f3 anything but 56, I do not want anything changed.
Aucun commentaire:
Enregistrer un commentaire