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