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

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!

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

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!

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

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!

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

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!