How do I put a cell value into a cell when the range of cell contain a specfic text.
For example, in the sample below, I want to put the cell value (13/2/2014) into B3 when a range of cell (A) contain Sam.
Is it possible as well that I can copy the cell value (13/2/2014) to all fields in column B till it reaches TOM (A1) for example?
Please enlighten me.
Excel if range contains text then return value in another cell
Excel if range of cells contains specific text then return value - Best answers
Excel if range of cells contains specific text - Best answers