Results 1 to 14 of 14

Please help beginner with a 20 number problem

Threaded View

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

    Please help beginner with a 20 number problem

    Hello !
    I am a complete beginner to Excel !
    I want to solve the following numbers problem.
    I was able to use some lessons on the internet to create a formula that will work for my problem, however I can`t finish it completely , so I would love for someone to help me if possible.

    I attached my excel file to this post.

    I created the first yellow row called ''Check for these numbers''. Here you can insert up to 20 numbers. I chose to enter only 10.
    The next 5 rows each contain 10 random numbers from 1 to 20.
    The ''Matches'' column on the right shows how many of the numbers from each of the 5 rows are matching with the original numbers from the yellow row.
    Here is my problem:
    I want the total result of matches of the 2nd row to not include numbers that already matched in the 1st row.
    I want the total result of matches of the 3rd row to not include numbers that already matched in the 1st & 2nd rows. etc...
    In other words duplicate matches shouldn`t be counted.

    Right now the matches column displays : 4 , 4 , 7 , 6, 6, and I would like the final result to display : 4, 3, 2 , 1 , 0

    Thank you very much !!!
    Attached Files Attached Files
    Last edited by pyiujkui; 08-28-2021 at 06:08 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. 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
  2. number-comma-number formatting problem. Thousands, and string
    By JimmyWilliams in forum Excel General
    Replies: 1
    Last Post: 11-28-2017, 06:35 PM
  3. [SOLVED] Excel VBA beginner problem
    By Branko123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-14-2015, 04:31 PM
  4. please your help i am beginner in vba
    By TAIKOV in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-09-2014, 09:55 AM
  5. Beginner help
    By saratu in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2014, 02:32 PM
  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