Solved

To identify highest value

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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
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 use longer labels with horizontal bar charts instead of the vertical column chart.

828 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