FG
💻 Software

Find missing entries from a list of sequential numbers in a column?

Fresh5 days ago
Mar 15, 202638239 views
Confidence Score0%
0%

Problem

I have an Excel sheet containing the results of 66000 test cases. Or, at least it should... Now, because I was running the tests asynchronously and kept stopping and starting I had the foresight to make sure the test numbers were put in the output. Now, having used Excel 2007's Remove Duplicates fe…

Error Output

|    A
--+---------
1 | testNum
2 | 1
3 | 2
4 | 3
5 | ...

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Find missing entries from a list of sequential numbers in a column?

Low Risk

Assuming your data is in Column A and begins on row 2, select a range in a free column starting on row 2 and including at least as many rows as you should have results (this is important: if your range includes less cells than your total sequence, t…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment