I have a list of last year's homeowners and the last names of the homeowners that have paid dues this year.
I want to figure out who has paid this year and who hasn't and be able to create a list for our board of those that need to pay.
How do I do that in excel?
Hi Lili429,
Welcome to Chandoo.org forums and thanks for your question. Please take a minute to explore our site and learn more. I also encourage you to join our newsletter so that you can continue to learn.
Regarding your question, I suggest checking out these pages:
http://chandoo.org/wp/2012/02/06/comparing-2-lists-with-a-twist/
and http://chandoo.org/wp/2010/06/17/compare-2-lists-in-excel/ and using the ideas there to solve your problem.
You must log in to post.
Thank you so much for visiting us & taking first step to become awesome in Excel. Please use below links to navigate our site.
Subscribe
