How to find most previous or oldest day in a column

  • Thread starter Thread starter MSSailor
  • Start date Start date
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
 
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
 
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 2
Need to pull <=14 Days, <=30 Days, >30 Days from a date column 3
Find then highlight in yellow 6
Number of hrs worked in a week, based on dates in a different column 1
How can I find the minium date in column B subject to data in Colu 3
how do i find the last specific value in a column? 8
use current date to find records that are in a period between 2 da 2
Trying to find out a solution for a complex formula 4

Back
Top