View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Compare Values Compare Values is offline
external usenet poster
 
Posts: 17
Default Find gaps or breaks in a large column

I have a very large column and I need to find out where the breaks or gaps
are. Example on the below column #1793675 and 1793682 are not listed. Can you
please advise a formula to check them?
1793672
1793673
1793674
1793676
1793677
1793678
1793679
1793680
1793681
1793683