detect the number of numbers drawn from times of each letter in the 4 blocks
https://www.excelforum.com/attachmen...1&d=1582398308
detect the number of numbers drawn from times of each letter in the 4 blocks
https://www.excelforum.com/attachmen...1&d=1582398308
And what is the expected result?
Best Regards,
Kaper
ex= A B C D
3 1 4 2
hello KAPER, thanks for viewing the post, you have to add the number of numbers in each letter
in each draw, each letter can have = 0,1,2,3,4
Show some examples 5-10 in the attachment
hello thanks for viewing the post, well we have 4 letters we have 4 blocks
* each block has the letter A, B, D and its numbers correspond in position, just observe the position of the letter with the number of the matrix in the draws
hello thanks for viewing the post, well we have 4 letters we have 4 blocks
* each block has the letter A, B, D and its numbers correspond in position, just observe the position of the letter with the number of the matrix in the draws
https://www.excelforum.com/attachmen...1&d=1582585323
AA6 and copy down:
Formula:Please Login or Register to view this content.
and similar formulas in AB6:AD6:
Formula:Please Login or Register to view this content.
in AE6 just:
Formula:Please Login or Register to view this content.
I believe, you shall easily be able to write them by yourself - with 1400+ posts and 5+ years on the forum experience!
Last edited by Kaper; 02-25-2020 at 03:33 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks