How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Kamil Anwar Your Own Question

Kamil Anwar
Kamil Anwar, Computer Support Specialist
Category: Computer
Satisfied Customers: 148
Experience:  8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.
69350257
Type Your Computer Question Here...
Kamil Anwar is online now

De-deuplicate two separate excel sheets (sheet 1 and sheet

Customer Question

De-deuplicate two separate excel sheets (sheet 1 and sheet 2) - they are exports from Linked In. I want to decipher who are the new contacts added (so the additional contacts in sheet 2). I want to be left with the new contacts as results
Submitted: 9 months ago.
Category: Computer
Expert:  The-PC-Guy replied 9 months ago.
could you send an example file? Also NOTE: It will likely cost more than you are offering to fix this kind of problem. But will need to see example before quoting exact price.
Customer: replied 9 months ago.
Hi. Thanks. I did not want to send example file as sensitive contact data.But for a clear example. I have an excel sheet called 'contact list year 2015' with 3000 lines/rows of data.Since then I have made another updated excel sheet called 'contact list year 2016' with 3500 lines/rows of data.I cannot see which are the new contacts I have added. I wish to be left with a list of the 500 new lines of data (and not the 3000 from the 1st list)
Customer: replied 9 months ago.
Please let me know this makes sense
Expert:  The-PC-Guy replied 9 months ago.
if possible I would need to see some sample data to create a formula from. You can use fake data, just make sure it is in the same format as the original
Customer: replied 9 months ago.
Ok how can I send this to you
Expert:  The-PC-Guy replied 9 months ago.
attach it here, should be a paperclip somewhere near the chat window
Customer: replied 9 months ago.
So the workbook has two sheets. Sheet 1/Contact List 2015 has 30 lines. Sheet 2/Contact List 2016 has 35 lines. I want to separate the new contacts from the second sheet and be left with a list of the new contacts added in 2016
Customer: replied 9 months ago.
Please confirm receipt of Sample Data when received
Customer: replied 9 months ago.
(And confirm that you fully understand my question).Thanks
Expert:  The-PC-Guy replied 9 months ago.
so what columns do you want to compare to see which is new? Columns A and B?
Customer: replied 9 months ago.
I have no strict decision on this. You can use whichever columns you need in order to filter the date.Is it possible to use A, B & E (in case there is the event that someone has the same name i.e. ***** *****) but there should not be two people with the same name and same email address.
Expert:  The-PC-Guy replied 9 months ago.
yes The way I see it is that there is a couple of different ways this can be done. Option 1, create a new column on the 2nd sheet that puts the word "NEW" next to any that are new.Option 2, create a macro that will copy the new ones to a new sheet. Either way it will cost more to do this. I just wanted to give you all of the possible options
Customer: replied 9 months ago.
Ok - Option 2 sounds better/more comprehensive but both options give same result do they??which is the quickest/ easiest and how much will it cost?
Customer: replied 9 months ago.
It needs to be something that when you send it me, I can then use it on my real data not sample data
Expert:  The-PC-Guy replied 9 months ago.
option 2 is more involved and therefore more expensive. Also it is only compatible with excel 2007 on Windows option 1 will cost $99 totaloption 2 would cost $149 total in either event it would involve you copying and pasting either a formula to all the rows, or copying code to make it work with other data.
Customer: replied 9 months ago.
How long would this take?
Expert:  The-PC-Guy replied 9 months ago.
could have something by tomarrow. I am on EST and it is late where I am.
Customer: replied 9 months ago.
Ok, it is however a lot more expensive than the site suggested initially. Even the complex option in a short time was only 35 dollars but you are asking for 99-149 dollars.
Expert:  The-PC-Guy replied 9 months ago.
what the site suggests in unrealistic. I have been doing this for over 20 years, Have a lot of experience with this sort of thing in excel. This is also how I make a living. I always find that there is also additional help needed, maybe helping you to copy and paste the formula, or to modify the macro code if necessary. Sometimes this requires remotely connecting to your computer to help you futher, or speaking on the phone. Sometimes there is additional troubleshooting if something goes wrong. This is all included in the price. Keep in mind, that once you have the code or formula, you would be able to use the same code again in the future to compare other lists that are in the same format. Only other option available to you is to manually go though and compare, but with 3000+ lines that sounds very time consuming to me.
Customer: replied 9 months ago.
I appreciate what you're saying but I do not have that much money at the moment as I am in-between jobs - I only proceeded with the service due to the prices quoted so I will need to decline your service at this time due to cost. Thank you all the same. I am logging off now as 2am but will read any messages tomorrow AM (GMT). Many thanks
Expert:  The-PC-Guy replied 9 months ago.
if you change your mind you know how to reach me

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
< Previous | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
 
 
 

Meet The Experts:

 
 
 
  • Kamil Anwar

    Kamil Anwar

    Computer Support Specialist

    Satisfied Customers:

    143
    8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.
< Last | Next >
  • http://ww2.justanswer.com/uploads/JA/JACUSTOMERf8udkdxk/2013-8-3_15150_323738101505074393259301621172992o.64x64.jpg Kamil Anwar's Avatar

    Kamil Anwar

    Computer Support Specialist

    Satisfied Customers:

    143
    8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.
  • http://ww2.justanswer.com/uploads/WI/Windowspcfix/2013-8-19_153826_ja12.64x64.jpg James K.'s Avatar

    James K.

    Consultant

    Satisfied Customers:

    93
    Technical Director of IT Company
  • http://ww2.justanswer.com/uploads/JO/JonTech/2011-10-25_111835_A2c.64x64.jpg Jon-Tech's Avatar

    Jon-Tech

    IS Manager

    Satisfied Customers:

    61
    20 yrs: Computers, Networking
  • http://ww2.justanswer.com/uploads/MI/mikew4950/2011-12-26_1606_mikephoto2s.64x64.jpg MikeW's Avatar

    MikeW

    Computer Engineer

    Satisfied Customers:

    49
    32+ years Computer and Networking Experience
  • http://ww2.justanswer.com/uploads/JA/jamieratliff/2012-2-8_194551_jamie.64x64.jpg jamieratliff's Avatar

    jamieratliff

    Information Systems Manager

    Satisfied Customers:

    21
    Jamie has worked in the Information Technology field for over a decade.
  • http://ww2.justanswer.com/uploads/JA/JACUSTOMERleg4q7o8/2012-3-6_203036_meja.64x64.png TheDoctor's Avatar

    TheDoctor

    Software Engineer

    Satisfied Customers:

    16
    Experienced Software Engineer
  • http://ww2.justanswer.com/uploads/FI/FisherEngineering/2012-1-18_194422_Fisher375Headshotcompressed239K.64x64.jpg Bill Fisher's Avatar

    Bill Fisher

    Computer Engineer

    Satisfied Customers:

    1
    Computer system design, networks, integration, general support.