# Posts by hapyhapy70

Re: Count with Multiple Criteria and Find Permutations

Ger,
YOU ARE THE TOP DOG!!!

Thank you!

Re: Find &amp; Count All Possible Combinations

Cool. Thanks Ger

Carl

Re: Find &amp; Count All Possible Combinations

Thanks for the fast response.

John and Mary picks 4 numbers daily (only using numbers 0-9)
ex. on 9-26-09 John's 1st pick was "8", 2nd "5", 3rd "8", 4th "0"
Yes. There will only be (1st to 4th)

J1 through S1 represent the column of numbers that can be drawn.(0-9)

J3 through S3 represent the total number of times each number was drawn.
ex. between John and Mary the number 1 was picked 4 times in total

J7 through S7 represent the total number of times each number was drawn by John only.
ex. How many times did John pick the number 3. Ans. 5 times in total

J11 through S11 represent the total number of times each number was drawn by Mary only.
ex. How many times did Mary pick the number 3. Ans. 7 times in total

Lastly, I would like to type in 4 random numbers in cell J19 and below it should produce all possible combination's from the numbers drawn.

I hope this is better explained. The sheet has the actual expected results.

Hi people, I have a few calculations I cannot solve for life of me. I know you guys can figure this out. In the example attached you will see the list of the numbers that were drawn (More numbers will be added as time continues).
I was able to use "countif" to find the total number of time each number was drawn.
My delima, I need:
1. Count the number of times each number was drawn by person.
John starting in cell J7
Mary starting in cell J11

2. I need to type in 4 digits in cell J19, and find all possible combinations from the list of numbers drawn

List what combination of numbers that was drawn including the date it was drawn by person starting at cell I20 using the format as shown