Create a conditional formula to replace
Hi,
How could I check if the cell in a column starts with a certain alphabet, if
yes, then in a different columns cell add the word "DONE"
eg: validate column P, if a cell starts with XYZ, then in coulmn B, of the
same row, add the word "DONE"
|