Feb 05 2022 09:29 AM
I am using Microsoft 365 with the latest version of Excel. I have two columns of names of members of my church who have made contributions in years 2019, 2020, and 2021. Some of the folks did not make contributions in all three years, for various reasons.
I am seeking to compare the names in Column A who made contributions in 2019 to those who made contributions in 2020 in Column C to identified matches in names for 2019 and 2020. I have tried the Compare Columns function and the VLOOKUP function but to no avail. An example of my data is as seen below. What functions or combination of functions will achieve my goal?
Givers - 2019 | 2019 to 2020 Givers Comparison | Givers 2020 |
Susan Alexander | Ann Adams | |
Jerry & Suzanne Alford | Gregg Akin | |
Elsie Jane Anderson | Tina Allen | |
Armand & Angelina | Nick Anderson |
Can you assist me?
Feb 05 2022 10:05 AM
I think you need a full membership list covering the years in which you have an interest. A lookup will determine whether payment was received for each of the years of interest.
=COUNTIFS(Givers2019,MemberList)
This might be expected to give rise to 1 (paid) or 0 (not found). Conditional formatting could be used to pretty up the display of results.