display cell vallue depending on the condtion

  • Thread starter Thread starter fazlici
  • Start date Start date
F

fazlici

Hello,
This is my problem:

I am trying to clean the records up so if (e.g.) A2=FEB 29/04
(imported form another program so therefore not formatted as a date but
as general) than I would like to have value of A1 copied to a Sheet2.

Any the help is very much appreciated,
Jas
 
Functions cannot copy cells, only return results.

In a cell on Sheet2.......

=IF('Sheet1'!A2="Feb 29/04",'Sheet1'!A1,"")

If you want it moved("clean the records up") you would have to use VBA to
achieve that.

Gord Dibben Excel MVP
 
Back
Top