Formula to enter data of one cell based on greatest amount of anot

  • Thread starter Thread starter classroomlaw
  • Start date Start date
C

classroomlaw

Hello! I am looking for a formula that will search an array for the greatest
number, then enter data from the corresponding cell of a different array.
 
Try this:

=INDEX(D:D,MATCH(MAX(A:A),A:A,0))

assuming you are looking in column A for the largest number and want
the corresponding data returned from column D. If you have multiple
maxima, then this will respond to the first of those.

Hope this helps.

Pete
 
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

Format cCell to find greatest value 1
greatest value function? 2
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Excel Excel Vlookup formula based on cell data 7
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
NPR music station. 3
What is the maximum allowed number of data elements in a data array? 2
Issue Adding an Array Formula to a cell at Runtime. 4

Back
Top