frankerrington
New Member
- Joined
- Oct 20, 2002
- Messages
- 2
A column has 26,000 entries. Many are repeats. I'd like to count just the unique occurrences
On 2002-10-21 16:06, frankerrington wrote:
A column has 26,000 entries. Many are repeats. I'd like to count just the unique occurrences
CountUnique.xls | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | A | A | Unique | |||
2 | C | C | 10 | |||
3 | D | D | ||||
4 | F | F | ||||
5 | F | S | ||||
6 | S | E | ||||
7 | E | W | ||||
8 | W | R | ||||
9 | D | T | ||||
10 | F | G | ||||
11 | D | |||||
12 | E | |||||
13 | W | |||||
14 | R | |||||
15 | T | |||||
16 | F | |||||
17 | G | |||||
18 | D | |||||
19 | D | |||||
Sheet1 |
On 2002-10-21 16:06, frankerrington wrote:
A column has 26,000 entries. Many are repeats. I'd like to count just the unique occurrences