| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
data in 2nd column associated with =MAX(H1:H100) from another colu
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
data in 2nd column associated with =MAX(H1:H100) from another colu
Kind of vague, maybe this:
Assume you have this formula in cell A1: =max(date1...date31) Then: =INDEX(Sheet1!B:B,MATCH(A1,Sheet1!A:A,0)) -- Biff Microsoft Excel MVP "tcek" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
data in 2nd column associated with =MAX(H1:H100) from another colu
Hi,
A least for me you will have to explain this a bit more clearly and preferably with some sample data and expected result. Mike "tcek" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count how many rows contain nonblank in column A and blank in colu | Excel Discussion (Misc queries) | |||
| Sum of items in a column if they meet two criteria in another colu | Excel Worksheet Functions | |||
| How do I auto populate a column with information from another colu | Excel Discussion (Misc queries) | |||
| How can I find the minium date in column B subject to data in Colu | Excel Discussion (Misc queries) | |||
| When I change the style in column (a) a date, it also changes colu | Excel Discussion (Misc queries) | |||
Linear Mode
