frequency function and letters [HOW?]

[gordom]

Hi everyone.
I have a list of product numbers in one column. The numbers are usually
a mixture of letters and digits (e.g 0111SA or 016C or 0920SB - there is
no number pattern). Now I would like to check how often some of these
products are listed. The frequency function doesn’t work because of the
letters. How can it be achieved? Is there any way to transform letters
into digits somehow? Any other formula? Thanks in advance,
gordom

 

[Lars-Åke Aspelin]

Hi everyone.
I have a list of product numbers in one column. The numbers are usually
a mixture of letters and digits (e.g 0111SA or 016C or 0920SB - there is
no number pattern). Now I would like to check how often some of these
products are listed. The frequency function doesn’t work because of the
letters. How can it be achieved? Is there any way to transform letters
into digits somehow? Any other formula? Thanks in advance,
gordom

Have a look at the COUNTIF() formula.

Hope this helps / Lars-Åke

 

[gordom]

Have a look at the COUNTIF() formula.

Hope this helps / Lars-Ã…ke

It seems to work . Thanks.

gordom