Part IV: Managing and Analyzing Data
FIGURE 25.20
The goal is to identify member numbers that are in the Resigned Members list in column F.
This workbook, named match names.xlsx, is available on this book’s website at http://www.wiley
.com/go/excel2019bible.
Here’s a formula, entered into cell D2 and copied down, that will do the job:
=IF(COUNTIF($F$2:$F$22,B2)>0,"Resigned","" )
This formula displays the word Resigned if the member number in column B is found in the
Resigned Members list. If the member number is not found, it returns an empty string. If
the list is sorted by column D, the rows for all resigned members will appear together and
can be quickly deleted.
This technique can be adapted to other types of list-matching tasks.
