find gaps in sequence

[schurers]

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 Apple Drive.

Currently the address including house number are in column c. However, I split the house number into a separate column and the street address in yet another column. There are also duplicates which I have identified by using conditional formatting to highlight the duplicates. Thanks in advance!!!!

 

[schurers]

=a3=a4 returns True and automatic recalc is being done.
I just typed the data into a blank spreadsheet instead of using the one I had and your formula worked but for some reason on the worksheet I am attempting to use it doesn't. This is the worksheet were the address is being shown in 1 field and I parsed it to 2 fields. Could I have done something wrong there?