+ Reply to Thread
Results 1 to 10 of 10

Difference is 66 records how to find it ? The balance 66 records ?

  1. #1
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    239

    Difference is 66 records how to find it ? The balance 66 records ?

    I have 2excel sheets in 1st sheet is consolidation and second sheet is full data I have consolidate 1st sheet from 2nd sheet datas. But here 66 records has been missing. How to I findout the missing records ?
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Difference is 66 records how to find it ? The balance 66 records ?

    What is the link between the 2 sheets? What is the consolidation based on?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Difference is 66 records how to find it ? The balance 66 records ?

    What is the formula you are using to get the column details? You have just copied the numbers into the sample file.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  4. #4
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    239

    Re: Difference is 66 records how to find it ? The balance 66 records ?

    Link is 1st sheet heading is federation and second sheet heading is branch id

  5. #5
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    239

    Re: Difference is 66 records how to find it ? The balance 66 records ?

    No, I am using filter option in 2nd sheet and select 1 branch id and find that how much sanitation and household water connection and waterfilter and write that number in 1st sheet that selected federation row

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Difference is 66 records how to find it ? The balance 66 records ?

    Your data is very messy, and items that appear to match, dont match because of extra/missing spaces and words.

    For instance,
    on 1597 141-Cuddalore rural
    no spaces before and after -
    on 1531 141 - Cuddalore Rural
    spaces around - and also 2 trailing spaces

    on 1597 052-Mandavya kalanjia okkuta
    no spaces before and after -
    on 1531
    052 - Mandavya Mahila Kalanjia okkuta
    spaces around - and also 2 trailing spaces plus extra words

    You will need to clean this up before you can do any testing

  7. #7
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    239

    Re: Difference is 66 records how to find it ? The balance 66 records ?

    ok i noted. After cleaning up this how can i find it ? tell me the step procedure pls

  8. #8
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Difference is 66 records how to find it ? The balance 66 records ?

    Cant say until you have clean data to work with. Probably something like MATCH or countif

    THose were just 2 items I picked at random to test, I did not go through all the data, so you probably have lots more

  9. #9
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    239

    Re: Difference is 66 records how to find it ? The balance 66 records ?

    ok i cleanup all and comeback to you

  10. #10
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Difference is 66 records how to find it ? The balance 66 records ?

    In theory, once the data is cleaned up, this in D3 copied across and down:

    =COUNTIFS('1597 records'!$G$2:$G$1598,'1531 records'!$C3,'1597 records'!$H$2:$H$1598,'1531 records'!D$2)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How can I find "matching" records and display data from those records
    By tbrookes3 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-28-2017, 11:18 AM
  2. Find the initial parent record based on the records in the last child records
    By Journeyman3000 in forum Access Tables & Databases
    Replies: 0
    Last Post: 03-30-2017, 08:46 PM
  3. Partially balance SUMIF records
    By murrey86 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-01-2015, 09:31 PM
  4. Pulling records matching two criteria and inserting those records into an existing list
    By desertfx41 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-14-2014, 02:00 PM
  5. Replies: 2
    Last Post: 12-20-2013, 01:09 PM
  6. [SOLVED] need to be able to update records with button click and delete records sample included
    By unreal11 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-25-2013, 11:45 PM
  7. Find the smallest difference between all records in a field
    By kgirl91 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-17-2013, 02:14 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1