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 ?
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 ?
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!
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.
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
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
i cant understrand clearly, pls say simple method and work and send sample file
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)
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
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.
i tried but nothing will happening here
It would be great if you can upload sample data with expected result.
sheet 3 is output data
Give this try in Sheet 3
A2Formula:Please Login or Register to view this content.
Copy across
good working fine but i need this output in sheet 1... and highlight this output by color.. how ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks