Function Problems

Mark Duplicate Applicant Names with an X in Excel

Maira MehtabMaira Mehtab Nov 18, 2026 868 views

Question details

Mark Indeed applicants whose names also appear on a website applicant list.

Mark Duplicate Applicant Names with an X in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Name the website list

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.

2
Enter the match formula

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.

3
Fill the formula down

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.

Use MATCH to mark names found on the website list
Check inconsistent names: MATCH is not case-sensitive, but extra spaces or differences in spelling can prevent a match. Matching names alone also do not guarantee that two records belong to the same person.
Compare applicant lists in WPS

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. 1. Open the workbook: Open WPS Spreadsheet and select Open to load the workbook containing the Indeed and website lists.
  2. 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. 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. 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.
Mark matching applicants without manually comparing listsOpen and save Microsoft Excel XLSX workbooksUse familiar spreadsheet formulas and fill controlsWork with applicant lists in a free, easy-to-use office suite
microsoft office alternative - wps office

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.