M
mario
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
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