How to find most previous or oldest day in a column
 

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

How to find most previous or oldest day in a column
 

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

"MSSailor" wrote:

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

How to find most previous or oldest day in a column
 

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

"MSSailor" wrote:

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

How to find most previous or oldest day in a column
 

I got everything it works great THX

"MSSailor" skrev:

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

"MSSailor" wrote:

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