Delete duplicate cells and more....

**Elegidos** · 10-08-2009, 05:58 PM

Hi again,

A way to delete in a column duplicate cells and delete cells that contain <= 5 and >=7 characters/numbers?

Thanks in advanced,
Elegidos (Spain)

**JBeaucaire** · 10-08-2009, 06:36 PM

If the values where in column A starting at A2, then in B2 you could enter this formula:

=OR(LEN(A2)<>6,ISNUMBER(MATCH(A2,$A$1:A1,0)))

Copy that formula down.

Sort the data or filter the data by that column, delete all the TRUE answers that are now together.

**Elegidos** · 10-08-2009, 06:46 PM

I've attached an example of the information I have in an excel sheet. But I don't know where to put the following code you provided me.

**Palmetto** · 10-08-2009, 07:45 PM

I've attached an example of the information I have in an excel sheet. But I don't know where to put the following code you provided me

You already have the formula in cell B2, so just extend (fill down) as many rows in column-B as there are used rows in column-A

Then use the AutoFilter feature to filter and show only cells that have a value of "TRUE". Once filtered, delete all of the rows with data, then turn off the auto filter and you have the results you want.