What formula can be used to count 1 of each value in a given range?
Using Microsoft Office Home and Business 2016
Please see below example table.
I'd like to count how many apartments are on the list without counting duplicates. So the formula would give a count of 5 for this table.
Using Microsoft Office Home and Business 2016
Please see below example table.
I'd like to count how many apartments are on the list without counting duplicates. So the formula would give a count of 5 for this table.
A | B | C | |
1 | Date | Apt. # | Name |
2 | 5/25/22 | 2A | John |
3 | 5/25/22 | 2A | Jason |
4 | 6/1/22 | 7B | Jack |
5 | 7/1/22 | 21G | Irene |
6 | 5/30/22 | 21G | Jennifer |
7 | 6/30/22 | 21G | Elizabeth |
8 | 6/15/22 | 9H | Steve |
9 | 5/15/22 | 10C | Angela |
Last edited: