View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dot
 
Posts: n/a
Default 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"