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!