Corticus
Well-known Member
- Joined
- Apr 30, 2002
- Messages
- 1,579
Hi all!
I'm trying to filter a data-set for unique records, as follows:
Any help would be greatly appreciated,
Thanks!
Corticus
This message was edited by Corticus on 2002-09-12 13:09
I'm trying to filter a data-set for unique records, as follows:
Book4 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | LastName | FirstName | Service | UnitsServed | ||
2 | Brooks | Steve | CM | 0 | ||
3 | Brooks | Steve | CM | 0 | ||
4 | Smith | Aaron | NTED | 1 | ||
5 | Smith | Aaron | NTED | 0 | ||
6 | Smith | Aaron | NTED | 0 | ||
7 | Smith | Aaron | NTED | 0 | ||
8 | Jones | Mike | CM | 5 | ||
9 | Jones | Mike | CM | 5 | ||
10 | Killy | Raymond | HDM | 1 | ||
11 | Watson | Dr. | EAR | 0 | ||
12 | ||||||
13 | wouldfilterto: | |||||
14 | ||||||
15 | LastName | FirstName | Service | UnitsServed | ||
16 | Brooks | Steve | CM | 0 | ||
17 | Smith | Aaron | NTED | 1 | ||
18 | Smith | Aaron | NTED | 0 | ||
19 | Jones | Mike | CM | 5 | ||
20 | Killy | Raymond | HDM | 1 | ||
21 | Watson | Dr. | EAR | 0 | ||
Sheet1 |
Any help would be greatly appreciated,
Thanks!
Corticus
This message was edited by Corticus on 2002-09-12 13:09