| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I return tthe location (cell) when using the max function
I keep weekly values of my investments in a row and then search with the max
function. How can I return the date (row 3 of the colum that max value is in) that the max value occured? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I return tthe location (cell) when using the max function
Consider using:
=HLOOKUP() -- Gary''s Student gsnu200709 "Holke" wrote: I keep weekly values of my investments in a row and then search with the max function. How can I return the date (row 3 of the colum that max value is in) that the max value occured? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I return tthe location (cell) when using the max function
The max for that row?
If yes: =index($c$3:$l$3,match(max(c4:l4),c4:l4,0)) if your dates were in C3:L3 and your values to check were in C4:L4 Gary''s Student wrote: Consider using: =HLOOKUP() -- Gary''s Student gsnu200709 "Holke" wrote: I keep weekly values of my investments in a row and then search with the max function. How can I return the date (row 3 of the colum that max value is in) that the max value occured? -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I return tthe location (cell) when using the max function
Oops. I meant to reply to the OP.
Dave Peterson wrote: The max for that row? If yes: =index($c$3:$l$3,match(max(c4:l4),c4:l4,0)) if your dates were in C3:L3 and your values to check were in C4:L4 Gary''s Student wrote: Consider using: =HLOOKUP() -- Gary''s Student gsnu200709 "Holke" wrote: I keep weekly values of my investments in a row and then search with the max function. How can I return the date (row 3 of the colum that max value is in) that the max value occured? -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I return tthe location (cell) when using the max functi
That's o.k.....I can use it too.
-- Gary's Student gsnu200709 "Dave Peterson" wrote: Oops. I meant to reply to the OP. Dave Peterson wrote: The max for that row? If yes: =index($c$3:$l$3,match(max(c4:l4),c4:l4,0)) if your dates were in C3:L3 and your values to check were in C4:L4 Gary''s Student wrote: Consider using: =HLOOKUP() -- Gary''s Student gsnu200709 "Holke" wrote: I keep weekly values of my investments in a row and then search with the max function. How can I return the date (row 3 of the colum that max value is in) that the max value occured? -- Dave Peterson -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I return tthe location (cell) when using the max functi
Thank You
That worked great If you have time I would like an explanation of the formula. "Dave Peterson" wrote: Oops. I meant to reply to the OP. Dave Peterson wrote: The max for that row? If yes: =index($c$3:$l$3,match(max(c4:l4),c4:l4,0)) if your dates were in C3:L3 and your values to check were in C4:L4 Gary''s Student wrote: Consider using: =HLOOKUP() -- Gary''s Student gsnu200709 "Holke" wrote: I keep weekly values of my investments in a row and then search with the max function. How can I return the date (row 3 of the colum that max value is in) that the max value occured? -- Dave Peterson -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I return tthe location (cell) when using the max functi
=max(c4:l4)
returns the largest value in that range =match(x,somerow,0) looks for the exact match (that 0 means exact) in somerow. If it finds an exact match, then this returns a number (1 for the first cell in somerow, 2 for the second cell, ...n for the nth cell). =index(someotherrow,n) picks out the nth cell in someotherrow Holke wrote: Thank You That worked great If you have time I would like an explanation of the formula. "Dave Peterson" wrote: Oops. I meant to reply to the OP. Dave Peterson wrote: The max for that row? If yes: =index($c$3:$l$3,match(max(c4:l4),c4:l4,0)) if your dates were in C3:L3 and your values to check were in C4:L4 Gary''s Student wrote: Consider using: =HLOOKUP() -- Gary''s Student gsnu200709 "Holke" wrote: I keep weekly values of my investments in a row and then search with the max function. How can I return the date (row 3 of the colum that max value is in) that the max value occured? -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return the Row of a Variable's location | Excel Discussion (Misc queries) | |||
| Hyperlink or Other Method To Return To Previous Location (Sheet) Possible? | New Users to Excel | |||
| How to return a specific data point from a large array if I don't know the exact location? | Excel Discussion (Misc queries) | |||
| Labelling bar graph-the bars in X-axis not via tthe legend | New Users to Excel | |||
| Is there a function that will return info of the cursor location? | Excel Worksheet Functions | |||
Linear Mode
