Filtering Multiple Instances

[SamuelT]

Hi all

I have a spreadsheet that has a list of various properties. Many o
these properties are listed more than once (always grouped together).
am trying to filter the list so I only see one instance of eac
property. Can anyone suggest how this can be achieved

TIA

Samuel

 

[Dave Peterson]

You could use a helper column with a formula like:

=countif(a$2:a2,a2)
drag down

Then filter to show the 1's.

 

[SamuelT]

Thanks Dave - that seems to have done the trick!