Duplicates - ??

[JLMcCabes]

One worksheet has 600 + lines with a lot of expenses, including SOME of the
local expenses. This is a check register..
Another worksheet has 300 + lines with ONLY local expenses.
Trying to get ALL expenses together, but eliminating the duplicates from new
list. Thinking B2=date. C2=name, E2=amount - - SO B2&C2&E2 on first long
worksheet and then the same on short worksheet... Bring BOTH over to new
tab and then stuck. Any ideas greatly appreciated, or another better way to
attack it.

 

[edvwvw via OfficeKB.com]

You could use excel filter:

Data - Filter - Advanced Filter - Unique records only

edvwvw

 

[Eduardo]

Hi,
See CPearson web

http://www.cpearson.com/excel/Duplicates.aspx
http://www.cpearson.com/excel/ListFunctions.aspx

if you want to delete the duplicates

http://www.cpearson.com/excel/deleting.htm

if this helps please click yes thanks

 

[JLMcCabes]

I would click yes thanks BUT me no got that little icon. But I do want
to say thank you for your help, my project will be easier now..

 

[Eduardo]

Hi,
Thank you for your feedback

I would click yes thanks BUT me no got that little icon. But I do want
to say thank you for your help, my project will be easier now..



.

 

[Gord Dibben]

You are using OE as a news reader so won't see any "Yes" icon.

Only if posting through the discussion groups.


Gord Dibben MS Excel MVP