View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
shail shail is offline
external usenet poster
 
Posts: 195
Default How to find missing numbers in series

Hi Phil,

HTH and Marcello has already gave you the good answers to track the
error. Let me help you putting down the number in a series from 1 to
2500.

Click Menu EDITFILLSeries

Select Series in ROWS or COLUMNS then STEP VALUE as 1 and STOP VALUE as
2500. Click OK.

You will see the column or the row filled with the desired value
without any glitch.

Thanks,

Shail



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