vlook

hi again,

What would be the simplest way if: i had three columns. with values.

i.e

A B C
DATE 1/1/06 N/A N/A
N/A 7/3/06 N/A

and i wanted to grab only the data with dates in it and put it into a final column.
i.e
1/1/06
7/3/06

i tried diong a complicated if statement. but my heard hurt :S

would greatly appreciate any advice.

thanks!

Joel

Hi Joel,

Assuming your first row contains headings, enter the following formula into your first destination cell and fill down as required:

=IF(ISERROR(DATEDIF(A2,NOW(),"d"))=FALSE,A2,IF(ISERROR(DATEDIF(B2,NOW(),"d"))=FALSE,B2,C2))

HTH

Robert

hi Robert, thanks for that.
it works on most of them. however there are a few that have the ?name error on it.

one is layed out like this:
#N/A #N/A 27/10/2006
returns name error.

any ideas?

cheers

Joel

Hi Joel,

Somehow a space (in the second ISERROR function) has gotten into the formula. Take this out and all should be fine.

Let me know how it goes.

Cheers,

Robert