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