Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Returning adjacent values
I have a column A with dates and column B with data. I'm trying to create a
summary sheet. I use the max function on column B, which is easy, but I am also trying to place the corresponding date (to the max value) on the summary sheet as well. I've tried using the lookup function but it seems to return the last value in the date row? Any help would be greatly appreciated |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Returning adjacent values
Try this:
=INDEX(A:A,MATCH(MAX(B:B),B:B,0)) -- Biff Microsoft Excel MVP "chris miller" <chris wrote in message ... I have a column A with dates and column B with data. I'm trying to create a summary sheet. I use the max function on column B, which is easy, but I am also trying to place the corresponding date (to the max value) on the summary sheet as well. I've tried using the lookup function but it seems to return the last value in the date row? Any help would be greatly appreciated |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Returning adjacent values
Have a look at the INDEX and MATCH functions.
Pete "chris miller" <chris wrote in message ... I have a column A with dates and column B with data. I'm trying to create a summary sheet. I use the max function on column B, which is easy, but I am also trying to place the corresponding date (to the max value) on the summary sheet as well. I've tried using the lookup function but it seems to return the last value in the date row? Any help would be greatly appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Sum of Values based on adjacent list selection | New Users to Excel | |||
Calculations based on adjacent cell values | Excel Discussion (Misc queries) | |||
summing values from adjacent column with refrence from adjacent column | Excel Discussion (Misc queries) | |||
Sum up values from adjacent column | Excel Discussion (Misc queries) | |||
finding values and displaying adjacent values | Excel Worksheet Functions |