Home |
Search |
Today's Posts |
#1
|
|||
|
|||
cell's address of the largest number
how do i receive the address of the cell of the largest number on a list ?
That is, A1 / B12 / C32 etc. |
#2
|
|||
|
|||
Depends on what you mean with "address". Do you want text, like "A1"? Or do
you want a relative position in a table? In the latter case, consider =MATCH(MAX(A1:A100),A1:A100,0) -- Kind Regards, Niek Otten Microsoft MVP - Excel "novio" wrote in message ... how do i receive the address of the cell of the largest number on a list ? That is, A1 / B12 / C32 etc. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
finding the second largest number in a list | Excel Discussion (Misc queries) | |||
How can I change a text to a cell's address? | Excel Discussion (Misc queries) | |||
Extract comma broken address to cells | Excel Discussion (Misc queries) | |||
count number of cells based on TWO conditions (2 different columns | Excel Worksheet Functions | |||
Concatenate cells without specifying/writing cell address individually | Excel Discussion (Misc queries) |