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
|