Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Identify where max values are found
Hi all Does anyone know if there's a way for excel to tell me which cell has returned the max from a range, for example if i ask excel to find a max "=max(B10:B34)" then it will display the result 0.15 for example. Is there a way to make excel tell me which cell it found this data in, for example if the max first appears in B22 i would like it to display this in a new column any help greatly appreciated Thanks in advance Owen -- owen080808 ------------------------------------------------------------------------ owen080808's Profile: http://www.excelforum.com/member.php...o&userid=32984 View this thread: http://www.excelforum.com/showthread...hreadid=530025 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Identify where max values are found
"owen080808" wrote:
Does anyone know if there's a way for excel to tell me which cell has returned the max from a range, for example if i ask excel to find a max "=max(B10:B34)" then it will display the result 0.15 for example. Is there a way to make excel tell me which cell it found this data in, for example if the max first appears in B22 i would like it to display this in a new column One way .. Put in say C1: ="B"&MATCH(MAX(B10:B34),B10:B34,0)+9 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Identify where max values are found
Hi Owen,
this worked for me... =ADDRESS(ROW(B10)-1+MATCH(MAX(B10:B34),B10:B34,0),COLUMN(B10),4) Ken Johnson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Identify where max values are found
thats great! thanks a lot guys, im still battling with it a little due to the way ive decided to set it out but you have both helped to put me on the right track. Thanks again guys Owen:) -- owen080808 ------------------------------------------------------------------------ owen080808's Profile: http://www.excelforum.com/member.php...o&userid=32984 View this thread: http://www.excelforum.com/showthread...hreadid=530025 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Identify where max values are found
You're welcome Owen.
Thanks for the feedback. Ken Johnson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
Return Range of Numerical Values in Single Column based on Frequency Percentage | Excel Worksheet Functions | |||
How to delete values of a cell if it is found in another coloumn | Excel Worksheet Functions | |||
#N/A Values : Returned by Formulas vs Entered Manually | Charts and Charting in Excel |