hi all,
we use typeform to collect member applications. Each application has approx 65+ fields of data. We delete declined applications from this service and then export the file to csv, which we upload into mailchimp.
Unfortunately, typeform accidentally restored approx 1200 records which we had previously deleted and now they are mixed up which is a big problem for us. Some of these records are ones that we need to delete and others are applications that came in later that day. So I need a way to separate the difference between them, so that we can work through them and see what's what.
I have an exported csv file prior to the error occurring (6.5K records) and another after the error (7.8K).
I'm wondering if there is something that I can do in excel to extract the different cells into a third sheet?
Also, I think we had some duplicates in our approved member csv. Is there a quick way to remove duplicates?
Thank you in advance for any advice given.
Bookmarks