Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 246
  • Last Modified:

Excel sheet to retrieve percent based on table

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
wlreimer
Asked:
wlreimer
1 Solution
 
Rory ArchibaldCommented:
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
 
wlreimerAuthor Commented:
Wow!!! Thank you SOO much, this is exactly what I needed and speedy quick.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now