ExcelBanter - Delete repeated Cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Delete repeated Cells (https://www.excelbanter.com/excel-worksheet-functions/45047-delete-repeated-cells.html)

Mosqui

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

Gary''s Student

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

Gord Dibben

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

All times are GMT +1. The time now is 08:34 PM.