How to find missing numbers in series
Say your list starts in B2.
Enter this formula in C3, and copy down:
=B2+1=B3
This will give you a "False" in every row that is not in order.
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"Phil" wrote in message
...
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
|