Some similar results to the last from previous post
These are from a File supplied by Raghu


S No
Item
Price
Qty
Total
Distributed
Task1
Task2
Task3
Task4
Completed
Consolidated
Comments
Team Member
1
ABC01
$ 55.00
22
$ 1,210.00
15. Mrz 18
RT1 RT2 RT3 RT4
16. Mrz 18
16. Mrz 18
Raghu
2
ABC02
$ 13.66
7
$ 95.62
15. Mrz 18
JT1 JT2 JT3 JT4
15. Mrz 18
16. Mrz 18
John
3
ABC03
$ 12.99
5
$ 64.95
15. Mrz 18
GT1 GT2 GT3 GT4
16. Mrz 18
16. Mrz 18
Greg
4
ABC04
$ 8.51
12
$ 102.12
15. Mrz 18
MT1 MT2 MT3 MT4
16. Mrz 18
16. Mrz 18
Margaret
5
ABC05
$ 7.22
62
$ 447.64
15. Mrz 18
RT1 RT2 RT3 RT4
16. Mrz 18
16. Mrz 18
Raghu
6
ABC06
$ 3.99
35
$ 139.65
15. Mrz 18
JT1 JT2 JT3 JT4
15. Mrz 18
16. Mrz 18
John
7
ABC07
$ 333.45
99
$ 33,011.55
15. Mrz 18
GT1 GT2 GT3 GT4
16. Mrz 18
16. Mrz 18
Greg
8
ABC08
$ 11.99
1
$ 11.99
15. Mrz 18
MT1 MT2 MT3 MT4
16. Mrz 18
16. Mrz 18
Margaret
9
ABC09
$ 741.99
101
$ 74,940.99
15. Mrz 18
RT1 RT2 RT3 RT4
16. Mrz 18
16. Mrz 18
Raghu
10
ABC10
$ 55.00
22
$ 1,210.00
15. Mrz 18
JT1 JT2 JT3 JT4
15. Mrz 18
16. Mrz 18
John
11
ABC11
$ 13.66
7
$ 95.62
15. Mrz 18
GT1 GT2 GT3 GT4
16. Mrz 18
16. Mrz 18
Greg
12
ABC12
$ 12.99
5
$ 64.95
15. Mrz 18
MT1 MT2 MT3 MT4
16. Mrz 18
16. Mrz 18
Margaret
13
ABC13
$ 8.51
12
$ 102.12
15. Mrz 18
RT1 RT2 RT3 RT4
16. Mrz 18
16. Mrz 18
Raghu
14
ABC14
$ 7.22
62
$ 447.64
15. Mrz 18
JT1 JT2 JT3 JT4
15. Mrz 18
16. Mrz 18
John
15
ABC15
$ 3.99
35
$ 139.65
15. Mrz 18
GT1 GT2 GT3 GT4
16. Mrz 18
16. Mrz 18
Greg
16
ABC16
$ 333.45
99
$ 33,011.55
15. Mrz 18
MT1 MT2 MT3 MT4
16. Mrz 18
16. Mrz 18
Margaret
17
ABC17
$ 11.99
1
$ 11.99
15. Mrz 18
RT1 RT2 RT3 RT4
16. Mrz 18
16. Mrz 18
Raghu
18
ABC18
$ 741.99
101
$ 74,940.99
15. Mrz 18
JT1 JT2 JT3 JT4
16. Mrz 18
16. Mrz 18
John
19
ABC19
$ 55.00
22
$ 1,210.00
15. Mrz 18
GT1 GT2 GT3 GT4
16. Mrz 18
16. Mrz 18
Greg
20
ABC20
$ 13.66
7
$ 95.62
15. Mrz 18
MT1 MT2 MT3 MT4
16. Mrz 18
16. Mrz 18
Margaret
21
ABC21
$ 12.99
5
$ 64.95
15. Mrz 18
Raghu
22
ABC22
$ 8.51
12
$ 102.12
15. Mrz 18
JT1 JT2 JT3 JT4
16. Mrz 18
16. Mrz 18
John
23
ABC23
$ 7.22
62
$ 447.64
15. Mrz 18
Greg
24
ABC24
$ 3.99
35
$ 139.65
15. Mrz 18
MT1 MT2 MT3 MT4
16. Mrz 18
16. Mrz 18
Margaret
25
ABC25
$ 333.45
99
$ 33,011.55
15. Mrz 18
Raghu
26
ABC26
$ 11.99
1
$ 11.99
15. Mrz 18
John
27
ABC27
$ 741.99
101
$ 74,940.99
15. Mrz 18
Greg
28
ABC28
$ 55.00
22
$ 1,210.00
15. Mrz 18
MT1 MT2 MT3 MT4
16. Mrz 18
16. Mrz 18
Margaret
29
ABC29
$ 13.66
7
$ 95.62
15. Mrz 18
Raghu
30
ABC30
$ 12.99
5
$ 64.95
15. Mrz 18
John
31
ABC31
$ 8.51
12
$ 102.12
15. Mrz 18
Greg
32
ABC32
$ 7.22
62
$ 447.64
15. Mrz 18
Margaret
33
ABC33
$ 3.99
35
$ 139.65
15. Mrz 18
Raghu
34
ABC34
$ 333.45
99
$ 33,011.55
15. Mrz 18
John
Worksheet: OriginalData


