Filter Tricks AvtechandTravel.xlsx

	A	B	C	D	E	F	H	I	J	K	L	M
1	Emp ID	Employee Name	Department	Hire Date	Monthly Salary	Annual Salary	sales			Department
2	1	Lisa	Sales	4/8/2019	54,550	654,600	employer name	department	hire date	monthly salary	anual salary
3	2	Mary	Sales	3/30/2019	86,795	1,041,540	1	Lisa	Sales	4/8/2019	54,550	654,600
4	3	Jonathan	Administration	2/21/2019	43,540	522,480	2	Mary	Sales	3/30/2019	86,795	1,041,540
5	4	Eric	HR	2/24/2019	92,830	1,113,960	5	Linda	Sales	43,570	60,830	729,960
6	5	Linda	Sales	4/15/2019	60,830	729,960	8	Smith	Sales	43,494	30,780	369,360
7	6	Joe	Marketing	2/24/2019	65,580	786,960
8	7	Frank	Finance	2/28/2019	75,150	901,800
9	8	Smith	Sales	1/29/2019	30,780	369,360
10	9	Nizza	Finance	4/3/2019	49,350	592,200
11	10	Maria	Marketing	1/11/2019	89,760	1,077,120
12	11	Daniel	Administration	1/30/2019	74,840	898,080
13	12	Donald	Finance	1/5/2019	49,070	588,840
14	13	Cristy	HR	3/5/2020	50,000	600,000
15	14	Riya	IT	6/8/2020	50,000	600,000
16	15	John	HR	8/10/2020	48,000	576,000
17	16	Ben	HR	9/10/2020	35,000	420,000
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100