Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find previous number and find next number in column | Excel Discussion (Misc queries) | |||
Finding the oldest date in a column | Excel Worksheet Functions | |||
Find Oldest Date | Excel Discussion (Misc queries) | |||
find a value in a table, go to the previous column and add that co | Excel Worksheet Functions | |||
Need to find oldest date in ever changing list. | Excel Worksheet Functions |