count duplicated string in Range for each letter,Non Adjacent Row

Hi !!

please need some advice on this formula, i'm receiving 1 as result

What i'm trying to achieve is to Count the occurrences of each number In range EW3:FA38 with each Alphabet
In Range FK3:FK38
Example :
#24 = 2 occurrences with letter A
#29 = 2 occurrences with letter A:

I'm using this formula

Please Login or Register  to view this content.

and i'm getting result 1, i Tried a sum,sumproducts with countif, and still..

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thank you !

Hi David,

one way could be

Formula:

Please Login or Register  to view this content.

In AB3 and below:

Formula:

Please Login or Register  to view this content.

Greetings

Try this formula in AB3 and drag it down:

Formula:

Please Login or Register  to view this content.

Hi David,

A small contribution:

Please Login or Register  to view this content.

Hi Mr Xladept,

Thank you for your big contribution...
You're right about to apply code on this, because of the delete accident.. lol
code is excellent and i'm going to use it, But let me ask you :

I was trying to figure it how to modify the code and write the total occurrences on each letter column?
For example, to write the total occurrences on a column called "A" , Then i think i can figure for next Letter "C", "E"....."W"
Please see attached Pic.

PatternoccurrencesSample.png





Thank you so much !!


David

Hi David,

Thanks for the rep!

See if this works for you (I couldn't upload your image): Pequeno.xlsb

Please Login or Register  to view this content.

Hi David,

Thanks for the rep - glad you like the code - if the end result is all you need we can code that more elegantly!

Hi David,

Here's a more elegant routine with a less elegant name:Pequeno.xlsb

Please Login or Register  to view this content.

* I think that this is what you requested?