frequency function and letters [HOW?]

G

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
 
L

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
Click to expand...


Have a look at the COUNTIF() formula.

Hope this helps / Lars-Åke
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to set condition for frequency? 7
Frequency.... I think 1
Columns now numbers rather than letters how do i get letters back 2
Help separating letters from numbers 11
Formulas to display all 3 letter combinations in 8 letters 1
frequency function and list features 5
Macro for detect palindromes and repeats in letters/numbers string 33
Possible Sumproduct with Or Function 1

Top