Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Deleting Duplicate Rows
Hello, I work in Asset Management and frequently use excel spreadsheets for record keeping. I'm trying to filter down a list of 500 computers by eliminating duplicates. Is there a quick easy way to delete all duplicated fields? Thank you, SP -- pettes01 ------------------------------------------------------------------------ pettes01's Profile: http://www.excelforum.com/member.php...o&userid=28655 View this thread: http://www.excelforum.com/showthread...hreadid=483172 |
#2
|
|||
|
|||
Deleting Duplicate Rows
Many methods. Start he
http://www.officearticles.com/excel/...ft_excel. htm ************ Anne Troy www.OfficeArticles.com "pettes01" wrote in message ... Hello, I work in Asset Management and frequently use excel spreadsheets for record keeping. I'm trying to filter down a list of 500 computers by eliminating duplicates. Is there a quick easy way to delete all duplicated fields? Thank you, SP -- pettes01 ------------------------------------------------------------------------ pettes01's Profile: http://www.excelforum.com/member.php...o&userid=28655 View this thread: http://www.excelforum.com/showthread...hreadid=483172 |
#3
|
|||
|
|||
Deleting Duplicate Rows
Thank you but I do not understand the directions. I type the formula but what is the fill button? I'm looking in one column so I'm using the exact formula in the model. =if(G2=G3, "Dupe", "") I have no clue what this formula does or how it was constructed but am just trying to copy it. Then it says to double click the fill button. copy, paste special, etc. Is there an easier way? SP -- pettes01 ------------------------------------------------------------------------ pettes01's Profile: http://www.excelforum.com/member.php...o&userid=28655 View this thread: http://www.excelforum.com/showthread...hreadid=483172 |
#4
|
|||
|
|||
Deleting Duplicate Rows
I got it!!!! Thanks! SP -- pettes01 ------------------------------------------------------------------------ pettes01's Profile: http://www.excelforum.com/member.php...o&userid=28655 View this thread: http://www.excelforum.com/showthread...hreadid=483172 |
#5
|
|||
|
|||
Deleting Duplicate Rows
COOL. :)
************ Anne Troy www.OfficeArticles.com "pettes01" wrote in message ... I got it!!!! Thanks! SP -- pettes01 ------------------------------------------------------------------------ pettes01's Profile: http://www.excelforum.com/member.php...o&userid=28655 View this thread: http://www.excelforum.com/showthread...hreadid=483172 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find duplicate rows then deleting them | Excel Worksheet Functions | |||
Deleting All Rows for Duplicate Entries Except Those With Most Items In Row | Excel Discussion (Misc queries) | |||
deleting hidden rows so i can print only the rows showing?????? | Excel Worksheet Functions | |||
How do I find duplicate rows in a list in Excel, and not delete it | Excel Discussion (Misc queries) | |||
Keeping duplicate rows | Excel Worksheet Functions |