detect in the blue list the two numbers in the yellow list,
objective is to see n the blue list the number of times that occurred in the yellow list of two numbers =
https://www.excelforum.com/attachmen...1&d=1610705823
detect in the blue list the two numbers in the yellow list,
objective is to see n the blue list the number of times that occurred in the yellow list of two numbers =
https://www.excelforum.com/attachmen...1&d=1610705823
Not sure if this is what you are after
PUT in Q5
=COUNTIF($G:$H,J5)
Copy across the 6 columns Q to V
and then down
IF NOT
Then please put Expected results in your sample
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
hello! ETAF , ,almost, there we have the double of the first two numbers, in yellow, to confront the 6 wheel in blue, the formula or macro will see the number of times in the 6 number string, the two initials, see how many times it was drawn, ex =
25 45 has been drawn 12 times, or 13.30 has been drawn 8 times ,,,, it's just an example, ok to do delay statistics
1. Paste the yellow numbers transpose into rows 4:5
2. Use the following formula in rows 6 and down: =SUMPRODUCT(($J6:$O6=P$4)+($J6:$O6=P$5))>1
3. Count in row 3 is populated using: =COUNTIFS(P6:P100,TRUE)
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
ok, yes perfect good job, as i am on my birthday, it was a great gift, thanks !! when you win a prize you will be rewarded, for sure, thanks jeteMC
You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks