Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   How do I find missing numbers from a sequece in excel 2003 (https://www.askmehelpdesk.com/showthread.php?t=527379)

  • Nov 19, 2010, 11:51 AM
    dragster1090
    How do I find missing numbers from a sequece in excel 2003
    I have a spread sheet with a thousand rows. These rows were numbered sequentially by part number. However, over the years people have deleted and added many rows (and there numbers). Is there a way to find out which part numbers are missing?
  • Nov 19, 2010, 12:16 PM
    ebaines

    How about sorting the list, so you can scan and see where the gaps in part numbers are? If the parts are sequential (part 1, part 2, etc), you can put a formula in the adjacent column to show a flag if the part number is not equal to the previous part number plus 1.

  • All times are GMT -7. The time now is 12:28 PM.