Register
Log In
Unanswered
Home
New Member
April 28, 2014
Offline
Is there an easy way to find missing numbers in a range of cells. I have a large data file (6000 rows) with index numbers and need to make sure that I have not missed any. Any advise would help =- thanks
See Answer
October 5, 2010
Offline
Hi Chris,
Have a read of these blog posts which should help
Formula to find missing numbers
Cheers
Phil
Answers Post
Dashboards
June 25, 2016
Offline
Very interesting.
I am sure this will be very useful for me in the future.
Thanks Philip
Sunny Kow
October 5, 2010
Offline
No worries Sunny 
New Member
April 28, 2014
Offline
Fantastic - thanks Phil
Chris F
October 5, 2010
Offline
You're welcome Chris.
Dashboards
Power BI
Power Query
April 21, 2015
Offline
I also like the approach from Exceljet you can watch here: https://exceljet.net/tips/how-to-find-missing-values-with-countif
Maybe this also can help?
July 16, 2010
Offline
Hi Franz,
The ExcelJet approach is good if you have two lists you want to compare. In Chris' example he'd have to create a second list of his 6000 complete records in order to then find if any are missing from his original list.
I think in his case the formula or VBA solutions Phil suggested are more efficient.
Thanks for sharing, though. I'm sure this may be of use to others.
Mynda
Most Users Ever Online: 57
Currently Online: azri adrin, Mark Lund, Rudi
24 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Joy Berryhill
Ajay Mukhi
Stephen Motte
Rodney Hoyle
michael pitre
Samantha Burleson
Krishnaa Kurugod
David McSwain
Shameem Nassiree
Alanna Henderson
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
