Formula

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I have dates in column a and number data in the rest of
the column b and c. I will like to create a formula that
will give me the latest date in column a if there are
number data in column b and c. For example if a600 has a
date and c600 has data give me the latest date in column a
600?

Any suggestions?

Thanks!
 
I think that this is what you're looking for:

=LOOKUP(2,1/((ISNUMBER(B1:B999))*(ISNUMBER(C1:C999))),A1:A999)

Change the 999 to the number of rows you need.

And format the cell with the formula as a date.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
help with a formula please 3
Importing data from Excel worksheet into Excel template 2
Excel Help to copy information from one row at a time to another sheet 1
Complicated Formula to Distinguish, weather the License is Valid o 6
Need Array Formula for Counting Blank & Non Blank Cells (Multiple Criteria) 1
Formula Question 2
Conditional Sumproduct 0

Back
Top