cell's address of the largest number

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

Guest

how do i receive the address of the cell of the largest number on a list ?
That is, A1 / B12 / C32 etc.
 
Depends on what you mean with "address". Do you want text, like "A1"? Or do
you want a relative position in a table?

In the latter case, consider

=MATCH(MAX(A1:A100),A1:A100,0)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
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

adding largest numbers 2
News Largest data breach revealed - 773m email addresses and 21m passwords published 12
Find values across a row and return a text value from the same column 2
Finding a folder with the largest number. 1
smallest to largest 9
How to determine the value - 18 Dec? 5
How do I return the cell address of the largest of a set of values 8
Logic Statement 2

Back
Top