Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a worksheet with two columns of data
Column A has contains a reference code, d1, d2, d3....and so on to d6 however, this code can occur more than once. Column B has a random number against the reference codes (could be anything between 1 -100) e.g. d1 5 d2 7 d1 10 d3 1 d1 5 d5 6 d4 20 d4 5 d6 15 d5 6 d1 10 I would like to calculate the number of occurances of each reference code with each number, i.e. the number of d1's with number 5 = 2, the number of d1's with 10 = 1. Can anyone help? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sorting - Frequency distribution. | Excel Discussion (Misc queries) | |||
How do I create a Histogram for relative frequency distributions? | Excel Discussion (Misc queries) | |||
Frequency for Histograms in Excel | Charts and Charting in Excel | |||
Cumulative Frequency | Charts and Charting in Excel |