Results 1 to 11 of 11

Ratio percentage macro resulting incorrectly.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-12-2017
    Location
    New Zealand
    MS-Off Ver
    Ms Office 2016
    Posts
    472

    Ratio percentage macro resulting incorrectly.

    Hello all,

    The macro in this sheet named Staticfmv3Ratio3 was originally written to result a percentage number based on there number of starts wins (1sts), and placings <=4.

    Cols BJ:Bl is last 3 starts only.
    The original macro used to pick up col AP. I have tried to change this version to pick up col K now.

    Clearly I have something wrong and my adaptation is not correct and resulting wrong results in cols W and X.

    I have resulted the first 7x rows in cols BN and BO to show correct results. I have nearly 600,000 rows to process. Every name is different.

    Basic calculations, 100 divided by number of starts times all 1st places for col W.
    Basic calculations, 100 divided by number of starts times all places less than and equal to four, for col X.

    Thanks.
    Attached Files Attached Files
    I am grateful for all answers to my questions .
    Also i give a reputation even if not answered .

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Formula to get percentage ratio of two numbers
    By HombreUno in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-01-2018, 06:20 PM
  2. [SOLVED] Ratio/Percentage of column
    By jthomas6528 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-19-2017, 05:22 PM
  3. Percentage with drop in number in same ratio
    By jhajee in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-24-2015, 07:19 AM
  4. Different Percentage value for each field resulting in one total.
    By mlivsey in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-26-2012, 07:07 AM
  5. Convert Ratio Value to Percentage Value
    By harishs in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-15-2011, 10:06 AM
  6. Showing Ratio/Percentage on an Excel Chart
    By elionn in forum Excel General
    Replies: 3
    Last Post: 10-25-2011, 06:16 AM
  7. determine ratio or percentage?
    By pinchrx in forum Excel General
    Replies: 2
    Last Post: 12-27-2010, 12:57 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1