Mock Data | CountIF & Unique

	A	B	C	D	E	F	G	H
1	ID	First Name	Last Name	Gener	Employer Number	Department	Department	Count
2	1	Stephanie	Harper	Female	56-5679800	Sales	Sales	95
3	2	George	Moreno	Male	67-7951582	Research and Development	Research and Development	78
4	3	Adam	Harper	Male	73-8703974	Engineering	Engineering	90
5	4	Louis	Fuller	Male	71-8547191	Accounting	Accounting	84
6	5	Pamela	Gonzalez	Female	94-7329983	Research and Development	Business Development	96
7	6	Louis	Fernandez	Male	76-8056269	Business Development	Marketing	88
8	7	Jimmy	Gomez	Male	93-7677078	Sales	Human Resources	76
9	8	Jimmy	Morgan	Male	42-1303962	Business Development	Legal	88
10	9	Ronald	Wagner	Male	19-8879394	Marketing	Support	82
11	10	Christine	Hicks	Female	94-9537430	Human Resources	Training	72
12	11	Linda	Snyder	Female	30-9058324	Legal	Services	71
13	12	Joyce	Hawkins	Female	42-9599661	Support	Product Management	80
14	13	Carol	Roberts	Female	72-6399923	Marketing		0
15	14	Susan	Martinez	Female	86-1978598	Human Resources
16	15	Walter	Hernandez	Male	96-4135358	Business Development
17	16	Angela	Ellis	Female	74-8780398	Marketing
18	17	Rose	Foster	Female	86-8038656	Training
19	18	Paul	Chavez	Male	11-4606427	Human Resources
20	19	Daniel	Sims	Male	22-9750764	Research and Development
21	20	Edward	Johnson	Male	10-7564866	Legal
22	21	Barbara	Carter	Female	48-5897525	Training
23	22	Lori	Webb	Female	58-4357889	Engineering
24	23	Ronald	Simmons	Male	74-7732018	Training
25	24	Arthur	Collins	Male	24-5316647	Marketing
26	25	Tina	Hicks	Female	36-4380311	Services
27	26	Joseph	Williamson	Male	58-1685503	Human Resources
28	27	Jimmy	Fisher	Male	00-9679434	Research and Development
29	28	Anne	Wheeler	Female	46-9378979	Marketing
30	29	Stephanie	Rogers	Female	25-9306167	Accounting
31	30	Amy	Nguyen	Female	16-9712857	Sales
32	31	Mildred	Murray	Female	30-9610957	Sales
33	32	Mark	Bryant	Male	97-7936392	Support
34	33	Timothy	Black	Male	07-0981512	Business Development
35	34	Laura	Cook	Female	01-0692870	Services
36	35	Walter	Hall	Male	53-4010119	Marketing
37	36	Judith	Jones	Female	35-3630521	Product Management
38	37	Kimberly	Long	Female	02-1186333	Research and Development
39	38	Stephen	Arnold	Male	82-7407623	Support
40	39	Robin	Kim	Female	43-4846437	Services
41	40	Christina	Carpenter	Female	77-4623677	Marketing
42	41	Arthur	Bailey	Male	64-8645653	Legal
43	42	Stephanie	Gonzales	Female	63-4656520	Sales
44	43	Walter	George	Male	87-3309485	Sales
45	44	Walter	Pierce	Male	17-7156179	Human Resources
46	45	Deborah	Morrison	Female	58-2268256	Research and Development
47	46	Tina	Lewis	Female	02-9343903	Legal
48	47	Laura	Long	Female	61-9864565	Legal
49	48	Ernest	Thompson	Male	30-2684553	Services
50	49	William	Jenkins	Male	63-1321540	Legal
51	50	Louise	Harvey	Female	38-1693167	Training
52	51	Louise	Young	Female	76-0653283	Accounting
53	52	Ann	Knight	Female	23-2309925	Sales
54	53	Phillip	Peterson	Male	65-2543118	Services
55	54	Charles	Stephens	Male	05-5312355	Marketing
56	55	Emily	Montgomery	Female	49-5358381	Legal
57	56	Joseph	Roberts	Male	16-7273718	Training
58	57	Annie	Warren	Female	45-8660954	Research and Development
59	58	Kevin	Young	Male	13-2807553	Research and Development
60	59	Billy	Dixon	Male	77-5603320	Engineering
61	60	Bonnie	Crawford	Female	55-7244088	Support
62	61	Billy	Mccoy	Male	38-7324883	Engineering
63	62	Stephen	Williams	Male	81-2692240	Business Development
64	63	Martha	Clark	Female	22-5602156	Sales
65	64	Patricia	Stanley	Female	08-1941636	Accounting
66	65	Ruby	Hawkins	Female	49-9741417	Research and Development
67	66	Michelle	Mccoy	Female	51-3056588	Human Resources
68	67	Frances	Flores	Female	63-2479249	Engineering
69	68	Louise	Fields	Female	45-7293021	Accounting
70	69	Virginia	Spencer	Female	07-3828579	Business Development
71	70	Walter	Hudson	Male	76-5253912	Legal
72	71	Roy	Coleman	Male	38-1806341	Sales
73	72	Christina	Phillips	Female	56-5524073	Product Management
74	73	Wanda	Carter	Female	01-4849504	Human Resources
75	74	Marilyn	Reynolds	Female	81-1106727	Marketing
76	75	Ryan	Ruiz	Male	44-4481473	Training
77	76	Lisa	Morrison	Female	84-1106923	Services
78	77	Randy	Morris	Male	10-5142878	Support
79	78	Kathleen	Kelly	Female	21-1366782	Accounting
80	79	Martha	Martinez	Female	46-3967396	Support
81	80	Carl	Johnson	Male	13-2558713	Marketing
82	81	Maria	Cook	Female	03-7301200	Legal
83	82	Douglas	Grant	Male	07-6692631	Training
84	83	Melissa	Hudson	Female	88-9177312	Support
85	84	Patricia	Ortiz	Female	11-9765232	Support
86	85	Charles	Nichols	Male	05-4785701	Legal
87	86	Maria	Cole	Female	82-0107017	Marketing
88	87	Steve	Franklin	Male	82-0943114	Sales
89	88	Amanda	Bell	Female	75-2741739	Training
90	89	Peter	Jordan	Male	71-9197644	Product Management
91	90	Rebecca	Ramos	Female	85-8531694	Human Resources
92	91	Emily	Little	Female	78-2433810	Accounting
93	92	Ernest	Williamson	Male	27-9678352	Business Development
94	93	Linda	Phillips	Female	72-7836146	Engineering
95	94	Patrick	Hall	Male	53-8889384	Marketing
96	95	Roy	Palmer	Male	96-4391348	Services
97	96	Sean	Daniels	Male	42-7959534	Services
98	97	Roy	Roberts	Male	24-0671880	Marketing
99	98	Ann	Hanson	Female	57-5241627	Research and Development
100	99	John	Robinson	Male	58-9550111	Business Development