If with Array

  • Thread starter Thread starter Kay
  • Start date Start date
K

Kay

I need to compare two dates, and if one date is greater
than the other I need to copy several cells from another
file into a column.

Any ideas for a formula?

Thanks for the help - Kay
 
Copy cannot be down with a formula, just VBA.

You could use several reference formulae that check the same field, such as

H1: =IF($A$1>$B$1,C1,"")

and copy down.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top