• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Such a simple question - but I'm trying

lili429

New Member
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.
 
Back
Top