I'd use a helper column and a formula (copied down).

=countif($a$2:$a$9999,a2)
(assuming headers in row 1)

Then copy down the range.

Then apply data|filter|autofilter to this range. Custom Filter to show greater
than 1.



billytf wrote:

hi,

possibly a basic query, but i have rarely used excel functions before

what i require is to filter a column to show only the non-unique entries.
i.e. if the data in one cell matches the data in another cell of the same
column then display this row. it no matches are found hide the row
(alternatively, just sort the column so matching entries are found at the top)

thanks in advance

ps. excel 97 sr2

--

Dave Peterson