Results 1 to 3 of 3

Counting with highest / Lowest Scores

Threaded View

  1. 09-05-2016, 08:43 AM #1
    CallumWebley
    CallumWebley is offline
    Registered User
    Join Date
    08-18-2015
    Location
    Ebbw Vale
    MS-Off Ver
    Windows 7
    Posts
    34

    Counting with highest / Lowest Scores

    Hello,

    Basic question regarding excel formulas.

    In work we participate in a dream team and we have forfeits for the lowest scorer that month. I want to count the amount of "1st place finishes" in a tally and the same for "2nd.. 3rd 4th.."

    Would anyone be able to help me with this... the layout and first month is attached

    I would also like to have a small 3 month form guide...
    For example if CW had the 3rd highest score the 2nd then the 3rd again...
    is there anyway to show this as 3,2,3 automatically?
    Attached Files Attached Files
    Last edited by CallumWebley; 09-05-2016 at 08:48 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to change the lowest to highest into Highest to lowes ??
    By jasond1992 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-30-2015, 03:38 AM
  2. [SOLVED] how to find the lowest to highest value and display the name who is the lowest and the hig
    By jasond1992 in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 09-23-2015, 09:20 PM
  3. Trying to Pick 10 lowest golf scores from a list of scores and average for Handicaps
    By 1wxman1 in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 12-20-2014, 04:37 PM
  4. [SOLVED] Drop lowest and highest golf scores
    By Jjoseph6969 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 08-26-2014, 04:03 PM
  5. Highest contribution should get lowest errors and Lowest contribution should get highest
    By rpanuganti in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-06-2013, 04:48 AM
  6. average of lowest 3 of 5 scores >0
    By barnowl in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-17-2010, 08:59 PM
  7. Names and scores of the two lowest scores
    By dmyoungsal in forum Excel General
    Replies: 3
    Last Post: 07-15-2008, 11:47 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1