List of post codes

User avatar
Graeme
4StarLounger
Posts: 420
Joined: 11 Feb 2010, 12:23
Location: Medway, Kent, UK

List of post codes

Post by Graeme »

Hello Loungers.

I hope we're well.

I have a list of 1700 post codes in a column of a spreadsheet. I've used =Left(A1,4) to get the first part of each post code. But now I have a list of 1700 with a lot of duplicates. Would there be way of reducing my list so that I have a list of just one instance of each?

Thanks

Regards

Graeme

User avatar
StuartR
Administrator
Posts: 11564
Joined: 16 Jan 2010, 15:49
Location: London, Europe

Re: List of post codes

Post by StuartR »

If you have the latest version of Excel then you can use the array formula =UNIQUE(LEFT(A1:A1700,4))
StuartR


User avatar
Graeme
4StarLounger
Posts: 420
Joined: 11 Feb 2010, 12:23
Location: Medway, Kent, UK

Re: List of post codes

Post by Graeme »

StuartR wrote:
30 Jun 2021, 08:58
If you have the latest version of Excel .....

Thanks Stuart.

This is a work computer, they don't do latest versions!

Unfortunately, Unique function didn't work but I did find a Unique Values box to tick in Data>Filter>Advanced. So I'm good now thanks.

Regards

Graeme

Toranaga
3StarLounger
Posts: 239
Joined: 15 Aug 2016, 11:23

Re: List of post codes

Post by Toranaga »

I've used =Left(A1,4) to get the first part of each post code. But now I have a list of 1700 with a lot of duplicates.
Then use Remove duplicate from Data tab