How do I flag duplicate equipment IDs without deleting any records?
Quick answer
In Excel, select the equipment ID cells and choose Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values. This highlights IDs that appear more than once without deleting records. Review each highlighted row before deciding whether it is a true duplicate: matching IDs alone do not prove that two records represent the same equipment. Keep the original list intact while you investigate.
The question, the details, the next step.
I have a spreadsheet of equipment records and want to find repeated IDs. How can I flag them without deleting anything?
Use conditional formatting to mark repeated ID values while leaving the rows in place. In Excel, select the cells containing IDs, then choose Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values. Excel highlights values that occur more than once in the selected range. [S1]
Treat the highlight as a review signal, not a deletion instruction. A repeated ID tells you that the value appears multiple times; it does not establish that the records themselves are redundant. [S1] Keep the source records unchanged as you investigate.
Can I use a formula instead, and how do I avoid highlighting the header?
Yes. Assuming the header is in B1 and IDs run from B2 through B200, select B2:B200 and create a conditional-formatting rule using this formula:
=COUNTIF($B$2:$B$200,B2)>1
The range in the first argument stays fixed, while B2 refers to the first selected ID cell. The rule highlights each selected ID whose value occurs more than once in the specified range. This example assumes your IDs are in column B; adjust the column and row numbers to match your sheet. The formula is a way to flag values for review, not to decide which record should be removed.
What should I do after the repeated IDs are highlighted?
Review the complete rows in each highlighted group, not just the ID cells. Compare the other details your list contains, such as equipment description, location, or record notes, and check those details against the records or process you normally rely on. These are comparison prompts, not proof that any particular field is authoritative.
For example, suppose two rows both show EQ-104, but one lists “North storage” and the other “Workshop.” The highlight identifies a repeated ID value; it cannot tell you whether the rows describe the same item, reflect a location change, or contain an entry mistake. Record what you found and ask the appropriate record owner to resolve uncertainty. Do not remove either row just because the ID repeats.
How can I keep the review traceable and make sure I haven't changed the original list?
Keep the original worksheet or file unchanged while you review. If your normal process permits it, make a separate working copy for notes; label it clearly so it is not mistaken for the source record. For each flagged ID, note the affected row numbers, what you compared, and whether the result is unresolved or needs follow-up. Avoid recording more information than your review needs.
A compact review note could look like this:
ID: EQ-104 | Rows: 18, 63 | Compared: description and location | Finding: location differs | Next step: confirm with record owner | Source rows retained
This is a placeholder example, not a claim about your equipment or records. Conditional formatting can locate repeated values, but it does not establish which entry is correct or authorize a record change. [S1]
A practical checklist
Select only the equipment ID cells, excluding the header.
Apply Duplicate Values conditional formatting or a COUNTIF-based rule.
Keep the original rows; treat each highlight as a prompt to investigate.
Compare the full flagged rows and note any uncertainty.
Record the review outcome and get appropriate confirmation before changing records.
A few more useful answers
Does a highlighted ID prove that one of the records is wrong?
No. It shows that the ID value appears more than once in the selected range; it does not establish that the records are redundant or identify which entry, if any, is wrong. [S1]
Will the duplicate-value rule delete or merge records?
The described conditional-formatting approach highlights repeated values; it does not remove records. Keep the rows in place while you review them. [S1]
What if my equipment IDs are in a different column?
Select the ID cells in their actual column and adapt the formula’s column letters and row limits to your selected range. The sample formula assumes IDs in B2:B200.
Sources
References used for this guide.
- [S1] Use conditional formatting to highlight information in Excel support.microsoft.com · Checked