Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Row and Col Index of a cell with Max Value
I have two worksheets.
Lets say work sheet "apple", has the foll. data A | B _______________ 1 | Jack | 45 2 | Martha | 32 3 | Eddie | 28 4 | Joe | 56 5 | Mary | 64 6 | Susan | 88 In another work sheet how can I extract the row and colum index of cell with maximum value. In other words what formula can I use (in another) worksheet to know the cell index of column B in worksheet "apple". Please provide your inputs. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Row and Col Index of a cell with Max Value
Since you seem to be looking column B, the Column index is 2. Or did I misunderstand your question?
The Row index: =MATCH(MAX(Sheet2!B:B),Sheet2!B:B,0) Beware of duplicates. -- Kind regards, Niek Otten Microsoft MVP - Excel "mario" wrote in message ... |I have two worksheets. | | Lets say work sheet "apple", has the foll. data | | A | B | _______________ | 1 | Jack | 45 | 2 | Martha | 32 | 3 | Eddie | 28 | 4 | Joe | 56 | 5 | Mary | 64 | 6 | Susan | 88 | | | In another work sheet how can I extract the row and colum index of cell with | maximum value. In other words what formula can I use (in another) worksheet | to know the cell index of column B in worksheet "apple". | | Please provide your inputs. | | Thanks | | |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Row and Col Index of a cell with Max Value
you know the column your looking there
=MATCH(MAX(B1:B6),B1:B6,0) Mike "mario" wrote: I have two worksheets. Lets say work sheet "apple", has the foll. data A | B _______________ 1 | Jack | 45 2 | Martha | 32 3 | Eddie | 28 4 | Joe | 56 5 | Mary | 64 6 | Susan | 88 In another work sheet how can I extract the row and colum index of cell with maximum value. In other words what formula can I use (in another) worksheet to know the cell index of column B in worksheet "apple". Please provide your inputs. Thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Row and Col Index of a cell with Max Value
Or
=MATCH(MAX(Apple!B:B),Apple!B:B,0) -- Kind regards, Niek Otten Microsoft MVP - Excel "Niek Otten" wrote in message ... | Since you seem to be looking column B, the Column index is 2. Or did I misunderstand your question? | | The Row index: | | =MATCH(MAX(Sheet2!B:B),Sheet2!B:B,0) | | Beware of duplicates. | | -- | Kind regards, | | Niek Otten | Microsoft MVP - Excel | | "mario" wrote in message ... ||I have two worksheets. || || Lets say work sheet "apple", has the foll. data || || A | B || _______________ || 1 | Jack | 45 || 2 | Martha | 32 || 3 | Eddie | 28 || 4 | Joe | 56 || 5 | Mary | 64 || 6 | Susan | 88 || || || In another work sheet how can I extract the row and colum index of cell with || maximum value. In other words what formula can I use (in another) worksheet || to know the cell index of column B in worksheet "apple". || || Please provide your inputs. || || Thanks || || | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index heading when cell is populated | Excel Worksheet Functions | |||
help with index to return particular cell value | Excel Discussion (Misc queries) | |||
index,match + 1 cell below? | Excel Worksheet Functions | |||
autofill according to cell index | Excel Worksheet Functions | |||
autofill according to cell index. | Excel Discussion (Misc queries) |