View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
DTTODGG
 
Posts: n/a
Default Find missing sequential numbers

Hello, I'm looking for a way to quickly find what numbers are missing in
column B. I can sort them ascending, but how do I find if there are missing
numbers?
1
2
3
5
6
7
9
I need to know 4 and 8 are missing.
Thank you.