Solved

To identify highest value

Posted on 2013-01-17
5
286 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
5 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 46

Accepted Solution

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

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

867 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now