View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Spacy22 Spacy22 is offline
external usenet poster
 
Posts: 2
Default How to find missing numbers in a column

Hi,
I have a column of 1277 sequenced data points numbered 1 thru 12
(representing months) which repeat throughout the column. Some of the
numbers (months) are missing over numerous years and I need to locate these
numbers and replace the missing number with a blank column. Is there a very
simple way to do this??

Thanks!