Results 1 to 10 of 10

Fill cell with value, based on criteria of other cells

Threaded View

  1. #1
    Registered User
    Join Date
    03-15-2013
    Location
    Gloucestershire UK
    MS-Off Ver
    Mac Excel 2011
    Posts
    15

    Fill cell with value, based on criteria of other cells

    I am compiling results of a aquathlon and I know excel can help, I just don't know how to get the formula right!

    Col A - Race number ( filled with race number 1, 2 ect )
    Col E - Gender ( filled with either Female or Male )
    Col K - Overall position ( resolved with =RANK(J2,$J$2:$J$48,1) )
    Col L - Gender position ( resolved with =SUMPRODUCT(($E$2:$E$48=E2)*($K$2:$K$48>K2))+1 )
    Col M - Age group position ( resolved with =SUMPRODUCT(($G$2:$G$48=G2)*($K$2:$K$48>K2))+1 )

    Basically I wish to have category position for Overall Male to auto resolve in p2. I figured this would be easiest by displaying their Race Number.

    Possible? Thanks
    Last edited by grantsmith; 04-01-2017 at 04:15 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Fill colors of cells using Conditional formatting based on 3 criteria
    By Sai Prashanth in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-22-2014, 12:39 PM
  2. [SOLVED] Fill Cells based on 3 Criteria (2 that match and 1 that doesn't)
    By freybe06 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-21-2013, 09:40 AM
  3. [SOLVED] VBA fill in cells in a new column in table based on multiple criteria from other columns
    By HRA in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-14-2013, 06:48 AM
  4. Fill data in one cell from another based on criteria from a third
    By pack89 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-10-2012, 11:08 AM
  5. [SOLVED] Using IF to fill cells with TEXT to show staus based on multiple criteria
    By karstens in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-26-2012, 10:23 AM
  6. VBA To Fill In Cells Based On Criteria
    By McNulty in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-06-2009, 06:18 AM
  7. Fill cells with color based on criteria in two cells
    By AA in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-02-2006, 07:35 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