| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert rows based on specific value | Excel Worksheet Functions | |||
| use same cell w/in a function in a entire column. | Excel Discussion (Misc queries) | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| generate multiple rows based on cell value | Excel Worksheet Functions | |||
| Copy one cell to entire column | Excel Discussion (Misc queries) | |||
Hybrid Mode
