Comparing Data in two Sheets
I have a large list of 926 individuals who are identified by IDs in one sheet. some of these individuals are no longer active. I am trying to find a simple solution to compare the individuals in one sheet to the 3+ separate Rosters that hold the active individuals in other sheets.
Basically, if they are in a the large list but not in the individual rosters they are inactive and I can remove them from the larger list.
I have no problem setting up additional helper sheets/columns for formulas. I just need to figure out who is inactive on this large list.
Thank you for any ideas!
Help Article Resources
Check out the Formula Handbook template!