Solved

To identify highest value

Posted on 2013-01-17
5
274 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
Comment Utility
See solution attached.

Michael
Highest-Value.xlsx
0
 
LVL 7

Expert Comment

by:Jignesh Thar
Comment Utility
=MAX(Sheet2!B:B) should work
0
 

Author Comment

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

Accepted Solution

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

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

763 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

5 Experts available now in Live!

Get 1:1 Help Now