Hi!
Or, use Dave's formula idea with a little change:
=countif($a$2:$a$9999,a2)1
Now, select both the helper column and the data column.
Sort on the helper column descending then on the data
column ascending.
Biff
-----Original Message-----
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
.
|