| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Delete repeated Cells
I have a long column with many repeated cells, how can I delete them to see
how many different ones I got? Thanks in advance. Mosqui |
|
#2
|
|||
|
|||
|
Make sure there is a header cell at the top of the column. Click on the
header cell and then pull-down: Data FIlter Autofilter... and check unique records only -- Gary''s Student "Mosqui" wrote: I have a long column with many repeated cells, how can I delete them to see how many different ones I got? Thanks in advance. Mosqui |
|
#3
|
|||
|
|||
|
DataFilterAdvanced Filter.
Checkmark "unique records only" and "copy to another location" or just filter in place. Gord Dibben Excel MVP On Mon, 12 Sep 2005 16:58:55 -0700, Mosqui wrote: I have a long column with many repeated cells, how can I delete them to see how many different ones I got? Thanks in advance. Mosqui |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
| How to delete blank rows | Excel Discussion (Misc queries) | |||
| How do I 'catch' a 'delete cells' event | Excel Discussion (Misc queries) | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
| delete values in several cells without deleting the formulas | Excel Discussion (Misc queries) | |||
Linear Mode
