View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tim m tim m is offline
external usenet poster
 
Posts: 430
Default How to find missing numbers in series

you could do conditional formatting on the column and check to see if the
cell is = "" and color the cell, this should show blank cells (but not cells
with a space in them).

Also depending on what you want to do with those with missing data you could
just sort the column and all the ones with missing data should be grouped
seperte from the ones with numbers.

"Phil" wrote:

Hello,

I have a column (OWNER ID, Col. B) with about 2500 rows of numbers, that are
supposed to be in succesion, incremented by 1, starting at 1. When I
highlighted the entire range, the last number in the series was 2546. But
the "COUNT" in the lower right corner of the screen shows only 2519. So I
now need to know where the missing numbers are, or better yet, where the
breaks are in the series.

How do I do this?

Thanks,

Phil