Deleting Duplicate Rows

[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

[Anne Troy]

Many methods. Start here:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"pettes01" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[pettes01]

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]

I got it!!!!

Thanks!

SP

[Anne Troy]

COOL.
************
Anne Troy
www.OfficeArticles.com

"pettes01" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>