Mark Duplicate Applicant Names with an X in Excel
Question details
Mark Indeed applicants whose names also appear on a website applicant list.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Compare applicant names on two worksheets and display an X beside each Indeed name found on the website list.
- Observed behavior
- Matching names should display an X, while names not found on the website list should remain unmarked.
Identify the column containing Indeed names and the range containing website applicant names. Check that names are stored in a consistent format and that the website range includes all applicant rows.
Use MATCH to mark names found on the website list
Use an exact-match formula to check each Indeed applicant against a named range on the website worksheet.
On the website worksheet, select the applicant names without the header. Click the Name Box to the left of the formula bar, type website_list, and press Enter.
On the Indeed worksheet, select an empty cell beside the first applicant name. If the name is in A2, enter =IF(ISNUMBER(MATCH(A2,website_list,0)),"X","") and press Enter.
Select the formula cell and drag its fill handle down beside the remaining Indeed names. An X appears when a name is found in website_list.

Mark matching applicant names in WPS Spreadsheet
Use a MATCH formula in WPS Spreadsheet to compare names across worksheets and mark matches with an X.
- 1. Open the workbook: Open WPS Spreadsheet and select Open to load the workbook containing the Indeed and website lists.
- 2. Check the website range: Open the website worksheet and identify the cells containing applicant names, such as A2:A100. Note the worksheet name.
- 3. Enter the formula: On the Indeed worksheet, select a blank cell beside the first name. If the name is in A2 and the other sheet is named Website, enter =IF(ISNUMBER(MATCH(A2,'Website'!$A$2:$A$100,0)),"X",""). Adjust the sheet name and range as needed.
- 4. Fill and save: Drag the formula cell's fill handle down the applicant list, then select File > Save As to save the workbook in XLSX format.

Frequently Asked Questions
Can I use COUNTIF instead of MATCH?
Yes. If the website names are in website_list and the Indeed name is in A2, enter =IF(COUNTIF(website_list,A2)>0,"X","") in the adjacent cell and fill it down.
How do I compare names without creating a named range?
Reference the other worksheet directly. For example, use =IF(ISNUMBER(MATCH(A2,'Website'!$A$2:$A$100,0)),"X","") and replace Website and the range with your worksheet name and applicant cells.
Why is a name not marked even though it appears on both sheets?
Check for extra spaces or spelling differences in the two name cells. Also confirm that website_list or the worksheet range includes the row containing the name.
Does the formula distinguish between applicants with the same name?
No. It checks the name text only. Compare an additional identifier, such as an email address, if you need to distinguish people who share a name.




