| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
delete repeating rows
I have a spreadsheet that has names and vacation dates in each column. Some
of the rows are repeating and I have to manually delete the repeating rows. Is there a formula to delete the duplicate rows? |
|
#2
|
|||
|
|||
|
You can use datafilteradvanced filter and select unique records only and
copy to another location -- Regards, Peo Sjoblom "aledger" wrote in message ... I have a spreadsheet that has names and vacation dates in each column. Some of the rows are repeating and I have to manually delete the repeating rows. Is there a formula to delete the duplicate rows? |
|
#3
|
|||
|
|||
|
I got it! Thanks for your help!
"Peo Sjoblom" wrote: You can use datafilteradvanced filter and select unique records only and copy to another location -- Regards, Peo Sjoblom "aledger" wrote in message ... I have a spreadsheet that has names and vacation dates in each column. Some of the rows are repeating and I have to manually delete the repeating rows. Is there a formula to delete the duplicate rows? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete empty rows between rows with text | Excel Discussion (Misc queries) | |||
| I want to delete duplicate rows of similar info and use the lates. | Excel Discussion (Misc queries) | |||
| How to delete duplicate rows in Excel 2000? | Excel Discussion (Misc queries) | |||
| How do I delete blank rows at the bottom of a spreadsheet to get . | Excel Discussion (Misc queries) | |||
| how do i delete empty rows in excel? | Excel Discussion (Misc queries) | |||
Linear Mode
