Pedro

Did you try the steps Michael gave?

Each duplicate in column A will have a "Y" in column B after you drag/copy the
formula down.

After you filter on "Y" and delete those rows only unique items will remain.


Gord Dibben MS Excel MVP



On Wed, 11 Jan 2006 08:07:05 -0800, "Pedro F."
wrote:

Thanx!
But the thing is that I have a lot of diferent values that are
repeated....so I would have to do it for each one of those values...

"Michael" wrote:

Pedro, assuming your data starts in a1, in b1 type =if(a1=a2,"Y","") and copy
down for the length of your data. Then filter on Y and delete all those
rows. HTH
--
Sincerely, Michael Colvin


"Pedro F." wrote:

Hi!
I have an huge table in which there are lots of rows that have the same
value as the one in the row befo

1
1
1
2
2
2

How can I delete them leaving this way only one row per value without
searching for them and deleting them manualy?

Any help welcome!