Solved

To identify highest value

Posted on 2013-01-17
5
298 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: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

770 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