| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
matching column entries
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting unique entries in column A but only if specific values appear in columns B and C | Excel Worksheet Functions | |||
| Preventing Duplicate Entries within a column | Excel Discussion (Misc queries) | |||
| Filtering a column to exclude any repeated entries. | Excel Discussion (Misc queries) | |||
| how do i see if entries in one column are in another column? | New Users to Excel | |||
| I want to delete rows with duplicate entries within one column. | Excel Discussion (Misc queries) | |||
Threaded Mode
