How to find most previous or oldest day in a column

M

MSSailor

I have number of columns with date, distance, type of activity, type of weather

March 05 2009, 16, swimming, snowing
March 12 2009, 4, walking, snowing
March 11 2009, 21, riding, sunny
March
I want in another place in the same workbook in one row
Latest date as primary, then that date distance and activity.

How to do it. Have Excel2000. But shouldnt be an issue. Is so easy for the
one who knows. THX
 
M

Mike H

Hi,

dates are numbers in Excel so MIN returns the oldest date so this formula

=VLOOKUP(MIN($A$1:$A$3),$A$1:$D$3,COLUMN(B1),FALSE)

Finds the oldest date and looks up column C
Drag this formula right to get the other columns

Mike
 
M

MSSailor

What stands Column (B1) for?

"Mike H" skrev:
Hi,

dates are numbers in Excel so MIN returns the oldest date so this formula

=VLOOKUP(MIN($A$1:$A$3),$A$1:$D$3,COLUMN(B1),FALSE)

Finds the oldest date and looks up column C
Drag this formula right to get the other columns

Mike
Click to expand...
 

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

How to find the date of the last activity 3
Find then highlight in yellow 6
how to find a last value in a column in excel 1
How to choose only the first record from a query 4
use current date to find records that are in a period between 2 da 2
to specify a read-only Recordset in Access 2003 Visual Basic 6
How to find the most recent date in a column based on other column 7
How to change fonts in a word macro 1

Top