Forum Discussion

Jon_E1972's avatar
Jon_E1972
Copper Contributor
Feb 25, 2020
Solved

multiple same set columns

I have two columns, they are postcode prefixes (UK), so I have 147 postcodes, but I want to go from each postcode to the other. so, for example, W1 postcode to all other 147 postcodes, including W1. ...
excel
Formulas and Functions
  • Savia's avatar
    Savia
    Feb 25, 2020

    Jon_E1972 I made some columns to find the duplicate rows in the attached (anything with a 2).  I've left them in to show how it works but you can filter to find the duplicates and then remove both them and the helper columns I added.

Savia's avatar
Savia
Iron Contributor
Feb 25, 2020

Jon_E1972 I made some columns to find the duplicate rows in the attached (anything with a 2).  I've left them in to show how it works but you can filter to find the duplicates and then remove both them and the helper columns I added.

  • Jon_E1972's avatar
    Jon_E1972
    Copper Contributor
    Feb 25, 2020

    Savia thanks for that, every row with a 2 is a repeat. Perfect, thanks Savia. 

Resources