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

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

Thanks Dave - that seems to have done the trick!


--
SamuelT
------------------------------------------------------------------------
SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501
View this thread: http://www.excelforum.com/showthread...hreadid=565578