Results 1 to 5 of 5

Competition Template...No Spaces in Validation List needed.... manual calculation issues.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-11-2008
    Location
    uk
    MS-Off Ver
    365
    Posts
    424

    Competition Template...No Spaces in Validation List needed.... manual calculation issues.

    Need your expert help once again!

    I attach a draft workbook which mimics a competition I'm going to be running.

    It is a straight random knockout but I've made all the calculations manual as once the draw is made I don't want anyone changing it easily or to lose the randomizing effects. This is done via a randomize button which splits the competitors into pairs using a simple random, rank and index formula.

    This randomizing is controlled via a password protected Button .....123 is the password.

    For two rounds the drop down validation are both fine and visually correct. However, for the semi and final, there are large spaces, and I can't figure out how to remove them without losing the integrity of the worksheet.

    Any suggestions chaps?

    Skyping
    Attached Files Attached Files
    Last edited by skyping; 07-29-2013 at 06:53 PM. Reason: grammer

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 07-23-2013, 07:51 AM
  2. [SOLVED] Skip blank spaces in data validation list
    By skip2mylew in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-04-2013, 09:20 PM
  3. Formula to include spaces in linked data validation list
    By hbomb1927 in forum Excel General
    Replies: 2
    Last Post: 10-25-2011, 07:01 PM
  4. Competition template...If statement problems.
    By skyping in forum Excel General
    Replies: 2
    Last Post: 08-27-2010, 03:29 AM
  5. Manual Calculation and Data Validation
    By cuteangelika in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-17-2007, 08:49 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