Results 1 to 10 of 10

Automatically fill in results tables

Threaded View

  1. #2
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: Automatically fill in results tables

    copy paste below in H6 and then hold control and shift together and then hit enter and drag down to make it array formula
    =IFERROR(INDEX($B$3:$B$34,MATCH(SMALL(IF(($E$3:$E$34="M")*($C$3:$C$34),$C$3:$C$34),ROW(A1)),$C$3:$C$34,0)),"")

    copy paste below in P6 and then hold control and shift together and then hit enter and drag down to make it array formula
    =IFERROR(INDEX($B$3:$B$34,MATCH(SMALL(IF(($E$3:$E$34="F")*($C$3:$C$34),$C$3:$C$34),ROW(A1)),$C$3:$C$34,0)),""

    copy paste below in L6 and then hold control and shift together and then hit enter and drag down to make it array formula
    =IFERROR(INDEX($B$3:$B$34,MATCH(LARGE(IF(($E$3:$E$34="M")*($D$3:$D$34),$D$3:$D$34),ROW(A1)),$D$3:$D$34,0)),"")

    copy paste below in T6 and then hold control and shift together and then hit enter and drag down to make it array formula
    =IFERROR(INDEX($B$3:$B$34,MATCH(LARGE(IF(($E$3:$E$34="F")*($D$3:$D$34),$D$3:$D$34),ROW(A1)),$D$3:$D$34,0)),"")
    ..confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
    Attached Files Attached Files
    Last edited by hemesh; 01-28-2016 at 02:50 PM.
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST

    More we learn about excel, more it shows us, how less we know about it.

    for chemistry
    https://www.youtube.com/c/chemistrybyshivaansh

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