Results 1 to 1 of 1

Special count issue

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-10-2011
    Location
    Central Ohio
    MS-Off Ver
    Excel 2000, and 2010
    Posts
    654

    Special count issue

    I posted this yesterday and I thought it was solved but upon a closer look I found it is not completely resolved.

    I also ran into another issue so I decided to repost in a new thread with a link to the original.

    Link to original post.

    HTML Code: 
    The first issue is a remainder from the original post.
    On the sheet 'Draft' I need column "F" to reflect the values I have typed into the cells.
    The Idea behind this is In doing a 'draft' from a list of eligible golfers, in order to be fair whoever gets the first pick in the first round of picks has a slight advantage. If that individual gets the first pick in all subsequent rounds that slight advantage becomes bigger. So to level out the playing field in each new round the person drafting last in the current roud gets the first pick in the new round. The picking order reverses for every new round.

    So I need a formula to assign the picking order dependany on the number of people drafting and the nomber of rounds. Clolumn F.

    The next issue is on the sheet 'Draft List'. I need to fill out the table D3:P13.

    Thanks

    Jim O
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Special Character Issue in CSV File
    By AsifSayed in forum Excel General
    Replies: 3
    Last Post: 02-18-2015, 10:37 AM
  2. [SOLVED] Regex Replacing Formulas: Issue with Special Characters
    By k64 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-24-2014, 10:17 AM
  3. Paste Special issue
    By jimstew1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-17-2012, 04:44 PM
  4. Replies: 2
    Last Post: 06-05-2011, 02:20 PM
  5. Paste Special issue with Macro
    By pingwin77 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-14-2011, 01:39 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