extracting cell location

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can you extract the cell value from the results of an equation? For
example, I would like to find the value of a formula like MAX(A4:A10). If
the results of that formula were located in Cell A5, I want it displayed.

I am trying to take the MAX of a row, and then find the corresponding cell
in the row below it. Example. MAX(A1:A10). Max cell is located in A5. I
want to display the results of B5 in the cell.

Any help is appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Real-time sorting 11
Help With Formula For Date Comparison 6
Max Length in a row 1
Formula for max number and the data adjacent to the cell 3
Formula Content linked to other cells formula Content 5
Excel formula, sum the value cell and if empty cell left blank 0
Formula to find the last number of a column (lower cell) 1
Transpose cell references 1

Back
Top