Description
Hi all,
Looking for someone who is professional on Excel.
See the attachments below.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Hi, Please check and give me a feedback. Tell me if anything needs to be changed. 😊
Invoice Number
Sale Date
Item Category
10001
1/1/2019 Tools
10002
1/2/2019 Office Supplies
10002
1/2/2019 Automotive
10002
1/2/2019 Tools
10002
1/2/2019 Clothing
10002
1/2/2019 Electronics
10003
1/3/2019 Office Supplies
10003
1/3/2019 Crafts
10004
1/4/2019 Groceries
10004
1/4/2019 Automotive
10004
1/4/2019 Tools
10004
1/4/2019 Tools
10004
1/4/2019 Automotive
10005
1/4/2019 Tools
10005
1/4/2019 Jewelry
10006
1/4/2019 Electronics
10007
1/5/2019 Clothing
10008
1/6/2019 Home Living
10009
1/6/2019 Electronics
10010
1/6/2019 Tools
10010
1/6/2019 Tools
10010
1/6/2019 Electronics
10010
1/6/2019 Baby
10010
1/6/2019 Baby
10011
1/6/2019 Groceries
10011
1/6/2019 Electronics
10012
1/6/2019 Tools
10012
1/6/2019 Jewelry
10012
1/6/2019 Jewelry
10012
1/6/2019 Clothing
10013
1/7/2019 Pets
10013
1/7/2019 Home Living
10014
1/7/2019 Crafts
10014
1/7/2019 Home Living
10014
1/7/2019 Baby
10015
1/7/2019 Clothing
10015
1/7/2019 Office Supplies
10016
1/7/2019 Home Living
10017
1/7/2019 Electronics
10017
1/7/2019 Groceries
10018
1/7/2019 Clothing
10019
1/7/2019 Automotive
10019
1/7/2019 Electronics
10019
1/7/2019 Clothing
10019
1/7/2019 Baby
10019
1/7/2019 Office Supplies
Individual Price
3.22
12.36
7.35
3.03
9.04
6.32
11.49
10.98
12.33
11.24
12.72
10.51
2.3
12.26
5.55
6.94
5.52
9.41
12.45
12
13.52
6.33
9.52
26.4
10.05
12.29
13.66
9
8.27
5.85
23.94
9.4
10.79
9.51
23.29
8.12
11.55
6.76
9.21
6.66
5.6
6.4
3.93
2.68
18.29
24.14
Quantity Sold
4
5
4
5
1
2
3
3
2
4
4
3
1
1
5
4
1
4
1
2
1
2
1
3
5
2
2
1
3
4
3
5
5
5
5
3
4
2
1
1
1
4
4
4
3
5
Subtotal
12.88
61.8
29.4
15.15
9.04
12.64
34.47
32.94
24.66
44.96
50.88
31.53
2.3
12.26
27.75
27.76
5.52
37.64
12.45
24
13.52
12.66
9.52
79.2
50.25
24.58
27.32
9
24.81
23.4
71.82
47
53.95
47.55
116.45
24.36
46.2
13.52
9.21
6.66
5.6
25.6
15.72
10.72
54.87
120.7
10020
10020
10020
10020
10020
10021
10022
10023
10024
10024
10024
10025
10025
10026
10026
10026
10026
10026
10027
10027
10028
10028
10028
10028
10028
10029
10029
10030
10030
10030
10031
10031
10031
10031
10031
10031
10031
10032
10032
10032
10033
10033
10033
10033
10034
10034
10034
1/7/2019
1/7/2019
1/7/2019
1/7/2019
1/7/2019
1/7/2019
1/7/2019
1/8/2019
1/9/2019
1/9/2019
1/9/2019
1/10/2019
1/10/2019
1/11/2019
1/11/2019
1/11/2019
1/11/2019
1/11/2019
1/12/2019
1/12/2019
1/13/2019
1/13/2019
1/13/2019
1/13/2019
1/13/2019
1/14/2019
1/14/2019
1/14/2019
1/14/2019
1/14/2019
1/14/2019
1/14/2019
1/14/2019
1/14/2019
1/14/2019
1/14/2019
1/14/2019
1/14/2019
1/14/2019
1/14/2019
1/15/2019
1/15/2019
1/15/2019
1/15/2019
1/16/2019
1/16/2019
1/16/2019
Home Living
Baby
Automotive
Pets
Tools
Pets
Home Living
Crafts
Office Supplies
Jewelry
Tools
Automotive
Crafts
Crafts
Clothing
Jewelry
Office Supplies
Groceries
Clothing
Electronics
Office Supplies
Jewelry
Jewelry
Baby
Jewelry
Office Supplies
Pets
Crafts
Groceries
Automotive
Groceries
Automotive
Pets
Electronics
Pets
Tools
Home Living
Groceries
Baby
Groceries
Home Living
Electronics
Jewelry
Jewelry
Crafts
Groceries
Pets
6.23
19.62
4.08
73.9
6.37
65.7
10.21
12.2
5.11
6.11
9.02
3.67
13.69
13.38
3.01
9.92
4.02
10.92
2.31
10.4
19.03
8.11
10.73
14.26
6.75
20.55
12.37
11.78
6.03
7.83
8.81
3.43
75.52
7.88
75.53
11.38
11.1
8.95
17.55
4.97
2.88
11.87
5.56
9.03
12.01
7.86
29.87
3
5
3
4
1
3
1
5
5
1
5
1
3
3
2
1
2
3
1
1
2
2
4
2
5
5
1
2
3
4
2
5
2
5
5
4
4
2
3
1
2
4
5
2
3
1
2
18.69
98.1
12.24
295.6
6.37
197.1
10.21
61
25.55
6.11
45.1
3.67
41.07
40.14
6.02
9.92
8.04
32.76
2.31
10.4
38.06
16.22
42.92
28.52
33.75
102.75
12.37
23.56
18.09
31.32
17.62
17.15
151.04
39.4
377.65
45.52
44.4
17.9
52.65
4.97
5.76
47.48
27.8
18.06
36.03
7.86
59.74
10034
10034
10034
10034
10034
10034
10035
10035
10036
10036
10037
10037
10038
10038
10038
10038
10038
10039
10040
10041
10042
10042
10043
10044
10044
10044
10045
10046
10047
10048
10048
10048
10048
10048
10048
10048
10049
10049
10049
10049
10050
10050
10050
10050
10051
10051
10051
1/16/2019
1/16/2019
1/16/2019
1/16/2019
1/16/2019
1/16/2019
1/16/2019
1/16/2019
1/17/2019
1/17/2019
1/17/2019
1/17/2019
1/17/2019
1/17/2019
1/17/2019
1/17/2019
1/17/2019
1/17/2019
1/18/2019
1/18/2019
1/19/2019
1/19/2019
1/20/2019
1/20/2019
1/20/2019
1/20/2019
1/21/2019
1/21/2019
1/21/2019
1/21/2019
1/21/2019
1/21/2019
1/21/2019
1/21/2019
1/21/2019
1/21/2019
1/22/2019
1/22/2019
1/22/2019
1/22/2019
1/22/2019
1/22/2019
1/22/2019
1/22/2019
1/22/2019
1/22/2019
1/22/2019
Automotive
Tools
Baby
Groceries
Office Supplies
Crafts
Home Living
Automotive
Automotive
Baby
Jewelry
Groceries
Baby
Home Living
Automotive
Tools
Tools
Office Supplies
Office Supplies
Home Living
Office Supplies
Baby
Electronics
Baby
Pets
Crafts
Groceries
Baby
Baby
Jewelry
Jewelry
Electronics
Home Living
Automotive
Jewelry
Crafts
Office Supplies
Office Supplies
Crafts
Baby
Jewelry
Automotive
Tools
Office Supplies
Clothing
Jewelry
Tools
10.67
6.98
19.4
7.93
18.89
11.73
9.81
4.37
1.97
7.57
5.4
11.58
24.23
3.25
10.42
3.05
15.94
5.59
21.94
7
10.63
13.24
3.67
22.82
19.42
10.96
10
18.08
28.51
3.09
5.58
3.54
10.98
3.81
3.41
8.75
17.75
20.82
7.2
27.76
8.81
11.11
5.77
4.59
2.39
4.22
3.55
5
3
3
4
3
2
4
4
1
5
4
2
5
5
4
4
1
5
2
1
4
5
4
2
3
5
3
1
1
3
5
1
2
3
4
5
2
4
4
2
4
2
3
4
5
4
1
53.35
20.94
58.2
31.72
56.67
23.46
39.24
17.48
1.97
37.85
21.6
23.16
121.15
16.25
41.68
12.2
15.94
27.95
43.88
7
42.52
66.2
14.68
45.64
58.26
54.8
30
18.08
28.51
9.27
27.9
3.54
21.96
11.43
13.64
43.75
35.5
83.28
28.8
55.52
35.24
22.22
17.31
18.36
11.95
16.88
3.55
10052
10052
10052
10053
10053
10054
10054
10054
10055
10055
10056
10057
10057
10057
10057
10058
10058
10058
10059
10060
10060
10060
10060
10060
10060
10060
10060
10061
10061
10062
10062
10062
10062
10063
10063
10063
10063
10063
10063
10063
10063
10063
10063
10063
10063
10063
10064
1/23/2019
1/23/2019
1/23/2019
1/23/2019
1/23/2019
1/24/2019
1/24/2019
1/24/2019
1/25/2019
1/25/2019
1/26/2019
1/26/2019
1/26/2019
1/26/2019
1/26/2019
1/27/2019
1/27/2019
1/27/2019
1/27/2019
1/28/2019
1/28/2019
1/28/2019
1/28/2019
1/28/2019
1/28/2019
1...