[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

To identify highest value

Posted on 2013-01-17
5
Medium Priority
?
330 Views
Last Modified: 2013-01-25
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
0
Comment
Question by:Ladkisson
4 Comments
 
LVL 2

Expert Comment

by:sg08234
ID: 38787558
See solution attached.

Michael
Highest-Value.xlsx
0
 
LVL 7

Expert Comment

by:Jignesh Thar
ID: 38787561
=MAX(Sheet2!B:B) should work
0
 

Author Comment

by:Ladkisson
ID: 38787598
oops I should not have accepted your solution...I need to identify a store with the highest value, not just a value
0
 
LVL 50

Accepted Solution

by:
Martin Liss earned 1200 total points
ID: 38790204
@Ladkisson: You can now split point (or not) any way you want.
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

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

In this post, I will showcase the steps for how to create groups in Office 365. Office 365 groups allow for ease of flexibility and collaboration between staff members.
This holiday season, we’re giving away the gift of knowledge—tech knowledge, that is. Keep reading to see what hacks, tips, and trends we have wrapped and waiting for you under the tree.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

831 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