Hello
I would like to be able to understand how to identify a count of unique numbers in one column and then look to a second column and count with an entry in to return a count.
I have been using some functions but cannot work out how to combine the two to provide the answer I am looking for. It is almost a grouping type function???
thank you
I would like to be able to understand how to identify a count of unique numbers in one column and then look to a second column and count with an entry in to return a count.
I have been using some functions but cannot work out how to combine the two to provide the answer I am looking for. It is almost a grouping type function???
thank you
Book1a.xlsx | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | 1 | ||||||
2 | 1 | ||||||
3 | 1 | ||||||
4 | 1 | ||||||
5 | 1 | 05/01/2012 | |||||
6 | 1 | ||||||
7 | 1 | 01/01/2012 | |||||
8 | 2 | ||||||
9 | 2 | ||||||
10 | 2 | 02/02/2013 | |||||
11 | 2 | ||||||
12 | 2 | ||||||
13 | 3 | ||||||
14 | 3 | ||||||
15 | 3 | ||||||
16 | 3 | ||||||
17 | 3 | ||||||
18 | 3 | ||||||
19 | 3 | 3 | Answer I am looking for | 2 | |||
Sheet2 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A19 | A19 | =SUM(1/COUNTIF(A1:A18,A1:A18)) |
B19 | B19 | =COUNTA(B1:B18) |
Press CTRL+SHIFT+ENTER to enter array formulas. |