Results 1 to 10 of 10

Automatically fill in results tables

Threaded View

  1. #1
    Registered User
    Join Date
    01-31-2013
    Location
    England
    MS-Off Ver
    Pro Plus 2016
    Posts
    19

    Automatically fill in results tables

    I'm struggling to come up with a formula and even what functions to use for the following problem. I generally sort the data myself and copy and paste, but it would be nice to figure out how to get it to work automatically.

    In the attached spreadsheet, I have a data set on the left, and 4 results boxes (titled with what should go in them).

    For example, the cell H6 should return the value/name in B3 as the smallest male time. Likewise L6 should also return the value in B3 with the highest male %. And so on for the other results boxes.

    Is it also possible if I could start with a blank data set, and entered in B3 the name 'ABC', and corresponding time in C3 of 1:00:00, for it to end up in H6. Only then to enter a new name in B4 of 'XYZ' and a time in C4 of 0:30:00, for THE value in H6 to change to 'XYZ' (as the new smallest time) and the value 'ABC' to be shunted down into cell H7 (as the 2nd smallest time).

    Apologies if the above isn't worded very well.

    Thanks in advance
    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. Updating League Tables automatically by inputting Results
    By bm2 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-26-2015, 05:50 PM
  2. [SOLVED] Formula to fill two tables automatically
    By canudo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-28-2015, 01:00 PM
  3. [SOLVED] fill out one cell, all others fill out automatically
    By hatsunetsu in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 01-10-2015, 02:07 PM
  4. Vlookup results from 2 tables
    By emp2013 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-30-2014, 09:12 PM
  5. Formula to Automatically Fill Blank With Next fill cell's data?
    By VMoney in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-22-2013, 05:11 PM
  6. Fill Blank Cells Automatically in Pivot Tables
    By jgur88 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-18-2012, 12:12 PM
  7. Results from Multiple Tables
    By UPSguy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-03-2008, 09:46 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