Ladkisson
asked on
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
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
=MAX(Sheet2!B:B) should work
ASKER
oops I should not have accepted your solution...I need to identify a store with the highest value, not just a value
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Michael
Highest-Value.xlsx