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
List of post codes
-
- Cosmic Lounger
- Posts: 1218
- Joined: 11 Feb 2010, 12:23
- Location: Medway, Kent, UK
-
- Administrator
- Posts: 12601
- Joined: 16 Jan 2010, 15:49
- Location: London, Europe
Re: List of post codes
If you have the latest version of Excel then you can use the array formula =UNIQUE(LEFT(A1:A1700,4))
StuartR
-
- Cosmic Lounger
- Posts: 1218
- Joined: 11 Feb 2010, 12:23
- Location: Medway, Kent, UK
Re: List of post codes
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
-
- 3StarLounger
- Posts: 254
- Joined: 15 Aug 2016, 11:23
Re: List of post codes
Then use Remove duplicate from Data tabI'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.