Table of final results for solution to this Thread:
http://www.excelfox.com/forum/showth...0548#post10548
Using Excel 2007 32 bit
S No
Item
Price
Qty
Total
Date Distributed
Task1
Task2
Task3
Task4
Date Tasks Completed
Date Consolidated
Comments
Team Member
1
 A1
$ 25.00
7
$ 175.00
17. Mrz 18
 Done N/A Done N/A
17.Mrz 18
22.Mrz 18
 Raghu
2
 A5
$ 95.00
52
$ 4,940.00
17. Mrz 18
 Done N/A Done N/A
17.Mrz 18
22.Mrz 18
 Raghu
3
 B1
$ 985.00
65
$ 64,025.00
17. Mrz 18
 Raghu
4
 B5
$ 85.00
7
$ 595.00
18. Mrz 18
 Done N/A Done N/A
18.Mrz 18
22.Mrz 18
 Raghu
5
 C1
$ 41.00
52
$ 2,132.00
18. Mrz 18
 N/A Done N/A Done
18.Mrz 18
22.Mrz 18
 Raghu
6
 C5
$ 655.00
65
$ 42,575.00
20. Mrz 18
 Done N/A Done N/A
20.Mrz 18
22.Mrz 18
 Raghu
7
 D1
$ 1,258.00
7
$ 8,806.00
20. Mrz 18
 N/A Done N/A Done
20.Mrz 18
22.Mrz 18
 Raghu
8
 D5
$ 44.00
52
$ 2,288.00
22. Mrz 18
 Raghu
9
 D10
$ 55.00
22
$ 1,210.00
22. Mrz 18
 N/A Done N/A Done
22.Mrz 18
22.Mrz 18
 Raghu
10
 A3
$ 22.00
9
$ 198.00
17. Mrz 18
 Done N/A Done N/A
17.Mrz 18
 Raju
11
 A7
$ 11.00
12
$ 132.00
17. Mrz 18
 Raju
12
 B3
$ 223.00
85
$ 18,955.00
17. Mrz 18
 N/A Done N/A Done
17.Mrz 18
 Raju
13
 B7
$ 63.00
9
$ 567.00
18. Mrz 18
 Done N/A Done N/A
18.Mrz 18
 Raju
14
 C3
$ 96.00
12
$ 1,152.00
18. Mrz 18
 N/A Done N/A Done
18.Mrz 18
 Raju
15
 C7
$ 11.00
85
$ 935.00
20. Mrz 18
 Done N/A Done N/A
20.Mrz 18
 Raju
16
 D3
$ 332.00
9
$ 2,988.00
20. Mrz 18
 N/A Done N/A Done
20.Mrz 18
 Raju
17
 D7
$ 566.00
12
$ 6,792.00
22. Mrz 18
 Done N/A Done N/A
22.Mrz 18
 Raju
18
 A4
$ 45.00
41
$ 1,845.00
17. Mrz 18
 Ramesh
19
 A8
$ 36.00
32
$ 1,152.00
17. Mrz 18
 Done N/A Done N/A
17.Mrz 18
 Ramesh
20
 B4
$ 41.00
96
$ 3,936.00
17. Mrz 18
 N/A Done N/A Done
17.Mrz 18
 Ramesh
21
 B8
$ 52.00
41
$ 2,132.00
18. Mrz 18
 Done N/A Done N/A
18.Mrz 18
 Ramesh
22
 C4
$ 85.00
32
$ 2,720.00
18. Mrz 18
 N/A Done N/A Done
18.Mrz 18
 Ramesh
23
 C8
$ 458.00
96
$ 43,968.00
20. Mrz 18
 Done N/A Done N/A
20.Mrz 18
 Ramesh
24
 D4
$ 22.00
41
$ 902.00
20. Mrz 18
 N/A Done N/A Done
20.Mrz 18
 Ramesh
25
 D8
$ 332.00
32
$ 10,624.00
22. Mrz 18
 Done N/A Done N/A
22.Mrz 18
 Ramesh
26
 A2
$ 35.00
8
$ 280.00
17. Mrz 18
 Done N/A Done N/A
17.Mrz 18
 Ravi
27
 A6
$ 78.00
63
$ 4,914.00
17. Mrz 18
 Done N/A Done N/A
17.Mrz 18
 Ravi
28
 B2
$ 11.00
47
$ 517.00
17. Mrz 18
 N/A Done N/A Done
17.Mrz 18
 Ravi
29
 B6
$ 96.00
8
$ 768.00
18. Mrz 18
 Ravi
30
 C2
$ 74.00
63
$ 4,662.00
18. Mrz 18
 Ravi
31
 C6
$ 365.00
47
$ 17,155.00
20. Mrz 18
 Ravi
32
 D2
$ 33.00
8
$ 264.00
20. Mrz 18
 N/A Done N/A Done
20.Mrz 18
 Ravi
33
 D6
$ 55.00
63
$ 3,465.00
22. Mrz 18
 Done N/A Done N/A
22.Mrz 18
 Ravi
34
 A9
$ 12.00
65
$ 780.00
22. Mrz 18
 Sangeeta
35
 B9
$ 45.00
47
$ 2,115.00
22. Mrz 18
 Done N/A Done N/A
21.Mrz 18
 Sangeeta
36
 C9
$ 56.00
85
$ 4,760.00
22. Mrz 18
 N/A Done N/A Done
21.Mrz 18
 Sangeeta
37
 D9
$ 89.00
96
$ 8,544.00
22. Mrz 18
 Done N/A Done N/A
21.Mrz 18
 Sangeeta
38
 A10
$ 25.00
3
$ 75.00
22. Mrz 18
 N/A Done N/A Done
21.Mrz 18
 Sangeeta
Worksheet: Sheet1





https://www.youtube.com/watch?v=vXyMScSbhk4
https://www.youtube.com/watch?v=vXyMScSbhk4&lc=UgynOSp1dleo-Z8L_QN4AaABAg.9jJLDC1Z6L-9k68CuL4aTY
https://www.youtube.com/watch?v=vXyMScSbhk4&lc=UgwV5N_ulFXYMNbyQG54AaABAg.9itCkoVN4w79itOVYVvE wQ
https://www.youtube.com/watch?v=vXyMScSbhk4&lc=UgyOh-eR43LvlIJLG5p4AaABAg.9isnKJoRfbL9itPC-4uckb
https://www.youtube.com/watch?v=vXyMScSbhk4&lc=Ugy1B1aQnHq2WbbucmR4AaABAg.9isY3Ezhx4j9itQLuif2 6T
https://www.youtube.com/watch?v=vXyMScSbhk4&lc=UgxxajSt03TX1wxh3IJ4AaABAg.9irSL7x4Moh9itTRqL7d Qh
https://www.youtube.com/watch?v=vXyMScSbhk4&lc=Ugxa2VYHMWJWXA6QI294AaABAg.9irLgSdeU3r9itU7zdnW Hw
https://www.youtube.com/watch?v=vXyMScSbhk4&lc=UgwJAAPbp8dhkW2X1Uh4AaABAg.9iraombnLDb9itV80HDp Xc
https://www.youtube.com/watch?v=vXyMScSbhk4&lc=UgzIzQ6MQ5kTpuLbIuB4AaABAg.9is0FSoF2Wi9itWKEvGS Sq