Thanks Thanks:  0
Likes Likes:  0
Page 1 of 3 123 LastLast
Results 1 to 10 of 23

Thread: Comparing two worksheets to find the match including the duplicates

  1. #1
    Board Regular
    Join Date
    Feb 2008
    Posts
    105
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Comparing two worksheets to find the match including the duplicates

    Hi,

    I have two worksheets that i'd like to compare the IDs to find the match including the duplicates. IDs in Sheet1 will be compared to a queried data with IDs in Sheet2. If it's possible if there's a code that can make this compare, create a tab labeled Matched including the duplicates, another tab labeled No match IDs from Sheet1 that didn't match to Sheet2, and lastly a tab that matched the IDs but has no duplicate IDs. Thank you!

    Here's an example of the worksheets.

    SHEET1
    IDS

    * A
    1 ID #
    2 0188370
    3 0283750
    4 0299950
    5 0316740
    6 0416500
    7 0538620
    8 0543610
    9 0554670
    10 0556410
    11 0572240
    12 0724270


    Excel tables to the web >> Excel Jeanie Html" target="_blank"> Excel Jeanie HTML 4

    SHEET2

    TOAD QUERY

    * A B C D E F G H I J K L M N O P Q
    1 ID # YR TOS BR CO TERM STATUS WAGE 1 WAGE 2 WAGE_3 TAX 1 TAX 2 YTD YTD 2 YTD 3 YTD 4 YTD 5
    2 0188370 06 00000 46 S26 A 33225.5 0 22136.5 0 0 0 0 32503.02 22136.5 0
    3 0188370 06 00000 46 A01 A 10.2 0 10.2 0 0 0 0 25332 25332 0
    4 0188370 06 00000 47 A02 A 2.5 0 2.5 0 0 0 0 23.2 23.2 0
    5 0188370 06 00000 48 A01 A 232 0 232 0 0 0 0 2211 2211 0
    6 0188370 06 00000 45 A01 A 2123 0 2123 0 0 0 0 22235 22235 0
    7 0283750 13 33333 BS J0X A 0 0 0 0 0 0 0 0 0 0
    8 0283750 13 33333 CS J0X A 0 0 0 0 0 0 0 0 0 0
    9 0299950 14 33333 72 9HQ A 37961.53 0 9500 0 256.5 0 0 37189.39 9500 0
    10 0316740 14 33333 RW MVG A 11538.42 0 9500 0 256.5 0 0 11538.42 9500 0
    11 0416500 14 33333 46 SCB A 0 0 0 0 0 0 0 0 0 0
    12 0538620 13 00000 A0 DN3 F I 0 0 0 0 0 0 0 0 0 0
    13 0538620 13 00000 A0 DN3 F I 0 0 0 0 0 0 0 0 0 0
    14 0538620 13 00000 A0 DN3 F I 0 0 0 0 0 0 0 0 0 0
    15 0543610 13 00000 70 WWD A 5949.32 0 0 0 0 0 0 0 0 0
    16 0543610 13 00000 70 WWD A 5949.32 0 0 0 0 0 0 0 0 0
    17 0554670 10 03300 ST NML6 A 0 0 0 0 0 0 0 0 0 0
    18 0556410 11 03333 72 MSV A 0 0 0 0 0 0 0 0 0 0
    19 0572240 10 33333 80 AQD I 0 0 0 0 0 * * * * *
    20 0724270 14 33333 R2 I34 A 3333.34 0 3333.34 0 90 0 0 3333.34 3333.34 0
    21 0724610 * 11 00333 15 3ML A 388389.81 0 251990.86 0 6803.75 0 0 394163.06 251990.86 0
    22 0724610 * * 14 33333 15 E2X A 17561.48 0 9500 0 256.5 0 0 17561.48 9500 0
    23 0724680 * 14 99999 15 9O2 T A 0 0 0 0 0 * * * * *
    24 APPLFOR042546583 14 03333 46 FH2 A 0 0 0 0 0 * * * * *
    25 APPLFOR043103733 09 30000 46 C4C A 15759 0 0 0 0 0 0 0 0 0


    Excel tables to the web >> Excel Jeanie Html" target="_blank"> Excel Jeanie HTML 4

  2. #2
    Board Regular
    Join Date
    Feb 2008
    Posts
    105
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Comparing two worksheets to find the match including the duplicates

    By the way, i'm using microsoft excel 2010 with Windows 7.

  3. #3
    Board Regular
    Join Date
    Apr 2009
    Location
    Northeast PA, USA
    Posts
    17,589
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    6 Thread(s)

    Default Re: Comparing two worksheets to find the match including the duplicates

    nike,

    Thanks for the Private Message.

    Sheet1 name = IDS
    Sheet2 name = TOAD QUERY

    So that we can get it right the first time, can we have screenshots of what the results should look like (manually formatted by you) in worksheets Matched, and, No Dupe IDs?
    Have a great day,
    hiker95

    Windows 10, Excel 2007, on a PC.

  4. #4
    Board Regular
    Join Date
    Feb 2008
    Posts
    105
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Comparing two worksheets to find the match including the duplicates

    Thanks for the prompt reply hiker95! Here's the screenshots i've manually compared.


    MATCHED WITH DUPS

     ABCDEFGHIJKLMNOPQR
    1SHEET1 ID#ID #YRTOSBRCOTERMSTATUSWAGE 1WAGE 2WAGE_3TAX 1TAX 2YTDYTD 2YTD 3YTD 4YTD 5
    21883701883706046S26 A33225.5022136.5000032503.0222136.50
    31883701883706046A01 A10.2010.2000025332253320
    41883701883706047A02 A2.502.5000023.223.20
    51883701883706048A01 A23202320000221122110
    61883701883706045A01 A212302123000022235222350
    72837502837501333333BSJ0X A0000000000
    82837502837501333333CSJ0X A0000000000
    92999502999501433333729HQ A37961.53095000256.50037189.3995000
    103167403167401433333RWMVG A11538.42095000256.50011538.4295000
    11416500416500143333346SCB A0000000000
    12538620538620130A0DN3FI0000000000
    13538620538620130A0DN3FI0000000000
    14538620538620130A0DN3FI0000000000
    1554361054361013070WWD A5949.32000000000
    1654361054361013070WWD A5949.32000000000
    17554670554670103300STNML6 A0000000000
    1855641055641011333372MSV A0000000000
    19572240572240103333380AQD I00000*****
    207242707242701433333R2I34 A3333.3403333.34090003333.343333.340


    Excel tables to the web >> Excel Jeanie Html" target="_blank"> Excel Jeanie HTML 4

    MATCHED NO DUPS

     ABCDEFGHIJKLMNOPQR
    1SHEET1 ID#ID #YRTOSBRCOTERMSTATUSWAGE 1WAGE 2WAGE_3TAX 1TAX 2YTDYTD 2YTD 3YTD 4YTD 5
    21883701883706046S26 A33225.5022136.5000032503.0222136.50
    32837502837501333333BSJ0X A0000000000
    42999502999501433333729HQ A37961.53095000256.50037189.3995000
    53167403167401433333RWMVG A11538.42095000256.50011538.4295000
    6416500416500143333346SCB A0000000000
    7538620538620130A0DN3FI0000000000
    854361054361013070WWD A5949.32000000000
    9554670554670103300STNML6 A0000000000
    1055641055641011333372MSV A0000000000
    11572240572240103333380AQD I00000*****
    127242707242701433333R2I34 A3333.3403333.34090003333.343333.340


    Excel tables to the web >> Excel Jeanie Html" target="_blank"> Excel Jeanie HTML 4

    NO MATCH

     ABCDEFGHIJKLMNOPQR
    1SHEET1 ID#ID #YRTOSBRCOTERMSTATUSWAGE 1WAGE 2WAGE_3TAX 1TAX 2YTDYTD 2YTD 3YTD 4YTD 5
    2 0724610 *11333153ML A388389.80251990.906803.7500394163.1251990.90
    3 0724610 * *143333315E2X A17561.48095000256.50017561.4895000
    4 0724680 *1499999159O2TA00000*****
    5 APPLFOR04254658314333346FH2 A00000*****
    6 APPLFOR04310373393000046C4C A15759000000000


    Excel tables to the web >> Excel Jeanie Html" target="_blank"> Excel Jeanie HTML 4

  5. #5
    Board Regular
    Join Date
    Feb 2008
    Posts
    105
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Comparing two worksheets to find the match including the duplicates

    Here's a better screenshot...


    MATCHED WITH DUPS

    * A B C D E F G H I J K L M N O P Q R
    1 SHEET1 ID# ID # YR TOS BR CO TERM STATUS WAGE 1 WAGE 2 WAGE_3 TAX 1 TAX 2 YTD YTD 2 YTD 3 YTD 4 YTD 5
    2 188370 188370 6 0 46 S26 * A 33225.5 0 22136.5 0 0 0 0 32503.02 22136.5 0
    3 188370 188370 6 0 46 A01 * A 10.2 0 10.2 0 0 0 0 25332 25332 0
    4 188370 188370 6 0 47 A02 * A 2.5 0 2.5 0 0 0 0 23.2 23.2 0
    5 188370 188370 6 0 48 A01 * A 232 0 232 0 0 0 0 2211 2211 0
    6 188370 188370 6 0 45 A01 * A 2123 0 2123 0 0 0 0 22235 22235 0
    7 283750 283750 13 33333 BS J0X * A 0 0 0 0 0 0 0 0 0 0
    8 283750 283750 13 33333 CS J0X * A 0 0 0 0 0 0 0 0 0 0
    9 299950 299950 14 33333 72 9HQ * A 37961.53 0 9500 0 256.5 0 0 37189.39 9500 0
    10 316740 316740 14 33333 RW MVG * A 11538.42 0 9500 0 256.5 0 0 11538.42 9500 0
    11 416500 416500 14 33333 46 SCB * A 0 0 0 0 0 0 0 0 0 0
    12 538620 538620 13 0 A0 DN3 F I 0 0 0 0 0 0 0 0 0 0
    13 538620 538620 13 0 A0 DN3 F I 0 0 0 0 0 0 0 0 0 0
    14 538620 538620 13 0 A0 DN3 F I 0 0 0 0 0 0 0 0 0 0
    15 543610 543610 13 0 70 WWD * A 5949.32 0 0 0 0 0 0 0 0 0
    16 543610 543610 13 0 70 WWD * A 5949.32 0 0 0 0 0 0 0 0 0
    17 554670 554670 10 3300 ST NML6 * A 0 0 0 0 0 0 0 0 0 0
    18 556410 556410 11 3333 72 MSV * A 0 0 0 0 0 0 0 0 0 0
    19 572240 572240 10 33333 80 AQD * I 0 0 0 0 0 * * * * *
    20 724270 724270 14 33333 R2 I34 * A 3333.34 0 3333.34 0 90 0 0 3333.34 3333.34 0


    Excel tables to the web >> Excel Jeanie Html" target="_blank"> Excel Jeanie HTML 4

    MATCHED NO DUPS

    * A B C D E F G H I J K L M N O P Q R
    1 SHEET1 ID# ID # YR TOS BR CO TERM STATUS WAGE 1 WAGE 2 WAGE_3 TAX 1 TAX 2 YTD YTD 2 YTD 3 YTD 4 YTD 5
    2 188370 188370 6 0 46 S26 * A 33225.5 0 22136.5 0 0 0 0 32503.02 22136.5 0
    3 283750 283750 13 33333 BS J0X * A 0 0 0 0 0 0 0 0 0 0
    4 299950 299950 14 33333 72 9HQ * A 37961.53 0 9500 0 256.5 0 0 37189.39 9500 0
    5 316740 316740 14 33333 RW MVG * A 11538.42 0 9500 0 256.5 0 0 11538.42 9500 0
    6 416500 416500 14 33333 46 SCB * A 0 0 0 0 0 0 0 0 0 0
    7 538620 538620 13 0 A0 DN3 F I 0 0 0 0 0 0 0 0 0 0
    8 543610 543610 13 0 70 WWD * A 5949.32 0 0 0 0 0 0 0 0 0
    9 554670 554670 10 3300 ST NML6 * A 0 0 0 0 0 0 0 0 0 0
    10 556410 556410 11 3333 72 MSV * A 0 0 0 0 0 0 0 0 0 0
    11 572240 572240 10 33333 80 AQD * I 0 0 0 0 0 * * * * *
    12 724270 724270 14 33333 R2 I34 * A 3333.34 0 3333.34 0 90 0 0 3333.34 3333.34 0


    Excel tables to the web >> Excel Jeanie Html" target="_blank"> Excel Jeanie HTML 4

    NO MATCH

    * A B C D E F G H I J K L M N O P Q R
    1 SHEET1 ID# ID # YR TOS BR CO TERM STATUS WAGE 1 WAGE 2 WAGE_3 TAX 1 TAX 2 YTD YTD 2 YTD 3 YTD 4 YTD 5
    2 * 0724610 * 11 333 15 3ML * A 388389.8 0 251990.9 0 6803.75 0 0 394163.1 251990.9 0
    3 * 0724610 * * 14 33333 15 E2X * A 17561.48 0 9500 0 256.5 0 0 17561.48 9500 0
    4 * 0724680 * 14 99999 15 9O2 T A 0 0 0 0 0 * * * * *
    5 * APPLFOR042546583 14 3333 46 FH2 * A 0 0 0 0 0 * * * * *
    6 * APPLFOR043103733 9 30000 46 C4C * A 15759 0 0 0 0 0 0 0 0 0


    Excel tables to the web >> Excel Jeanie Html" target="_blank"> Excel Jeanie HTML 4

  6. #6
    MrExcel MVP
    Join Date
    May 2011
    Posts
    3,699
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Comparing two worksheets to find the match including the duplicates

    Maybe this (with formulas):

    Layout

    ID # YR TOS BR CO TERM STATUS WAGE 1 WAGE 2 WAGE_3 TAX 1 TAX 2 YTD YTD 2 YTD 3 YTD 4 YTD 5 ID # ID # YR ID # YR ID # YR
    188370 6 0 46 S26 A 33225,5 0 22136,5 0 0 0 0 32503,02 22136,5 0 188370 188370 6 188370 6 0724610 * 11
    188370 6 0 46 A01 A 10,2 0 10,2 0 0 0 0 25332 25332 0 283750 188370 6 283750 13 0724610 * * 14
    188370 6 0 47 A02 A 2,5 0 2,5 0 0 0 0 23,2 23,2 0 299950 188370 6 299950 14 0724680 * 14
    188370 6 0 48 A01 A 232 0 232 0 0 0 0 2211 2211 0 316740 188370 6 316740 14 APPLFOR042546583 14
    188370 6 0 45 A01 A 2123 0 2123 0 0 0 0 22235 22235 0 416500 188370 6 416500 14 APPLFOR043103733 9
    283750 13 33333 BS J0X A 0 0 0 0 0 0 0 0 0 0 538620 283750 13 538620 13
    283750 13 33333 CS J0X A 0 0 0 0 0 0 0 0 0 0 543610 283750 13 543610 13
    299950 14 33333 72 9HQ A 37961,53 0 9500 0 256,5 0 0 37189,39 9500 0 554670 299950 14 554670 10
    316740 14 33333 RW MVG A 11538,42 0 9500 0 256,5 0 0 11538,42 9500 0 556410 316740 14 556410 11
    416500 14 33333 46 SCB A 0 0 0 0 0 0 0 0 0 0 572240 416500 14 572240 10
    538620 13 0 A0 DN3 F I 0 0 0 0 0 0 0 0 0 0 724270 538620 13 724270 14
    538620 13 0 A0 DN3 F I 0 0 0 0 0 0 0 0 0 0 538620 13
    538620 13 0 A0 DN3 F I 0 0 0 0 0 0 0 0 0 0 538620 13
    543610 13 0 70 WWD A 5949,32 0 0 0 0 0 0 0 0 0 543610 13
    543610 13 0 70 WWD A 5949,32 0 0 0 0 0 0 0 0 0 543610 13
    554670 10 3300 ST NML6 A 0 0 0 0 0 0 0 0 0 0 554670 10
    556410 11 3333 72 MSV A 0 0 0 0 0 0 0 0 0 0 556410 11
    572240 10 33333 80 AQD I 0 0 0 0 0 * * * * * 572240 10
    724270 14 33333 R2 I34 A 3333,34 0 3333,34 0 90 0 0 3333,34 3333,34 0 724270 14
    0724610 * 11 333 15 3ML A 388389,81 0 251990,86 0 6803,75 0 0 394163,06 251990,86 0
    0724610 * * 14 33333 15 E2X A 17561,48 0 9500 0 256,5 0 0 17561,48 9500 0
    0724680 * 14 99999 15 9O2 T A 0 0 0 0 0 * * * * *
    APPLFOR042546583 14 3333 46 FH2 A 0 0 0 0 0 * * * * *
    APPLFOR043103733 9 30000 46 C4C A 15759 0 0 0 0 0 0 0 0 0
    ******************** *** ******* **** ****** ****** ******** *********** ******** *********** ****** ********* ***** ****** *********** *********** ****** ** ******** ** ******** *** ** ******** *** ** ******************** ***

    Formulas

    Code:
    In U2 - use Ctrl+Shift+Enter to enter the formula
     
    =IFERROR(INDEX(A$2:A$25,SMALL(IF(COUNTIF($S$2:$S$12,$A$2:$A$25),ROW($A$2:$A$25)-ROW($A$2)+1),ROWS(U$2:U2))),"")
    
    In X2 - use Ctrl+Shift+Enter to enter the formula
    
    =IFERROR(INDEX(A$2:A$25,MATCH(0,COUNTIF($X$1:$X1,$A$2:$A$25)+(COUNTIF($S$2:$S$12,$A$2:$A$25)=0),0)),"")
    
    In AA2 - use Ctrl+Shift+Enter to enter the formula
    
    =IFERROR(INDEX(A$2:A$25,SMALL(IF(COUNTIF($S$2:$S$12,$A$2:$A$25)=0,ROW($A$2:$A$25)-ROW($A$2)+1),ROWS(AA$2:AA2))),"")
    Note: all data in only one sheet - modify the formulas to your need.

    Markmzz

  7. #7
    Board Regular
    Join Date
    Apr 2009
    Location
    Northeast PA, USA
    Posts
    17,589
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    6 Thread(s)

    Default Re: Comparing two worksheets to find the match including the duplicates

    nike,

    Some of your screenshots are coming thru with ID numbers, like:
    0188370, and, this 188370?????


    Can you post your workbook with the five worksheets?

    You can upload your workbook to Box Net,
    sensitive data changed
    mark the workbook for sharing
    and provide us with a link to your workbook.
    Have a great day,
    hiker95

    Windows 10, Excel 2007, on a PC.

  8. #8
    Board Regular
    Join Date
    Feb 2008
    Posts
    105
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Comparing two worksheets to find the match including the duplicates

    Hi,

    Here's the link to my workbook.

    https://app.box.com/s/9skel6orm9x16o3fc783

  9. #9
    Board Regular
    Join Date
    Apr 2009
    Location
    Northeast PA, USA
    Posts
    17,589
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    6 Thread(s)

    Default Re: Comparing two worksheets to find the match including the duplicates

    nike,

    The following two worksheet names contain a trailing space character:
    MATCHED NO DUP
    NO MATCH

    1. Will the workbook always have these two worksheet names with a single trailing space character?


    And, your attached workbook cells are protected, which is causing a problem.

    2. Can I have another workbook with the protection removed?
    Have a great day,
    hiker95

    Windows 10, Excel 2007, on a PC.

  10. #10
    Board Regular
    Join Date
    Apr 2009
    Location
    Northeast PA, USA
    Posts
    17,589
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    6 Thread(s)

    Default Re: Comparing two worksheets to find the match including the duplicates

    nike,

    I was not able to use your attached workbook.

    Make sure you read my reply #9.


    So, I took your screenshots, and, was able to create the code to do the following:


    Sample worksheets before the macro:

    IDS

     A
    1ID #
    2188370
    3283750
    4299950
    5316740
    6416500
    7538620
    8543610
    9554670
    10556410
    11572240
    12724270
    13123456
    14254689
    15212542
    16254686
    17 


    Excel tables to the web >> Excel Jeanie HTML 4

    TOAD QUERY

     ABCDEFGHIJKLMNOPQ
    1ID #YRTOSBRCOTERMSTATUSWAGE 1WAGE 2WAGE_3TAX 1TAX 2YTDYTD 2YTD 3YTD 4YTD 5
    21883706046S26 A33225.5022136.5000032503.0222136.50
    31883706046A01 A10.2010.2000025332253320
    41883706047A02 A2.502.5000023.223.20
    51883706048A01 A23202320000221122110
    61883706045A01 A212302123000022235222350
    72837501333333BSJ0X A0000000000
    82837501333333CSJ0X A0000000000
    92999501433333729HQ A37961.53095000256.50037189.3995000
    103167401433333RWMVG A11538.42095000256.50011538.4295000
    11416500143333346SCB A0000000000
    12538620130A0DN3FI0000000000
    13538620130A0DN3FI0000000000
    14538620130A0DN3FI0000000000
    1554361013070WWD A5949.32000000000
    1654361013070WWD A5949.32000000000
    17554670103300STNML6 A0000000000
    1855641011333372MSV A0000000000
    19572240103333380AQD I00000*****
    207242701433333R2I34 A3333.3403333.34090003333.343333.340
    210724610 *11333153ML A388389.810251990.8606803.7500394163.06251990.860
    220724610 * *143333315E2X A17561.48095000256.50017561.4895000
    230724680 *1499999159O2TA00000*****
    24APPLFOR04254658314333346FH2 A00000*****
    25APPLFOR04310373393000046C4C A15759000000000
    26                 


    Excel tables to the web >> Excel Jeanie HTML 4

    MATCHED WITH DUPS

     ABCDEFGHIJKLMNOPQR
    1SHEET1 ID#ID #YRTOSBRCOTERMSTATUSWAGE 1WAGE 2WAGE_3TAX 1TAX 2YTDYTD 2YTD 3YTD 4YTD 5
    2                  
    3                  
    4                  
    5                  
    6                  
    7                  
    8                  
    9                  
    10                  
    11                  
    12                  
    13                  
    14                  


    Excel tables to the web >> Excel Jeanie HTML 4

    MATCHED NO DUPS

     ABCDEFGHIJKLMNOPQR
    1SHEET1 ID#ID #YRTOSBRCOTERMSTATUSWAGE 1WAGE 2WAGE_3TAX 1TAX 2YTDYTD 2YTD 3YTD 4YTD 5
    2                  
    3                  
    4                  
    5                  
    6                  
    7                  
    8                  
    9                  


    Excel tables to the web >> Excel Jeanie HTML 4

    NO MATCH

     ABCDEFGHIJKLMNOPQR
    1SHEET1 ID#ID #YRTOSBRCOTERMSTATUSWAGE 1WAGE 2WAGE_3TAX 1TAX 2YTDYTD 2YTD 3YTD 4YTD 5
    2                  
    3                  
    4                  
    5                  
    6                  


    Excel tables to the web >> Excel Jeanie HTML 4


    And, after the macro:

    MATCHED WITH DUPS

     ABCDEFGHIJKLMNOPQR
    1SHEET1 ID#ID #YRTOSBRCOTERMSTATUSWAGE 1WAGE 2WAGE_3TAX 1TAX 2YTDYTD 2YTD 3YTD 4YTD 5
    21883701883706046S26 A33225.5022136.5000032503.0222136.50
    31883701883706046A01 A10.2010.2000025332253320
    41883701883706047A02 A2.502.5000023.223.20
    51883701883706048A01 A23202320000221122110
    61883701883706045A01 A212302123000022235222350
    72837502837501333333BSJ0X A0000000000
    82837502837501333333CSJ0X A0000000000
    9538620538620130A0DN3FI0000000000
    10538620538620130A0DN3FI0000000000
    11538620538620130A0DN3FI0000000000
    1254361054361013070WWD A5949.32000000000
    1354361054361013070WWD A5949.32000000000
    14                  


    Excel tables to the web >> Excel Jeanie HTML 4

    MATCHED NO DUPS

     ABCDEFGHIJKLMNOPQR
    1SHEET1 ID#ID #YRTOSBRCOTERMSTATUSWAGE 1WAGE 2WAGE_3TAX 1TAX 2YTDYTD 2YTD 3YTD 4YTD 5
    22999502999501433333729HQ A37961.53095000256.50037189.3995000
    33167403167401433333RWMVG A11538.42095000256.50011538.4295000
    4416500416500143333346SCB A0000000000
    5554670554670103300STNML6 A0000000000
    655641055641011333372MSV A0000000000
    7572240572240103333380AQD I00000*****
    87242707242701433333R2I34 A3333.3403333.34090003333.343333.340
    9                  


    Excel tables to the web >> Excel Jeanie HTML 4

    NO MATCH

     ABCDEFGHIJKLMNOPQR
    1SHEET1 ID#ID #YRTOSBRCOTERMSTATUSWAGE 1WAGE 2WAGE_3TAX 1TAX 2YTDYTD 2YTD 3YTD 4YTD 5
    2123456                 
    3254689                 
    4212542                 
    5254686                 
    6                  


    Excel tables to the web >> Excel Jeanie HTML 4
    Have a great day,
    hiker95

    Windows 10, Excel 2007, on a PC.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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