Deleting Duplicate Rows

  • Thread starter Thread starter pettes01
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicate Rows 2
Duplicates Deletion ? 2
How to Delete duplicate row access 2003 0
Excel question 2
remove duplicates but retain one not delete both 4
Delete duplicate and original row 3
Conditional Formatting Tricky question 5
Identify (not delete) exact duplicates 1

Back
Top