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.

You could use excel filter:

Data - Filter - Advanced Filter - Unique records only

edvwvw

JLMcCabes wrote:
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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/201004/1

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" wrote:

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.


.

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" wrote in message
...
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" wrote:

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.


.

Hi,
Thank you for your feedback

"JLMcCabes" wrote:

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" wrote in message
...
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" wrote:

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.


.



.

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

On Tue, 27 Apr 2010 09:19:09 -0400, "JLMcCabes"
wrote:

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" wrote in message
...
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" wrote:

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.


.