To identify highest value

Hi!

Tab A cell E3 needs to identify a store (tab B column A) that has the highest index (tab B column B). Please refer to the attached file. Thanks!
Highest-Value.xlsx
LadkissonAsked:
Who is Participating?
 
Martin LissConnect With a Mentor Older than dirtCommented:
@Ladkisson: You can now split point (or not) any way you want.
0
 
sg08234Commented:
See solution attached.

Michael
Highest-Value.xlsx
0
 
Jignesh TharSenior ManagerCommented:
=MAX(Sheet2!B:B) should work
0
 
LadkissonAuthor Commented:
oops I should not have accepted your solution...I need to identify a store with the highest value, not just a value
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.