sequence gaps

  1. M

    MISSING Alphanumeric Sequence

    Greets, I am trying to determine the easiest way to find a missing alphanumeric, alpha, or numeric sequence in a excel. I believe the functionality is already there in excel just not sure how to do it or where to start. Any help would be appreciated. Use Case: I am trying to find all the...
  2. S

    *Difficult Macro Request* Add rows for missing letter series for each set of duplicates

    Hello, I have a macro request that may be difficult but I hope you are up for the challenge :) I have a group of data that looks like this: <tbody> 30004 A 30004 B 59684-1 B 59684-1 C 85201 A 85201 C 85201 D 85201 E 30898 A 30899 A </tbody> As you can see, I the first...
  3. Z

    How to take sequential values with breaks and convert into high/low ranges

    I have zip codes in a single column and they do not increase incrementally by one each time. There are gaps in the sequence. I am trying to split this zip-code column into two, the low # and the high #. This is the current state: Zip-codes 73442 73443 73444 73446 73447 73448 73449 73451...
  4. S

    find gaps in sequence

    I have a file that contains addresses in column C. I need to find any gaps in addresses. Ex: 211 Corbin Dr 213 Corbin Drive 214 Corbin Drive 123 Apple Drive 124 Apple Dr 124 Apple Dr 127 Apple Drive I want to identify that there is a gap between 211 Corbin and 213 Corbin and 124 and 127...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top