Looping through postcodes

[v1k]

Hi,

I want to loop through a list of 40,000 postcodes to find any of them that begin with the prefix SE or SW. However, some of the postcodes are poorly formatted.

Raw data:



Desired result:



How would I do this ? Is it possible to use the ISNUMBER(MATCH()) function and then sort through the list to only show ones that give "TRUE"? This doesn't seem to work.

Thanks,

Vik

 

[hurgadion]

Hi,
try the code

Sub aaa()
Dim i&
For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -1
  If Not (Cells(i, 1).Value Like "SE*" Or Cells(i, 1).Value Like "SW*") Then Rows(i).Delete
Next i
End Sub

or similare one.

Best regards

 

[BenMiller]

Or for a non VBA solution, you can try =OR(LEFT(A1,2)="SE",LEFT(A1,2)="SW")