| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
data associated with latest date
I have two columns. Column one has the dates of the month and the second
column has inventory amounts for that date. The inventory amounts is paste linked to another worksheet. I have the data in column 2 to show up in the linked worksheet for the latest date. I am using =max(date1...date31) to find the lasted date. Any suggestions to transfer the associated data to the linked field would be greatly appreciated |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with pulling data based on latest date for a year | Excel Discussion (Misc queries) | |||
| Filter latest date from multiple date entries | Excel Worksheet Functions | |||
| X axis date - display beyond latest date. | Charts and Charting in Excel | |||
| Need help to find a date (latest date) from a column | Excel Worksheet Functions | |||
| Pull latest date data - ignore the rest | Excel Worksheet Functions | |||
Threaded Mode
