Forum

Notifications
Clear all

Finding Missing Numbers in a range

6 Posts
3 Users
0 Reactions
85 Views
(@chris-ferreira)
Posts: 2
New Member
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
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
 

Hi Chris,

Have a read of these blog posts which should help

Formula to find missing numbers

VBA to find missing numbers

Cheers

Phil

 
Posted : 12/07/2016 10:45 pm
(@sunnykow)
Posts: 1417
Noble Member
 

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
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
 

No worries Sunny Laugh

 
Posted : 12/07/2016 11:47 pm
(@chris-ferreira)
Posts: 2
New Member
Topic starter
 

Fantastic - thanks Phil

Chris F

 
Posted : 12/07/2016 11:55 pm
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
 

You're welcome Chris.

 
Posted : 13/07/2016 4:08 am
Share: