If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
frequency function and letters [HOW?]
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 |
#2
|
|||
|
|||
frequency function and letters [HOW?]
On Wed, 18 Feb 2009 22:26:40 +0100, gordom
wrote: 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 |
#3
|
|||
|
|||
frequency function and letters [HOW?]
Have a look at the COUNTIF() formula. Hope this helps / Lars-Ã…ke It seems to work . Thanks. gordom |
Thread Tools | |
Display Modes | |
|
|