Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 doesnt 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Function '=Frequency' Help! | Excel Worksheet Functions | |||
Frequency Function | Excel Worksheet Functions | |||
Frequency Function | Excel Worksheet Functions | |||
how do I get the frequency of letters in a column? | Excel Discussion (Misc queries) | |||
Frequency function | Excel Discussion (Misc queries) |