| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Frequency
Within Column B there are various product codes. Each code consists of a
mixture of alpha and numerical characters. In Column B some of the codes are duplicated. I would like to place a formula in Column J which calculates the number of individual occurences of that particular product code in Column B. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Frequency
Use this formula in J1 and copy down
=Countif(B$1:B$1000,B1) Change 1000 to the last row in your dataset. "SiH23" wrote: Within Column B there are various product codes. Each code consists of a mixture of alpha and numerical characters. In Column B some of the codes are duplicated. I would like to place a formula in Column J which calculates the number of individual occurences of that particular product code in Column B. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Label Frequency | Charts and Charting in Excel | |||
| Frequency of data with criteria | Excel Worksheet Functions | |||
| Plotting Frequency data | Charts and Charting in Excel | |||
| histograms - frequency and relative frequency? | Excel Discussion (Misc queries) | |||
| Sort Data by Frequency | Excel Worksheet Functions | |||
Linear Mode
