Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Everyone,
I would like to be Able to Achieve this Using VB Please. I have a List of Six Columns and Quite a Few Rows in the Range "B2:G?". Each Row has Six Unique Numbers Within it. What I would like to do, is Cycle through EVERY Combination of 3 Numbers from 24 Numbers ( 2,024 Combinations ), and Check if ANY of the Rows in "B2:G?" Contain ANY of the 2,024 Combinations. For Example, if the First Combination of 1,2,3 was Found in 5 Rows, I Only want it Counted as 1 Match NOT 5 Matches. So Basically, as Soon as it Finds a Match in ANY of my Rows "B2:G?" it Counts it as One and Exits the Loop and Continues to the Next Combination and so on. I would then Like the Total Number of the 2,024 Combinations ( 333 for Example ) that were Matched Underneath the Last Entry in Column "B" But One. Many Thanks in Advance. All the Best. Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count exact matches | Excel Worksheet Functions | |||
Count matches within two columns | Excel Discussion (Misc queries) | |||
count each row for total matches | New Users to Excel | |||
Compare columns, count matches | Excel Worksheet Functions | |||
COUNT INFORMATION IN COLUMN B ONLY IF A1 MATCHES K1 COUNT THAT CE. | Excel Worksheet Functions |