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

Do you have year information in a different column? And do you mean
that you need to insert a blank row for the missing numbers?

Pete

On Jan 27, 11:43*pm, Spacy22
wrote:
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!