+ Reply to Thread
Results 1 to 7 of 7

Please help beginner with another 20 number problem

  1. #1
    Registered User
    Join Date
    08-28-2021
    Location
    london
    MS-Off Ver
    xp , 2000
    Posts
    13

    Please help beginner with another 20 number problem

    Hello everybody !
    I would once again need your help for a Excel problem !
    I want to solve the following numbers problem.

    I attached my excel file to this post.

    The A-J rows each contain 10 random numbers from 1-20.
    I need a formula in the solutions rows that would automatically fill the cells with the numbers from above , following the conditions written in the red solutions column.
    The 1st solution should be the numbers from A+B
    The 2nd solution should be the numbers from B+C etc...

    Thank you very much !!!
    Attached Files Attached Files
    Last edited by pyiujkui; 09-11-2021 at 07:01 PM.

  2. #2
    Forum Guru
    Join Date
    04-23-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 2010, 2019
    Posts
    2,270

    Re: Please help beginner with another 20 number problem

    Put this formula in cell B18 and copy it across to cell U18, then copy all of those cells (range B18:U18) down to Row 26...

    =IF(B3&B4="","",B$1)

    I did note some errors in the example solution you posted.
    Last edited by Rick Rothstein; 09-10-2021 at 07:06 PM.

  3. #3
    Registered User
    Join Date
    08-28-2021
    Location
    london
    MS-Off Ver
    xp , 2000
    Posts
    13

    Re: Please help beginner with another 20 number problem

    Thank you very much !
    It works great !!!
    Yes , you are right , now I notice some errors as well. That`s why a formula was needed , it`s very easy to make a mistake checking so many numbers.

    Now I have another little problem.
    I would like to add a formula in the V column that counts how many numbers are in each ''solution''. I tried to do it like this: =COUNTA(B18:U18) , however I get the result 20 when the result should be 13.
    I`m assuming the counta counts your formula inside each cell as a result instead of counting the numbers ???
    Any ideea how to fix this ?
    Thank you very much !!!

    Quote Originally Posted by Rick Rothstein View Post
    Put this formula in cell B18 and copy it across to cell U18, then copy all of those cells (range B18:U18) down to Row 26...

    =IF(B3&B4="","",B$1)

    I did note some errors in the example solution you posted.

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.56 for Mac (home)
    Posts
    7,864

    Re: Please help beginner with another 20 number problem

    try it this way... =COUNTIF(B18:U18,">0")
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  5. #5
    Forum Guru
    Join Date
    04-23-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 2010, 2019
    Posts
    2,270

    Re: Please help beginner with another 20 number problem

    Actually, just using COUNT should work...

    =COUNT(B18:U18)

  6. #6
    Registered User
    Join Date
    08-28-2021
    Location
    london
    MS-Off Ver
    xp , 2000
    Posts
    13

    Re: Please help beginner with another 20 number problem

    Thank you very much Sam Capricci !!!
    Thank you very much Rick Rothstein !!!
    Last edited by pyiujkui; 09-11-2021 at 10:04 AM.

  7. #7
    Forum Guru
    Join Date
    04-23-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 2010, 2019
    Posts
    2,270

    Re: Please help beginner with another 20 number problem

    If your question is now fully answered, make sure to mark the thread as "SOLVED".

+ 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. [SOLVED] Please help beginner with a 20 number problem
    By pyiujkui in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 08-29-2021, 10:34 AM
  2. Excel VBA Beginner problem in time calculations
    By Excel 22 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-26-2020, 12:57 PM
  3. number-comma-number formatting problem. Thousands, and string
    By JimmyWilliams in forum Excel General
    Replies: 1
    Last Post: 11-28-2017, 06:35 PM
  4. [SOLVED] Excel VBA beginner problem
    By Branko123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-14-2015, 04:31 PM
  5. Beginner in VBA
    By neeraj_joshi48 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-01-2012, 06:58 AM
  6. beginner's problem
    By fidley in forum Excel General
    Replies: 2
    Last Post: 04-10-2009, 05:46 AM
  7. beginner problem: getting selected rows, row by row
    By Holger Beese in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-14-2005, 06:06 AM

Tags for this Thread

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