deleting entire rows with the same cell value in the first column

P

Pedro F.

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

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!
 
M

Michael

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
 
P

Pedro F.

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...
 
G

Gord Dibben

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
 
Top