Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

MAX VALUE CELL ADDRESS

  Asked By: Armando    Date: Feb 05    Category: MS Office    Views: 881
  


I have a list of number in column A from a1 to a10. I want to know the
cell address of maximum value.

like:

ADDRESS = MAX(A1:A10)

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Amelia Schmidt     Answered On: Feb 05

use this formula
ADDRESS(MATCH(MAX(A1:A10),$A$1:A10,0),1)

 
Didn't find what you were looking for? Find more on MAX VALUE CELL ADDRESS Or get search suggestion and latest updates.




Tagged: