+ Reply to Thread
Results 1 to 1 of 1

Formula to return name from set criteria

  1. #1
    Registered User
    Join Date
    01-31-2013
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    14

    Formula to return name from set criteria

    In the attached spreadsheet, I have a data set and then 4 'results' boxes (entitled with what they should include).

    For example, the value in H6 should return the value in B3/name 'Paul Murrin' with the smallest time for men. In H7 it should be the next smallest time giving the result in B4 'Matt Stott'. Likewise in L6 it should be the value in B3, with the highest % for males.

    I'm unsure how to proceed or even what functions to start with.

    Thanks in advance.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula to return name from set criteria
    By jamblo in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-27-2016, 03:47 PM
  2. [SOLVED] Formula to return value based on two criteria
    By marks9172 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-20-2015, 02:52 PM
  3. [SOLVED] Formula return criteria if
    By dekueb in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-24-2015, 03:49 PM
  4. Help with a formula to look up/return based on 2 criteria
    By Choppo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-11-2014, 09:48 PM
  5. [SOLVED] Formula to return specified value based on criteria
    By adriam25 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 09-23-2014, 12:39 AM
  6. Formula to return specified value based on criteria
    By adriam25 in forum Excel General
    Replies: 8
    Last Post: 09-07-2014, 06:21 AM
  7. vlookup formula with two criteria that must be met to return a value
    By MBROOKS in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-12-2012, 07:04 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