Deleting Duplicate Rows

P

pettes01

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
 
P

pettes01

Thank you but I do not understand the directions. I type the formul
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 a
just trying to copy it.

Then it says to double click the fill button. copy, paste special
etc.

Is there an easier way?

S
 
Top