| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
determine which cell a value is returned from
How to determine which cell a value is returned from. e.g.=MAX(D6:CC280)
returns 525 - How do I find the cell where it occurs? |
|
#2
|
|||
|
|||
|
Hi
one way =CELL("address",INDEX(D6:CC280,MATCH(MAX(D6:CC280) ,D6:CC280,0))) Cheers JulieD "curiousg" wrote in message ... How to determine which cell a value is returned from. e.g.=MAX(D6:CC280) returns 525 - How do I find the cell where it occurs? |
|
#3
|
|||
|
|||
|
One way:
=ADDRESS(MAX(IF(MAX(D6:CC280)=D6:CC280,ROW(D6:CC28 0))),MAX (IF(MAX(D6:CC280)=D6:CC280,COLUMN(D6:CC280))),4) Array-entered, meaning press ctrl + shift + enter. HTH Jason Atlanta, GA -----Original Message----- How to determine which cell a value is returned from. e.g.=MAX(D6:CC280) returns 525 - How do I find the cell where it occurs? . |
|
#4
|
|||
|
|||
|
Jason,
That works great! The "array-entered" hint is especially appreciated. "Jason Morin" wrote: One way: =ADDRESS(MAX(IF(MAX(D6:CC280)=D6:CC280,ROW(D6:CC28 0))),MAX (IF(MAX(D6:CC280)=D6:CC280,COLUMN(D6:CC280))),4) Array-entered, meaning press ctrl + shift + enter. HTH Jason Atlanta, GA -----Original Message----- How to determine which cell a value is returned from. e.g.=MAX(D6:CC280) returns 525 - How do I find the cell where it occurs? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function to determine if any cell in a range is contained in a given cell | Excel Worksheet Functions | |||
| List ? - How do I make information in one cell determine list to u | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
| Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions | |||
| Is there a function to determine whether a cell contains a formul. | Excel Worksheet Functions | |||
Linear Mode
