Solved

Max formula

Posted on 2014-01-15
5
361 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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

860 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