Results 1 to 6 of 6

Moving Data to Specified Location

Threaded View

Rhett19 Moving Data to Specified... 01-29-2011, 08:51 PM
MarvinP Re: Moving Data to Specified... 01-29-2011, 09:11 PM
Rhett19 Re: Moving Data to Specified... 01-29-2011, 09:28 PM
MarvinP Re: Moving Data to Specified... 01-29-2011, 09:51 PM
Rhett19 Re: Moving Data to Specified... 01-29-2011, 10:32 PM
MarvinP Re: Moving Data to Specified... 01-29-2011, 10:57 PM
  1. #1
    Registered User
    Join Date
    01-27-2011
    Location
    Texas, USA
    MS-Off Ver
    Excel 2003
    Posts
    12

    Moving Data to Specified Location

    This is what I have. A spreadsheet that will take the times from a track meet(4 heats, 8 contestants per heat). So far I have each heat as i want them(put in times and they get ranked from 1st to 8th in each heat). I need to know how to take all 32(or whatever number of contestants there are) and put them in the RANKED RESULTS from lowest time to highest time. Then it should, using the RANK function rank them from 1-32. I need to know how to get there times, names, and school into the RANKED RESULTS. Once this is done I want to take the fastest 8 and move just their names and school into the FINALS. Then the contestants will run another race and their times will be put into the appropriate spot and these will be ranked(which I think I have done).

    Bottom Line: Get the contestant info from the first 4 heats into the ranked results and then taking the top 8 and putting them into the finals.

    Attached is my progress thus far:

    Thanks in advance.

    If any further information is needed, please ask. Hopefully I explained myself thoroughly.
    Attached Files Attached Files
    Last edited by Rhett19; 01-29-2011 at 11:59 PM.

Thread Information

Users Browsing this Thread

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

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