Solved

Excel sheet to retrieve percent based on table

Posted on 2013-05-22
2
187 Views
Last Modified: 2013-05-22
Attached is a spreadsheet used to calculate payouts for races.  Column F (%) comes from the info in M6-T12 and is based on the # of entries in A6 which is entered manually.

I'd like to find a way for the % in F to come from M6-T12 automatically.

I'd appreciate any help you can offer.
Copy-of-NBHA-Payout--Autosaved-.xlsx
0
Comment
Question by:wlreimer
2 Comments
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 500 total points
ID: 39187722
See attached using INDEX and MATCH. I converted the top row of your table into the start numbers for each bands (and formatted them as real numbers).
Copy-of-NBHA-Payout--Autosaved-.xlsx
0
 

Author Closing Comment

by:wlreimer
ID: 39187760
Wow!!! Thank you SOO much, this is exactly what I needed and speedy quick.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

760 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

16 Experts available now in Live!

Get 1:1 Help Now