Solved

Max formula

Posted on 2014-01-15
5
352 Views
Last Modified: 2014-01-15
Hi,

how do I need to adjust the max formula in order for it to point me back to that cell that has the highest value?  Thanks
0
Comment
Question by:Ladkisson
5 Comments
 
LVL 19

Expert Comment

by:helpfinder
ID: 39783369
like this it should work:
=MAX(A1:A6)

see also attached sample

from visual aspect it could be a solution also to use Conditional formating so you will have the highest value highlighted
sample.xlsx
0
 

Author Comment

by:Ladkisson
ID: 39783379
no it just gives me the highest value it does not say that this value is in Cell A6
0
 
LVL 24

Accepted Solution

by:
Steve earned 300 total points
ID: 39783387
Something like the following should work:

=CELL("address",INDEX(A2:A15,MATCH(MAX(A2:A15),A2:A15,0)))
Example.xlsx
0
 
LVL 23

Expert Comment

by:NBVC
ID: 39783404
Try:

=ADDRESS(MATCH(MAX(A:A),A:A,0),1,4)

where you are looking in column A
0
 
LVL 19

Expert Comment

by:helpfinder
ID: 39783405
then use
=ADDRESS(MATCH(MAX(A:A);A:A;0);1;4)
where 1 represents column number - for C change to 3
sample.xlsx
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question