https://www.youtube.com/watch?v=ITI1HaFeq_g&lc=UgykemWTw-fGoPwu8E14AaABAg.9iECYNx-n4U9iK75iCEaGN
https://www.youtube.com/watch?v=ITI1HaFeq_g&lc=UgykemWTw-fGoPwu8E14AaABAg.9iECYNx-n4U9iK7XF33njy
https://www.youtube.com/watch?v=ITI1HaFeq_g&lc=Ugy_1xkcndYdzUapw-J4AaABAg.9iGOq_leF_E9iKCSgpAqA1
https://www.youtube.com/watch?v=ITI1HaFeq_g&lc=Ugy_1xkcndYdzUapw-J4AaABAg.9iGOq_leF_E9iKCy--3x8E
https://www.youtube.com/watch?v=ITI1HaFeq_g&lc=UgwNaJiNATXshvJ0Zz94AaABAg.9iEktVkTAHk9iF9_pdsh r6
https://www.youtube.com/watch?v=ITI1HaFeq_g&lc=UgykemWTw-fGoPwu8E14AaABAg.9iECYNx-n4U9iFAZq-JEZ-
https://www.youtube.com/watch?v=ITI1HaFeq_g&lc=UgxV2r7KQnuAyZVLHH54AaABAg.9iDVgy6wzct9iFBxma9z XI
https://www.youtube.com/watch?v=ITI1HaFeq_g&lc=Ugx12mI-a39T41NaZ8F4AaABAg.9iDQqIP56NV9iFD0AkeeJG
https://www.youtube.com/watch?v=ITI1HaFeq_g&lc=UgwnYuSngiuYaUhEMWN4AaABAg.9iDQN7TORHv9iFGQQ5z_ 3f
https://www.youtube.com/watch?v=ITI1HaFeq_g&lc=UgwJ3yzdk_EE98dndmt4AaABAg.9iDLC2uEPRW9iFGvgk11 nH
https://www.youtube.com/watch?v=ITI1HaFeq_g&lc=UgyDWAVqCa4yMot463x4AaABAg.9iH3wvUZj3n9iHnpOxOe Xa
https://www.youtube.com/watch?v=ITI1HaFeq_g&lc=UgwvLFdMEAba5rLHIz94AaABAg.9iGReNGzP4v9iHoeaCpT G8
https://www.youtube.com/watch?v=ITI1HaFeq_g&lc=Ugy_1xkcndYdzUapw-J4AaABAg.9iGOq_leF_E9iHpsWCdJ5I