Page 3 of 55 FirstFirst 123451353 ... LastLast
Results 21 to 30 of 541

Thread: Appendix Thread. 3 *

  1. #21
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,455
    Rep Power
    10

    Master File After First Consolidation

    kjlksjklsjg


    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgwviLabd7r_3KpP6wh4AaABAg.9h5lFRmix1R9h78GftO_ iE
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgyG714V_k7odQMrTz14AaABAg.9h740K6COOA9h77HSGDH 4A
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgyG714V_k7odQMrTz14AaABAg.9h740K6COOA9h76fafzc EJ
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgyG714V_k7odQMrTz14AaABAg.9h740K6COOA9h759YIjl aG
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgyG714V_k7odQMrTz14AaABAg.9h740K6COOA9h74pjGcb Eq
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgyG714V_k7odQMrTz14AaABAg
    https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgzJJUDVv2Mb6YGkPYh4AaABAg.9h5uPRbWIZl9h7165DZd jg
    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA



    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgxzpgHWTLGj0C3q3gx4AaABAg.9gxsUMU53al9k5c8W6QG E8
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=Ugz2PzvZTJyxHz70eVF4AaABAg.9gxDYq2iiZ89h4ISxLD1 7d
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=Ugz2PzvZTJyxHz70eVF4AaABAg.9gxDYq2iiZ89h4LdsDET im
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=Ugz2PzvZTJyxHz70eVF4AaABAg.9gxDYq2iiZ89h32czjty R_
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgxzpgHWTLGj0C3q3gx4AaABAg
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=Ugw_smEwvNffCPr_nrB4AaABAg.9gvyL53lI1l9gxwd_9-V6z
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=Ugy7vmiHsQ0oUt2QCPZ4AaABAg.9gvoy4OW6lU9gxwxC5-rL9
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgzuX3uYmqJRtsZIbqF4AaABAg.9gth61YhXKB9gxxCMdRL A0
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgxcPC64RQGmXwO5rft4AaABAg.9gtQLXaeg0e9gxxNuc5C CM
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgwCY8vOs1DFHgYSJwF4AaABAg.9godrFcyWYw9gxy1odpi Rj
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgyL5nh_j8w70-YBoUt4AaABAg.9goMcRjwjtc9gxyslvuZKx
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgwwWRgmRZNqJKptHR14AaABAg.9go-DbayTZa9gxzPbefHXf
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgwF3wECwc8tVoRmz6B4AaABAg.9go-5xLQM8P9gxzmB7nkVQ
    https://www.youtube.com/watch?v=xLCWtC6UYrM&lc=UgyRDmGTHnMdT7dl_qx4AaABAg
    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA


    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=Ugxq4JHRza_zx3sz0fx4AaABAg
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=UgzMCQUIQgrbec400jl4AaABAg
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=UgwhVTFaD469mW9wO194AaABAg.9gJzxwFcnPU9gORqKw5t W_
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=Ugyb8nmKKoXvcdM58gV4AaABAg
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=UgwvvXcl1oa79xS7BAV4AaABAg
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=UgxvIFArksPprylHXYZ4AaABAg
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=Ugxq4JHRza_zx3sz0fx4AaABAg
    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    A Folk, A Forum, A Fuhrer ….

  2. #22
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,455
    Rep Power
    10
    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
    A Folk, A Forum, A Fuhrer ….

  3. #23
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,455
    Rep Power
    10
    Bottom part of worksheet shown in last Post
    here we see new data added ( rows 47 to 51 ( S No 46 - S no 50 )

    Using Excel 2007 32 bit
    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
    35
    ABC35
    $ 11.99
    1
    $ 11.99
    15. Mrz 18
    Greg
    36
    ABC36
    $ 741.99
    101
    $ 74,940.99
    15. Mrz 18
    Margaret
    37
    ABC37
    $ 55.00
    22
    $ 1,210.00
    15. Mrz 18
    Raghu
    38
    ABC38
    $ 13.66
    7
    $ 95.62
    15. Mrz 18
    John
    39
    ABC39
    $ 12.99
    5
    $ 64.95
    15. Mrz 18
    Greg
    40
    ABC40
    $ 8.51
    12
    $ 102.12
    15. Mrz 18
    Margaret
    41
    ABC41
    $ 7.22
    62
    $ 447.64
    15. Mrz 18
    Raghu
    42
    ABC42
    $ 3.99
    35
    $ 139.65
    15. Mrz 18
    John
    43
    ABC43
    $ 333.45
    99
    $ 33,011.55
    15. Mrz 18
    Greg
    44
    ABC44
    $ 11.99
    1
    $ 11.99
    15. Mrz 18
    Margaret
    45
    ABC45
    $ 741.99
    101
    $ 74,940.99
    15. Mrz 18
    Raghu
    46
    ABC46
    $ 8.51
    12
    $ 102.12
    16. Mrz 18
    John
    47
    ABC47
    $ 7.22
    62
    $ 447.64
    16. Mrz 18
    Greg
    48
    ABC48
    $ 3.99
    35
    $ 139.65
    16. Mrz 18
    Margaret
    49
    ABC49
    $ 333.45
    99
    $ 33,011.55
    16. Mrz 18
    Raghu
    50
    ABC50
    $ 11.99
    1
    $ 11.99
    16. Mrz 18
    Raghu
    Worksheet: OriginalData
    A Folk, A Forum, A Fuhrer ….

  4. #24
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,455
    Rep Power
    10

    Typical Updated Data File, "Raghu.xlsx" after first consolidation

    Typical Updated Data File, "Raghu.xlsx" after first consolidation,
    with the column L updated appropriately with the consolidation date



    Using Excel 2007 32 bit
    Row\Col
    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
    M
    N
    O
    1
    S No
    Item
    Price
    Qty
    Total
    Distributed
    Task1
    Task2
    Task3
    Task4
    Completed
    Consolidated
    Comments
    Team Member
    2
    1
    ABC01
    $ 55.00
    22
    $ 1,210.00
    02.Apr.2018 RT1 RT2 RT3 RT4
    02. Apr 18
    02.Apr.2018 Raghu
    3
    5
    ABC05
    $ 7.22
    62
    $ 447.64
    02.Apr.2018 RT1 RT2 RT3 RT4
    02. Apr 18
    02.Apr.2018 Raghu
    4
    9
    ABC09
    $ 741.99
    101
    $ 74,940.99
    02.Apr.2018 RT1 RT2 RT3 RT4
    02. Apr 18
    02.Apr.2018 Raghu
    5
    13
    ABC13
    $ 8.51
    12
    $ 102.12
    02.Apr.2018 RT1 RT2 RT3 RT4
    02. Apr 18
    02.Apr.2018 Raghu
    6
    17
    ABC17
    $ 11.99
    1
    $ 11.99
    02.Apr.2018 RT1 RT2 RT3 RT4
    02. Apr 18
    02.Apr.2018 Raghu
    7
    21
    ABC21
    $ 12.99
    5
    $ 64.95
    02.Apr.2018 Raghu
    8
    25
    ABC25
    $ 333.45
    99
    $ 33,011.55
    02.Apr.2018 Raghu
    9
    29
    ABC29
    $ 13.66
    7
    $ 95.62
    02.Apr.2018 Raghu
    10
    33
    ABC33
    $ 3.99
    35
    $ 139.65
    02.Apr.2018 Raghu
    11
    37
    ABC37
    $ 55.00
    22
    $ 1,210.00
    02.Apr.2018 Raghu
    12
    41
    ABC41
    $ 7.22
    62
    $ 447.64
    02.Apr.2018 Raghu
    13
    45
    ABC45
    $ 741.99
    101
    $ 74,940.99
    02.Apr.2018 Raghu
    14
    Worksheet: Tabelle1


    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://www.youtube.com/watch?v=U76ZRIzBhOA&lc=UgxsozCmRd3RAmIPO5B4AaABAg.9fxrOrrvTln9g9wr8mv2 CS
    https://www.youtube.com/watch?v=U76ZRIzBhOA&lc=Ugw6zxOMtNCfmdllKQl4AaABAg
    https://www.youtube.com/watch?v=U76ZRIzBhOA&lc=UgyT1lo2YMUyZ50bLeR4AaABAg.9fz3_oaiUeK9g96yGbAX 4t
    https://www.youtube.com/watch?v=U76ZRIzBhOA&lc=Ugx5d-LrmoMM_hsJK2N4AaABAg.9fyL20jCtOI9g7pczEpcTz
    https://www.youtube.com/watch?v=U76ZRIzBhOA&lc=UgyT1lo2YMUyZ50bLeR4AaABAg.9fz3_oaiUeK9g7lhoX-ar5
    https://www.youtube.com/watch?v=U76ZRIzBhOA&lc=Ugx5d-LrmoMM_hsJK2N4AaABAg.9fyL20jCtOI9gD0AA-sfpl
    https://www.youtube.com/watch?v=U76ZRIzBhOA&lc=Ugx5d-LrmoMM_hsJK2N4AaABAg.9fyL20jCtOI9gECpsAVGbh
    https://www.youtube.com/watch?v=U76ZRIzBhOA&lc=Ugw6zxOMtNCfmdllKQl4AaABAg.9g9wJCunNRa9gJGhDZ4R I2
    https://www.youtube.com/watch?v=Sh1kZD7EVj0&lc=Ugz-pow-E8FDG8gFZ4l4AaABAg.9f8Bng22e5d9f8hoJGZY-5
    https://www.youtube.com/watch?v=Sh1kZD7EVj0&lc=Ugxev2gQt7BKZ0WYMfh4AaABAg.9f6hAjkC0ct9f8jleOui-u
    https://www.youtube.com/watch?v=Sh1kZD7EVj0&lc=Ugxg9iT7MPWGBWruIzR4AaABAg
    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA


    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://www.youtube.com/watch?v=U76ZRIzBhOA&lc=UgxsozCmRd3RAmIPO5B4AaABAg.9fxrOrrvTln9g9wr8mv2 CS
    https://www.youtube.com/watch?v=U76ZRIzBhOA&lc=Ugw6zxOMtNCfmdllKQl4AaABAg
    https://www.youtube.com/watch?v=U76ZRIzBhOA&lc=UgyT1lo2YMUyZ50bLeR4AaABAg.9fz3_oaiUeK9g96yGbAX 4t
    https://www.youtube.com/watch?v=U76ZRIzBhOA&lc=Ugx5d-LrmoMM_hsJK2N4AaABAg.9fyL20jCtOI9g7pczEpcTz
    https://www.youtube.com/watch?v=U76ZRIzBhOA&lc=UgyT1lo2YMUyZ50bLeR4AaABAg.9fz3_oaiUeK9g7lhoX-ar5
    https://www.youtube.com/watch?v=U76ZRIzBhOA&lc=Ugx5d-LrmoMM_hsJK2N4AaABAg.9fyL20jCtOI9gD0AA-sfpl
    https://www.youtube.com/watch?v=U76ZRIzBhOA&lc=Ugx5d-LrmoMM_hsJK2N4AaABAg.9fyL20jCtOI9gECpsAVGbh
    https://www.youtube.com/watch?v=U76ZRIzBhOA&lc=Ugw6zxOMtNCfmdllKQl4AaABAg.9g9wJCunNRa9gJGhDZ4R I2
    https://www.youtube.com/watch?v=Sh1kZD7EVj0&lc=Ugz-pow-E8FDG8gFZ4l4AaABAg.9f8Bng22e5d9f8hoJGZY-5
    https://www.youtube.com/watch?v=Sh1kZD7EVj0&lc=Ugxev2gQt7BKZ0WYMfh4AaABAg.9f6hAjkC0ct9f8jleOui-u
    https://www.youtube.com/watch?v=Sh1kZD7EVj0&lc=Ugxg9iT7MPWGBWruIzR4AaABAg
    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    A Folk, A Forum, A Fuhrer ….

  5. #25
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,455
    Rep Power
    10
    “zMasterAfter1stConsolidationNewData.xlsm” : https://app.box.com/s/ascky2qg47dzl85b4y7l8sy5qmr3goby




    Using Excel 2007 32 bit
    Row\Col
    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
    M
    N
    O
    19
    18
    ABC18
    $ 741.99
    101
    $ 74,940.99
    02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 02.Apr.2018 John
    20
    19
    ABC19
    $ 55.00
    22
    $ 1,210.00
    02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 02.Apr.2018 Greg
    21
    20
    ABC20
    $ 13.66
    7
    $ 95.62
    02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret
    22
    21
    ABC21
    $ 12.99
    5
    $ 64.95
    02.Apr.2018 Raghu
    23
    22
    ABC22
    $ 8.51
    12
    $ 102.12
    02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 02.Apr.2018 John
    24
    23
    ABC23
    $ 7.22
    62
    $ 447.64
    02.Apr.2018 Greg
    25
    24
    ABC24
    $ 3.99
    35
    $ 139.65
    02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret
    26
    25
    ABC25
    $ 333.45
    99
    $ 33,011.55
    02.Apr.2018 Raghu
    27
    26
    ABC26
    $ 11.99
    1
    $ 11.99
    02.Apr.2018 John
    28
    27
    ABC27
    $ 741.99
    101
    $ 74,940.99
    02.Apr.2018 Greg
    29
    28
    ABC28
    $ 55.00
    22
    $ 1,210.00
    02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret
    30
    29
    ABC29
    $ 13.66
    7
    $ 95.62
    02.Apr.2018 Raghu
    31
    30
    ABC30
    $ 12.99
    5
    $ 64.95
    02.Apr.2018 John
    32
    31
    ABC31
    $ 8.51
    12
    $ 102.12
    02.Apr.2018 Greg
    33
    32
    ABC32
    $ 7.22
    62
    $ 447.64
    02.Apr.2018 Margaret
    34
    33
    ABC33
    $ 3.99
    35
    $ 139.65
    02.Apr.2018 Raghu
    35
    34
    ABC34
    $ 333.45
    99
    $ 33,011.55
    02.Apr.2018 John
    36
    35
    ABC35
    $ 11.99
    1
    $ 11.99
    02.Apr.2018 Greg
    37
    36
    ABC36
    $ 741.99
    101
    $ 74,940.99
    02.Apr.2018 Margaret
    38
    37
    ABC37
    $ 55.00
    22
    $ 1,210.00
    02.Apr.2018 Raghu
    39
    38
    ABC38
    $ 13.66
    7
    $ 95.62
    02.Apr.2018 John
    40
    39
    ABC39
    $ 12.99
    5
    $ 64.95
    02.Apr.2018 Greg
    41
    40
    ABC40
    $ 8.51
    12
    $ 102.12
    02.Apr.2018 Margaret
    42
    41
    ABC41
    $ 7.22
    62
    $ 447.64
    02.Apr.2018 Raghu
    43
    42
    ABC42
    $ 3.99
    35
    $ 139.65
    02.Apr.2018 John
    44
    43
    ABC43
    $ 333.45
    99
    $ 33,011.55
    02.Apr.2018 Greg
    45
    44
    ABC44
    $ 11.99
    1
    $ 11.99
    02.Apr.2018 Margaret
    46
    45
    ABC45
    $ 741.99
    101
    $ 74,940.99
    02.Apr.2018 Raghu
    47
    46
    ABC46
    $ 8.51
    12
    $ 102.12
    John
    48
    47
    ABC47
    $ 7.22
    62
    $ 447.64
    Greg
    49
    48
    ABC48
    $ 3.99
    35
    $ 139.65
    Margaret
    50
    49
    ABC49
    $ 333.45
    99
    $ 33,011.55
    Raghu
    51
    50
    ABC50
    $ 11.99
    1
    $ 11.99
    Raghu
    52
    Worksheet: OriginalData
    A Folk, A Forum, A Fuhrer ….

  6. #26
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,455
    Rep Power
    10
    Run Code Sub ExportByName() on data from last post

    Results for Updated master Worksheet

    Using Excel 2007 32 bit
    Row\Col
    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
    M
    N
    O
    25
    24
    ABC24
    $ 3.99
    35
    $ 139.65
    02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret
    26
    25
    ABC25
    $ 333.45
    99
    $ 33,011.55
    02.Apr.2018 Raghu
    27
    26
    ABC26
    $ 11.99
    1
    $ 11.99
    02.Apr.2018 John
    28
    27
    ABC27
    $ 741.99
    101
    $ 74,940.99
    02.Apr.2018 Greg
    29
    28
    ABC28
    $ 55.00
    22
    $ 1,210.00
    02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret
    30
    29
    ABC29
    $ 13.66
    7
    $ 95.62
    02.Apr.2018 Raghu
    31
    30
    ABC30
    $ 12.99
    5
    $ 64.95
    02.Apr.2018 John
    32
    31
    ABC31
    $ 8.51
    12
    $ 102.12
    02.Apr.2018 Greg
    33
    32
    ABC32
    $ 7.22
    62
    $ 447.64
    02.Apr.2018 Margaret
    34
    33
    ABC33
    $ 3.99
    35
    $ 139.65
    02.Apr.2018 Raghu
    35
    34
    ABC34
    $ 333.45
    99
    $ 33,011.55
    02.Apr.2018 John
    36
    35
    ABC35
    $ 11.99
    1
    $ 11.99
    02.Apr.2018 Greg
    37
    36
    ABC36
    $ 741.99
    101
    $ 74,940.99
    02.Apr.2018 Margaret
    38
    37
    ABC37
    $ 55.00
    22
    $ 1,210.00
    02.Apr.2018 Raghu
    39
    38
    ABC38
    $ 13.66
    7
    $ 95.62
    02.Apr.2018 John
    40
    39
    ABC39
    $ 12.99
    5
    $ 64.95
    02.Apr.2018 Greg
    41
    40
    ABC40
    $ 8.51
    12
    $ 102.12
    02.Apr.2018 Margaret
    42
    41
    ABC41
    $ 7.22
    62
    $ 447.64
    02.Apr.2018 Raghu
    43
    42
    ABC42
    $ 3.99
    35
    $ 139.65
    02.Apr.2018 John
    44
    43
    ABC43
    $ 333.45
    99
    $ 33,011.55
    02.Apr.2018 Greg
    45
    44
    ABC44
    $ 11.99
    1
    $ 11.99
    02.Apr.2018 Margaret
    46
    45
    ABC45
    $ 741.99
    101
    $ 74,940.99
    02.Apr.2018 Raghu
    47
    46
    ABC46
    $ 8.51
    12
    $ 102.12
    02.Apr.2018
    John
    48
    47
    ABC47
    $ 7.22
    62
    $ 447.64
    02.Apr.2018
    Greg
    49
    48
    ABC48
    $ 3.99
    35
    $ 139.65
    02.Apr.2018
    Margaret
    50
    49
    ABC49
    $ 333.45
    99
    $ 33,011.55
    02.Apr.2018
    Raghu
    51
    50
    ABC50
    $ 11.99
    1
    $ 11.99
    02.Apr.2018
    Raghu
    52
    53
    54
    Worksheet: OriginalData
    A Folk, A Forum, A Fuhrer ….

  7. #27
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,455
    Rep Power
    10
    Corresponding updated data worksheets for updated master after running Sub ExportByName() for the second time after new data was added

    Using Excel 2007 32 bit
    41
    ABC41
    $ 7.22
    62
    $ 447.64
    02.Apr.2018 Raghu
    45
    ABC45
    $ 741.99
    101
    $ 74,940.99
    02.Apr.2018 Raghu
    49
    ABC49 $ 333.45
    99
    $ 33,011.55 02.Apr.2018 Raghu
    50
    ABC50 $ 11.99
    1
    $ 11.99 02.Apr.2018 Raghu
    Worksheet: Tabelle1





    Using Excel 2007 32 bit
    40
    ABC40
    $ 8.51
    12
    $ 102.12
    02.Apr.2018 Margaret
    44
    ABC44
    $ 11.99
    1
    $ 11.99
    02.Apr.2018 Margaret
    48
    ABC48 $ 3.99
    35
    $ 139.65 02.Apr.2018 Margaret
    Worksheet: Tabelle1



    Using Excel 2007 32 bit
    38
    ABC38
    $ 13.66
    7
    $ 95.62
    02.Apr.2018 John
    42
    ABC42
    $ 3.99
    35
    $ 139.65
    02.Apr.2018 John
    46
    ABC46 $ 8.51
    12
    $ 102.12 02.Apr.2018 John
    Worksheet: Tabelle1



    Using Excel 2007 32 bit
    39
    ABC39
    $ 12.99
    5
    $ 64.95
    02.Apr.2018 Greg
    43
    ABC43
    $ 333.45
    99
    $ 33,011.55
    02.Apr.2018 Greg
    47
    ABC47 $ 7.22
    62
    $ 447.64 02.Apr.2018 Greg
    Worksheet: Tabelle1



    https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=UgwplzlpYpmRqjGZem14AaABAg.9hrvbYRwXvg9ht4b7z00 X0
    https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=UgyOGlCElBSbfPIzerF4AaABAg.9hrehNPPnBu9ht4us7Tt Pr
    https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=UgwHjKXf3ELkU4u4j254AaABAg.9hr503K8PDg9ht5mfLcg pR
    https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugw1-OyZiDDxCHM2Rmp4AaABAg.9hqzs_MlQu-9ht5xNvQueN
    https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugz0Uy2bCSCTb1W-0_14AaABAg
    https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugz0Uy2bCSCTb1W-0_14AaABAg.9htChVuaX9W9htG01cKBzX
    https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugw6UrV69zpeKvLOeOV4AaABAg.9ht16tzryC49htJ6TpIO XR
    https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=UgwMKwGZpDjv7vi7pCx4AaABAg
    https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugw6UrV69zpeKvLOeOV4AaABAg.9ht16tzryC49htOKs4jh 3M
    https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=UgxVW-am20rQ5GFuJ9F4AaABAg
    https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugygb0YiLOI7fG1zQSx4AaABAg
    https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugygb0YiLOI7fG1zQSx4AaABAg.9htWqRrSIfP9i-fyT84gqd
    https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugygb0YiLOI7fG1zQSx4AaABAg.9htWqRrSIfP9i-kIDl-3C9
    https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugz0Uy2bCSCTb1W-0_14AaABAg.9htChVuaX9W9i57J9GEOUB
    https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugz0Uy2bCSCTb1W-0_14AaABAg.9htChVuaX9W9i58MGeM8Lg
    https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugz0Uy2bCSCTb1W-0_14AaABAg.9htChVuaX9W9i59prk5atY
    https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=UgwaWs6XDXdQybNb8tZ4AaABAg.9i5yTldIQBn9i7NB1gjy Bk
    https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=UgxV9eNHvztLfFBGsvZ4AaABAg.9i5jEuidRs99i7NUtNNy 1v
    https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugx2zSXUtmLBSDoNWph4AaABAg.9i3IA0y4fqp9i7NySrZa md
    https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugz4oMZ09MKcExYlWf94AaABAg.9hwsCHaKX6A9i7Qs8kxE qH
    https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugz4oMZ09MKcExYlWf94AaABAg.9hwsCHaKX6A9i7TqGQYq Tz
    https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugz4oMZ09MKcExYlWf94AaABAg.9hwsCHaKX6A9iAJSNws8 Zz
    https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugz4oMZ09MKcExYlWf94AaABAg.9hwsCHaKX6A9iAJvZ6km lx
    https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugz4oMZ09MKcExYlWf94AaABAg.9hwsCHaKX6A9iAK0g1dU 7i
    https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugz4oMZ09MKcExYlWf94AaABAg.9hwsCHaKX6A9iAKCDqNm nF
    https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugz4oMZ09MKcExYlWf94AaABAg.9hwsCHaKX6A9iAKHVSTG Hy
    https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugz4oMZ09MKcExYlWf94AaABAg.9hwsCHaKX6A9iAKSBKPc J6
    https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugz4oMZ09MKcExYlWf94AaABAg.9hwsCHaKX6A9iAKgL6lr cT
    https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugz4oMZ09MKcExYlWf94AaABAg.9hwsCHaKX6A9iAKlts8h KZ
    https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugz4oMZ09MKcExYlWf94AaABAg.9hwsCHaKX6A9iAKrX7UP P0
    https://www.youtube.com/watch?v=LuAipOW8BNQ&lc=Ugz4oMZ09MKcExYlWf94AaABAg.9hwsCHaKX6A9iAL5MSjW pA
    A Folk, A Forum, A Fuhrer ….

  8. #28
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,455
    Rep Power
    10
    Data Files just before second consolidation


    15
    ABC15
    $ 3.99
    35
    $ 139.65
    02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 02.Apr.2018 Greg
    19
    ABC19
    $ 55.00
    22
    $ 1,210.00
    02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 02.Apr.2018 Greg
    23
    ABC23
    $ 7.22
    62
    $ 447.64
    02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 Greg
    27
    ABC27
    $ 741.99
    101
    $ 74,940.99
    02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 Greg
    31
    ABC31
    $ 8.51
    12
    $ 102.12
    02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 Greg
    35
    ABC35
    $ 11.99
    1
    $ 11.99
    02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 Greg
    39
    ABC39
    $ 12.99
    5
    $ 64.95
    02.Apr.2018 Greg
    Worksheet: Tabelle1



    18
    ABC18
    $ 741.99
    101
    $ 74,940.99
    02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 02.Apr.2018 John
    22
    ABC22
    $ 8.51
    12
    $ 102.12
    02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 02.Apr.2018 John
    26
    ABC26
    $ 11.99
    1
    $ 11.99
    02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 John
    30
    ABC30
    $ 12.99
    5
    $ 64.95
    02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 John
    34
    ABC34
    $ 333.45
    99
    $ 33,011.55
    02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 John
    38
    ABC38
    $ 13.66
    7
    $ 95.62
    02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 John
    42
    ABC42
    $ 3.99
    35
    $ 139.65
    02.Apr.2018 John
    Worksheet: Tabelle1






    28
    ABC28
    $ 55.00
    22
    $ 1,210.00
    02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret
    32
    ABC32
    $ 7.22
    62
    $ 447.64
    02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 Margaret
    36
    ABC36
    $ 741.99
    101
    $ 74,940.99
    02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 Margaret
    40
    ABC40
    $ 8.51
    12
    $ 102.12
    02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 Margaret
    44
    ABC44
    $ 11.99
    1
    $ 11.99
    02.Apr.2018 Margaret
    Worksheet: Tabelle1



    Using Excel 2007 32 bit
    17
    ABC17
    $ 11.99
    1
    $ 11.99
    02.Apr.2018 RT1 RT2 RT3 RT4
    02. Apr 18
    02.Apr.2018 Raghu
    21
    ABC21
    $ 12.99
    5
    $ 64.95
    02.Apr.2018 RT1 RT2 RT3 RT4
    02. Apr 18
    Raghu
    25
    ABC25
    $ 333.45
    99
    $ 33,011.55
    02.Apr.2018 RT1 RT2 RT3 RT4
    02. Apr 18
    Raghu
    29
    ABC29
    $ 13.66
    7
    $ 95.62
    02.Apr.2018 RT1 RT2 RT3 RT4
    02. Apr 18
    Raghu
    33
    ABC33
    $ 3.99
    35
    $ 139.65
    02.Apr.2018 RT1 RT2 RT3 RT4
    02. Apr 18
    Raghu
    37
    ABC37
    $ 55.00
    22
    $ 1,210.00
    02.Apr.2018 RT1 RT2 RT3 RT4
    02. Apr 18
    Raghu
    41
    ABC41
    $ 7.22
    62
    $ 447.64
    02.Apr.2018 RT1 RT2 RT3 RT4
    02. Apr 18
    Raghu
    45
    ABC45
    $ 741.99
    101
    $ 74,940.99
    02.Apr.2018 RT1 RT2 RT3 RT4
    02. Apr 18
    Raghu
    49
    ABC49 $ 333.45
    99
    $ 33,011.55 02.Apr.2018 RT1 RT2 RT3 RT4
    02. Apr 18
    Raghu
    50
    ABC50 $ 11.99
    1
    $ 11.99 02.Apr.2018 Raghu
    Worksheet: Tabelle1
    A Folk, A Forum, A Fuhrer ….

  9. #29
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,455
    Rep Power
    10
    Final results for first half of master File after second consolidation

    Using Excel 2007 32 bit
    Row\Col
    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
    M
    N
    O
    1
    S No
    Item
    Price
    Qty
    Total
    Distributed
    Task1
    Task2
    Task3
    Task4
    Completed
    Consolidated
    Comments
    Team Member
    Checked
    2
    1
    ABC01
    $ 55.00
    22
    $ 1,210.00
    02.Apr.2018 RT1 RT2 RT3 RT4 02.04.2018 02.Apr.2018 Raghu
    3
    2
    ABC02
    $ 13.66
    7
    $ 95.62
    02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 02.Apr.2018 John
    4
    3
    ABC03
    $ 12.99
    5
    $ 64.95
    02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 02.Apr.2018 Greg
    5
    4
    ABC04
    $ 8.51
    12
    $ 102.12
    02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret
    6
    5
    ABC05
    $ 7.22
    62
    $ 447.64
    02.Apr.2018 RT1 RT2 RT3 RT4 02.04.2018 02.Apr.2018 Raghu
    7
    6
    ABC06
    $ 3.99
    35
    $ 139.65
    02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 02.Apr.2018 John
    8
    7
    ABC07
    $ 333.45
    99
    $ 33,011.55
    02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 02.Apr.2018 Greg
    9
    8
    ABC08
    $ 11.99
    1
    $ 11.99
    02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret
    10
    9
    ABC09
    $ 741.99
    101
    $ 74,940.99
    02.Apr.2018 RT1 RT2 RT3 RT4 02.04.2018 02.Apr.2018 Raghu
    11
    10
    ABC10
    $ 55.00
    22
    $ 1,210.00
    02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 02.Apr.2018 John
    12
    11
    ABC11
    $ 13.66
    7
    $ 95.62
    02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 02.Apr.2018 Greg
    13
    12
    ABC12
    $ 12.99
    5
    $ 64.95
    02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret
    14
    13
    ABC13
    $ 8.51
    12
    $ 102.12
    02.Apr.2018 RT1 RT2 RT3 RT4 02.04.2018 02.Apr.2018 Raghu
    15
    14
    ABC14
    $ 7.22
    62
    $ 447.64
    02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 02.Apr.2018 John
    16
    15
    ABC15
    $ 3.99
    35
    $ 139.65
    02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 02.Apr.2018 Greg
    17
    16
    ABC16
    $ 333.45
    99
    $ 33,011.55
    02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret
    18
    17
    ABC17
    $ 11.99
    1
    $ 11.99
    02.Apr.2018 RT1 RT2 RT3 RT4 02.04.2018 02.Apr.2018 Raghu
    19
    18
    ABC18
    $ 741.99
    101
    $ 74,940.99
    02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 02.Apr.2018 John
    20
    19
    ABC19
    $ 55.00
    22
    $ 1,210.00
    02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 02.Apr.2018 Greg
    21
    20
    ABC20
    $ 13.66
    7
    $ 95.62
    02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret
    22
    21
    ABC21
    $ 12.99
    5
    $ 64.95
    02.Apr.2018 RT1 RT2 RT3 RT4 02.04.2018 02.Apr.2018 Raghu
    23
    22
    ABC22
    $ 8.51
    12
    $ 102.12
    02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 02.Apr.2018 John
    24
    23
    ABC23
    $ 7.22
    62
    $ 447.64
    02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 02.Apr.2018 Greg
    25
    24
    ABC24
    $ 3.99
    35
    $ 139.65
    02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret
    26
    25
    ABC25
    $ 333.45
    99
    $ 33,011.55
    02.Apr.2018 RT1 RT2 RT3 RT4 02.04.2018 02.Apr.2018 Raghu
    Worksheet: OriginalData
    A Folk, A Forum, A Fuhrer ….

  10. #30
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,455
    Rep Power
    10
    Second half of master worksheet after final second consolidation

    Using Excel 2007 32 bit
    Row\Col
    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
    M
    N
    O
    25
    24
    ABC24
    $ 3.99
    35
    $ 139.65
    02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret
    26
    25
    ABC25
    $ 333.45
    99
    $ 33,011.55
    02.Apr.2018 RT1 RT2 RT3 RT4 02.04.2018 02.Apr.2018 Raghu
    27
    26
    ABC26
    $ 11.99
    1
    $ 11.99
    02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 02.Apr.2018 John
    28
    27
    ABC27
    $ 741.99
    101
    $ 74,940.99
    02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 02.Apr.2018 Greg
    29
    28
    ABC28
    $ 55.00
    22
    $ 1,210.00
    02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret
    30
    29
    ABC29
    $ 13.66
    7
    $ 95.62
    02.Apr.2018 RT1 RT2 RT3 RT4 02.04.2018 02.Apr.2018 Raghu
    31
    30
    ABC30
    $ 12.99
    5
    $ 64.95
    02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 02.Apr.2018 John
    32
    31
    ABC31
    $ 8.51
    12
    $ 102.12
    02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 02.Apr.2018 Greg
    33
    32
    ABC32
    $ 7.22
    62
    $ 447.64
    02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret
    34
    33
    ABC33
    $ 3.99
    35
    $ 139.65
    02.Apr.2018 RT1 RT2 RT3 RT4 02.04.2018 02.Apr.2018 Raghu
    35
    34
    ABC34
    $ 333.45
    99
    $ 33,011.55
    02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 02.Apr.2018 John
    36
    35
    ABC35
    $ 11.99
    1
    $ 11.99
    02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 02.Apr.2018 Greg
    37
    36
    ABC36
    $ 741.99
    101
    $ 74,940.99
    02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret
    38
    37
    ABC37
    $ 55.00
    22
    $ 1,210.00
    02.Apr.2018 RT1 RT2 RT3 RT4 02.04.2018 02.Apr.2018 Raghu
    39
    38
    ABC38
    $ 13.66
    7
    $ 95.62
    02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 02.Apr.2018 John
    40
    39
    ABC39
    $ 12.99
    5
    $ 64.95
    02.Apr.2018 Greg
    41
    40
    ABC40
    $ 8.51
    12
    $ 102.12
    02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret
    42
    41
    ABC41
    $ 7.22
    62
    $ 447.64
    02.Apr.2018 RT1 RT2 RT3 RT4 02.04.2018 02.Apr.2018 Raghu
    43
    42
    ABC42
    $ 3.99
    35
    $ 139.65
    02.Apr.2018 John
    44
    43
    ABC43
    $ 333.45
    99
    $ 33,011.55
    02.Apr.2018 Greg
    45
    44
    ABC44
    $ 11.99
    1
    $ 11.99
    02.Apr.2018 Margaret
    46
    45
    ABC45
    $ 741.99
    101
    $ 74,940.99
    02.Apr.2018 RT1 RT2 RT3 RT4 02.04.2018 02.Apr.2018 Raghu
    47
    46
    ABC46
    $ 8.51
    12
    $ 102.12
    02.Apr.2018
    John
    48
    47
    ABC47
    $ 7.22
    62
    $ 447.64
    02.Apr.2018
    Greg
    49
    48
    ABC48
    $ 3.99
    35
    $ 139.65
    02.Apr.2018
    Margaret
    50
    49
    ABC49
    $ 333.45
    99
    $ 33,011.55
    02.Apr.2018
    RT1 RT2 RT3 RT4 02.04.2018 02.Apr.2018 Raghu
    51
    50
    ABC50
    $ 11.99
    1
    $ 11.99
    02.Apr.2018
    Raghu
    52
    Worksheet: OriginalData
    A Folk, A Forum, A Fuhrer ….

Similar Threads

  1. Replies: 185
    Last Post: 05-22-2024, 10:02 PM
  2. Replies: 603
    Last Post: 05-20-2024, 03:31 PM
  3. Replies: 293
    Last Post: 09-24-2020, 01:53 AM
  4. Appendix Thread. Diet Protokol Coding Adaptions
    By DocAElstein in forum Test Area
    Replies: 6
    Last Post: 09-05-2019, 10:45 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •