display the cell that produced a result

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

Guest

Is there any way in Excel to display, or get, the cell that produced a
result. I am using the LARGE command to find the largest value in an array.
I then need to know which cell it came from. Is there any way of obtaining
that and displaying it somewhere?

Thanks for the help.
 
By cell you mean cell reference like A1,B14 etc then use this

=ADDRESS(MATCH(LARGE(A1:A100,1),A1:A100,0),COLUMN(A1:A100),4)
where a1:a100 is the range where you are seeking the largest value out of.
In case of a tie between 2 or more large values it will display the cell
reference of the first
 
You must log in or register to reply here.

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

Displaying results in formula bar when cell is hidden 1
Taking the Zeros out of an array when displaying 7
Cell shows the last typed text, no matter where it is typed 0
#N/A Conditional Formatting affects all cells? 9
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
How to show all formulas of cells in cells (and not the calculated result) ? 10
DISPLAYING RESULTS OF A FORMULA 1
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1

Back
Top