Page 2 of 2 FirstFirst 1 2
Results 11 to 19 of 19

Thread: Please help

  1. #11
    Seeker Catherine Coleltt's Avatar
    Join Date
    Sep 2020
    Location
    United Kingdom
    Posts
    9
    Articles
    0
    Excel Version
    2019 & Google Sheets

    Nearly there!



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Bernie thanks for all your help on this.

    It's now pulling out 4 names if needed.Is there a way to hide the names at the beginning.
    When the Spreadsheet is empty it's putting all the names in anyway and then changing them once the data in cells B-E are entered.

    I ideally need column F blank so that when the points are entered it then populates the column F with the winning teams of the week, because otherwise the main Totals sheet has all the teams on for every week in advance (and that will just confuse the Head teacher)

    I think I've managed to upload the spreadsheet so you can see what I'm trying to achieve.

    Catherine
    Attached Files Attached Files
    Last edited by Catherine Coleltt; 2020-09-17 at 09:02 AM.

  2. #12
    Acolyte Bernie's Avatar
    Join Date
    Feb 2018
    Location
    Suburban NY
    Posts
    34
    Articles
    0
    Excel Version
    Excel 2016 (Win)
    For Year 6, cell F3, array-enter using Ctrl-Shift-Enter:

    =IF(COUNTA(B3:E3)=0,"",IFERROR(INDEX($2:$2,SMALL(IF($B3:$E3=MAX($B3:$E3),COLUMN($B3:$E3)),1)),"") & IFERROR(", " & INDEX($2:$2,SMALL(IF($B3:$E3=MAX($B3:$E3),COLUMN($B3:$E3)),2)),"") & IFERROR(", " & INDEX($2:$2,SMALL(IF($B3:$E3=MAX($B3:$E3),COLUMN($B3:$E3)),3)),"") & IFERROR(", " & INDEX($2:$2,SMALL(IF($B3:$E3=MAX($B3:$E3),COLUMN($B3:$E3)),4)),""))
    Bernie Deitrick
    MS Excel MVP 2001-2010

  3. #13
    Acolyte Bernie's Avatar
    Join Date
    Feb 2018
    Location
    Suburban NY
    Posts
    34
    Articles
    0
    Excel Version
    Excel 2016 (Win)
    Here is a completed version with the summary tab filled out.
    Attached Files Attached Files
    Bernie Deitrick
    MS Excel MVP 2001-2010

  4. #14
    Seeker Catherine Coleltt's Avatar
    Join Date
    Sep 2020
    Location
    United Kingdom
    Posts
    9
    Articles
    0
    Excel Version
    2019 & Google Sheets
    OMG Bernie

    I'm sitting here with tears. I didn't know that people like you still existed. You have saved me hours of work! I'm so very very grateful. I can now get on a do what I am good at, (teaching) without fretting that I haven't delivered. I'm going to look at what you've done and figure it out, so I can do it again and again.
    Your a superstar!

  5. #15
    Acolyte Bernie's Avatar
    Join Date
    Feb 2018
    Location
    Suburban NY
    Posts
    34
    Articles
    0
    Excel Version
    Excel 2016 (Win)
    I'm very happy to hear that my version does what you need. People like me exist all over these forums - I've been on the receiving end (and still am!) so I like to pay back those kindnesses. I especially like helping those who make contributions to their communities: teachers, firefighters, nurses and doctors....

    Take care, and good luck with the new school year and the extra new challenges that all teachers are facing.
    Bernie Deitrick
    MS Excel MVP 2001-2010

  6. #16
    Seeker Catherine Coleltt's Avatar
    Join Date
    Sep 2020
    Location
    United Kingdom
    Posts
    9
    Articles
    0
    Excel Version
    2019 & Google Sheets
    Sorry. Back again!
    We started to use the Spreadsheet and it looks great but when its the 18th of anything it populates all the 18ths. Is there a way to not do this?
    Attached Files Attached Files

  7. #17
    Acolyte Bernie's Avatar
    Join Date
    Feb 2018
    Location
    Suburban NY
    Posts
    34
    Articles
    0
    Excel Version
    Excel 2016 (Win)
    I changed how the lookup is done - this will just pull them in order of entry...
    Attached Files Attached Files
    Bernie Deitrick
    MS Excel MVP 2001-2010

  8. #18
    Seeker Catherine Coleltt's Avatar
    Join Date
    Sep 2020
    Location
    United Kingdom
    Posts
    9
    Articles
    0
    Excel Version
    2019 & Google Sheets
    Thank you! That's perfect

  9. #19
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,472
    Articles
    0
    Excel Version
    Office 365 Subscription
    Catherine: next time you start a thread here, please follow the forum rules and give it a descriptive title. "Please Help" gives us no clue what the query is about or whether we, as individuals, might be able to help. Please help us to help you. Thanks.
    Ali
    Enthusiastic self-taught user of MS Excel!

Page 2 of 2 FirstFirst 1 2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •