Posts by CFABS

  • Compare two different excel files and return common ones

    Re: Compare two different excel files and return common ones


    Hello, I can be emailed direct at REMOVED TO PROTECT FROM SPAM

    You need to load the lists you are comparing into top and bottom grid, click match to link the spreadsheets
    Then View Matched to review matching records
    Or View Unmatched for list of un matched records
    Use the dropdown filter to perform a simultaneous filter on both spreadsheets
    I would be happy to lead you through process if you have any difficulties, and show you advanced features for flagging this up using the pivot table tool

  • Highlight Rows with duplicated number in diff. workbook

    Re: Highlight Rows with duplicated number in diff. workbook


    Hello

    There are a couple of ways I would approach this. You can use vlookup formula to see if any column numbers match between the sheet (supposing a match means that there is a duplicate) or say if you have a list of sorted numbers in one column and add an additional column you can use an if statement to check whether the number in the cell above is the same, and if it is indicate that it is a duplicate.
    If you would like to attach sample sheets I can see if I can help.
    Regards
    Chris

  • Merge X worksheets using a common column header

    Re: Merge X worksheets using a common column header


    Hello

    I am interested in the issue,

    E.g, are you trying to basically find a quick way to copy paste the two spreadsheets together, as the columns often have the same headers in the spreadsheets, but sometimes one spreadsheet has more column heads than the other, and you need to align the merge?
    Regards
    Chris

  • Generate a list of unique values

    Re: Generate a list of unique values


    Hello

    Is this a simple case of removing the duplicates?
    Copy paste both your lists together and sort by name

    List A and B sorted (header row in A1)DinosaurDinosaurDinosaurDinosaurMonkeyMonkeyPiratePirateTurnipTurnipWallabyWallaby


    In cell B2 write the following if statement and drag the formula down

    =IF(A2=A1,"DUPLICATE")

    To get the following results

    List A and B sortedDinosaurFALSEDinosaurDUPLICATEDinosaurDUPLICATEDinosaurDUPLICATEMonkeyFALSEMonkeyDUPLICATEPirateFALSEPirateDUPLICATETurnipFALSETurnipDUPLICATEWallabyFALSEWallabyDUPLICATE

    Select alll data in your spreadsheet and do an autofilter on the word Duplicate (data/filter/autofilter), delete the duplicate rows

    Hope this helps.

    Also if you are looking for a solution that can sum data across unique values try this, CFABS Agent Splitter - 1.01
    http://www.versiontracker.com/dyn/moreinfo/win/75157580

    This would be for the scenario where you want to generate a grid, that just takes the unique names in your column, e.g. monkey and only inserts the data that relates to monkey into the monkey column, and only inserts data that relates to dinasour in the dinosaur column, etc.,


    I use a formula

  • Sum if with 2 criteria

    Re: Sum if with 2 criteria


    Have a look at attachment, see worksheet Purchase Stock Matrix which sums data that meets 2 criteria in Stock Purchases Worksheet


    =SUMIF('Stock Purchases'!$D:$D,$C4 & D$2,'Stock Purchases'!$E:$E)

    $C4 refers to row, e.g. row name is size 1
    D$2 refers to column header, e.g. column header is colour 1 (red)

    The formula looks at the worksheet stock purchases for quantity of red t-shirts sold in size 1

    and inserts the sum into the grid

    Hope this helps

  • USD $200.00 To help me finish off my parts Database- xls accdb xml API

    Re: $200 To help me finish off my parts Database- xls accdb xml API


    Hello

    I reckon the best book that will help you is Step by Step Web Database Development by Jim Bunyens, the one that comes with a cd rom included ISBN 0-7356-0966-7

    The code samples on the cd rom help a novice to link access databases into web pages, maybe this will help.

    Regards

    Chris

  • Copy Non-Matching Data Between 2 Sheets To Another

    Re: Copy Non-Matching Data Between 2 Sheets To Another



    [INDENT]Hello


    This is a tool I had developed for comparing two spreadhsheets. The pivot table function could be really useful to you for generating a report of the data that does not match between the spreadsheets.


    CFABS Reconciliation Tool 1.05
    http://www.versiontracker.com/dyn/moreinfo/win/75147199


    Although it was made for the purpose of commission reconciliation, practically any kind of comparison between two spreadsheet can be done.


    Load your master spreadsheet into the top grid
    Load spreadsheet you want to compare to the master in the bottom grid


    Select the columns you wish to compare between the spreadsheets using the drop down menu and click match, the software will look for matching records between the two spreadsheets, and you can look at matched or unmatched records between the two spreadsheets, you can use dropdown menu to simultaneously filter on individual records that match between the spreadshseets.


    There is a pivot table builder function e.g. if you are checking order numbers between two spreadsheets to see if th order number have been paid at the same amounts.


    You can edit the spreadsheets in either grid, changes will not be saved to the originals until you opt to save the changes in the software.


    Any questions please drop me a line. Hope this helps


    Regards


    Chris[/INDENT]

  • Compare Two Spreadsheets & Output Report

    Re: Compare Two Spreadsheets


    Hello
    This is a tool I had developed for comparing two spreadhsheets
    CFABS Reconciliation Tool 1.05
    http://www.versiontracker.com/dyn/moreinfo/win/75147199
    Although it was made for the purpose of commission reconciliation, practically any kind of comparison between two spreadsheets can be done.

    Load your master spreadsheet into the top grid
    Load spreadsheet you want to compare to the master in the bottom grid

    Select the columns you wish to compare between the spreadsheets using the drop down menu and click match, the software will look for matching records between the two spreadsheets, and you can look at matched or unmatched records between the two spreadsheets, you can use dropdown menu to simultaneously filter on individual records that match between the spreadshseets.

    There is a pivot table builder function for generating reports e.g. if you are checking order numbers between two spreadsheets to see if th order number have been paid at the same amounts.

    You can edit the spreadsheets in either grid, changes will not be saved to the originals until you opt to save the changes in the software.

    Any questions please drop me a line. Hope this helps

    Regards

    Chris

  • Compare two different excel files and return common ones

    Re: Compare two different excel files and return common ones


    Hello

    This is a tool I had developed for comparing two spreadhsheets

    CFABS Reconciliation Tool 1.05
    http://www.versiontracker.com/dyn/moreinfo/win/75147199

    Although it was made for the purpose of commission reconciliation, practically any kind of comparison between two spreadsheet can be done.

    Load your master spreadsheet into the top grid
    Load spreadsheet you want to compare to the master in the bottom grid

    Select the columns you wish to compare between the spreadsheets using the drop down menu and click match, the software will look for matching records between the two spreadsheets, and you can look at matched or unmatched records between the two spreadsheets, you can use dropdown menu to simultaneously filter on individual records that match between the spreadshseets.

    There is a pivot table builder function e.g. if you are checking order numbers between two spreadsheets to see if th order number have been paid at the same amounts.

    You can edit the spreadsheets in either grid, changes will not be saved to the originals until you opt to save the changes in the software.

    Any questions please drop me a line. Hope this helps

    Regards

    Chris