View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default How to find missing numbers in series

Hi Phill,

two ways

1. on an auxiliar column type =a2-a1 copy it down, use a conditional format
to highlight the results bigger than 1.

2. on an auxiliar column (D) ID 1 to 2519 = a1=d1 copy it down, copy again
paste especial values, find F

hth
regards from Brazil
Marcelo


"Phil" escreveu:

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