Notifications
Clear all
General Excel Questions & Answers
6
Posts
3
Users
0
Reactions
85
Views
Topic starter
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
Posted : 12/07/2016 10:19 pm
Hi Chris,
Have a read of these blog posts which should help
Formula to find missing numbers
Cheers
Phil
Posted : 12/07/2016 10:45 pm
Very interesting.
I am sure this will be very useful for me in the future.
Thanks Philip
Sunny Kow
Posted : 12/07/2016 11:20 pm
No worries Sunny
Posted : 12/07/2016 11:47 pm
Topic starter
Fantastic - thanks Phil
Chris F
Posted : 12/07/2016 11:55 pm
You're welcome Chris.
Posted : 13/07/2016 4:08 am