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 The-PC-Guy Your Own Question

The-PC-Guy
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 1848
Experience:  20 years experience providing remote computer support
62934938
Type Your Microsoft Office Question Here...
The-PC-Guy is online now
A new question is answered every 9 seconds

I want to check change in ID in cell x Save that one Next

Customer Question

I want to check for a change in ID in cell x
Save that one
Next ones under that have same ID in field x
check for dates in y
If equal delete that whole row
How do I do this?
So I will always save 1st record of new ID
Submitted: 5 months ago.
Category: Microsoft Office
Customer: replied 5 months ago.
read till new I'd
If new id save 1st one
Next ones
Same id check if date. Is 02-04-2012. Delete rowThen next I'd Save it
Check Next (Same I'd) for certain date and deleteI was wanting to do conditional formatting in excel
Customer: replied 5 months ago.
Cell x Is ID
Cell y is date
Expert:  Bhavik Joshi replied 5 months ago.

Hi Welcome to JustAnswer

Expert:  Bhavik Joshi replied 5 months ago.

Can you share that excel to me with above example and let me know what result you need at the end. ?

Customer: replied 5 months ago.
It is a document bed it belongs yo a university I cant
Customer: replied 5 months ago.
Can u send me your email address and I will send it to you and change some numbers
Customer: replied 5 months ago.
Can someone answer me
Customer: replied 5 months ago.
Please see above questions and attached file
Expert:  The-PC-Guy replied 5 months ago.

something like this can only be done with a macro. Please try to give a better explaination.

If you have 50 rows with the same ID#, you want to keep the first 1, and delete the other 49 rows?

Expert:  Bhavik Joshi replied 5 months ago.

Hi I am sorry for late reply, I was off for few day.My email id is :***@******.*** I looked into you sheet and seems like this problem can be resolved by excel's inbuilt function called "Remove Duplicate" which is present in your Data tab.

You can follow below steps to do it :-

Go to Data Tab >> select remove duplicates and then just specify the column. This feature will automatically delete rows for you.

If this solution helps, then please provide your valuable rating to me. Else feel free to post your concern, I will further work on it and resolve all your issues.

Expert:  The-PC-Guy replied 5 months ago.

something like this can only be done with a macro. Please try to give a better explaination.

If you have 50 rows with the same ID#, you want to keep the first 1, and delete the other 49 rows?