Forum Discussion
vlookup - I think is what I need
Thank you for your help!
okay, I see what this did, pretty cool.
Let's say that the second list was comprised of all the first list, but added about three more students and addresses, etc.
Can I compare the two lists and have it automatically add those three new rows of data - without replacing the original students?
Or, say I have 10 students originally...I want to keep all this data.
the next month, I get three new students, but 4 of my original withdraw. I don't want to lose those 4 pieces of data, but I want to add the three new ones...will this work for me? so that even though I have 9 students currently enrolled, I still want to keep track of all 13 student's info.
Somebody just gave me a good idea - but I don't even know what the formula might be...
They suggested that I take the new student list, and add it to my first list - now instead of having a list of 800 students it might be 1600 - then I search for duplicates and delete them. Is there a formula or function that would delete duplicate rows?
That might be easier than creating a vlookup
figured it out...I just copy all my data making one long list, then I'm using the =if formula to see if all the data is the same, then mark it as duplicate - then I can sort everything based on that - and delete them.
Thank you for all who have looked at this and done some thinking about it.
You may want to take a look at the Excel native functionality on the Data tab:
Data > Remove Duplicates
Here's an example of the software logic used to remove duplicates and how it pertains to datasets:
Glad you were able to solve your issue!
I feel like such a dummy - thank you for pointing out the obvious...yes, yes, that would be even easier yet.
I knew there were functionalities of this program that I haven't even begun to delve into.
Thank you!!
