+ Reply to Thread
Results 1 to 13 of 13

Locate New Record rows

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

    Locate New Record rows

    I have 2 sheets
    Sheet 1 is old record
    Sheet 2 is new record

    Now i am copy sheet 2 data & paste it in top in sheet 1 and remove duplicates,
    here i want to find out here newly inserted rows how ?
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    21,379

    Re: Locate New Record rows

    The sample data is inadequate - it does not clearly show what you are describing and there are no duplicates. Why not simply add the new record to the bottom of the original sheets?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    45,696

    Re: Locate New Record rows

    If you copy/paste the new data OVER the old data,. and then remove any duplicates, you have just removed any means of finding any extra data.
    I suggest that you add a helper column, leave the old data there and give that "set" a unique ID/code, then add the new data underneath, a;so with it's own unique ID - that way, you can then compare what you had, to the new stuff
    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

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.

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

    Re: Locate New Record rows

    i want to add it in top only, duplicate is borrower id si.no 1 and 2 are both duplicate values, here unique is borrower id that is sl.no.3 only so if i merge the sheet1 and sheet2 means there is newly data is borrower id si.no 3 only so i want to findout that all rows. i have 3 lakhs rows

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

    Re: Locate New Record rows

    i cant understrand clearly, pls say simple method and work and send sample file

  6. #6
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    2016
    Posts
    3,650

    Re: Locate New Record rows

    Copy the data Sheet 2, select the A2:F4 and copy it and then paste the same into sheet2 A4 cell. Now select the whole data in sheet 1 and press Alt->A-> you will see a window remove duplicate-> Unselect all then check mark only on borrower id and then ok. You will see only the unique values.

    Hope this would help you
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

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

    Re: Locate New Record rows

    you are right but i want to highlight only newly inserted rows that it has on sheet2 A3 row only. how to hightlight specific that row only not all unique values

  8. #8
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    2016
    Posts
    3,650

    Re: Locate New Record rows

    Do copy and paste the data from Sheet 2 to Sheet 1 then select whole data in sheet 1. Now press Alt->O->D you will get a window conditional formatting -> click on new rule-> Choose last option select a rule type -> Give this formula =COUNTIF($B:$B,$B2)=1 and choose format as you want.

    Check the attached file.
    Attached Files Attached Files

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

    Re: Locate New Record rows

    i tried but nothing will happening here

  10. #10
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    2016
    Posts
    3,650

    Re: Locate New Record rows

    It would be great if you can upload sample data with expected result.

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

    Re: Locate New Record rows

    sheet 3 is output data
    Attached Files Attached Files

  12. #12
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    2016
    Posts
    3,650

    Re: Locate New Record rows

    Give this try in Sheet 3

    A2
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Copy across

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

    Re: Locate New Record rows

    good working fine but i need this output in sheet 1... and highlight this output by color.. how ?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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