Filtering Multiple Instances

[SamuelT]

Hi all,

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

TIA,

SamuelT

[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 wrote:
>
> Hi all,
>
> I have a spreadsheet that has a list of various properties. Many of
> these properties are listed more than once (always grouped together). I
> am trying to filter the list so I only see one instance of each
> property. Can anyone suggest how this can be achieved?
>
> TIA,
>
> SamuelT
>
> --
> SamuelT
> ------------------------------------------------------------------------
> SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501
> View this thread: http://www.excelforum.com/showthread...hreadid=565578

--

Dave Peterson

[SamuelT]

Thanks Dave - that seems to have done the trick!