If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Duplicates - ??
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. |
#2
|
|||
|
|||
Duplicates - ??
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 |
#3
|
|||
|
|||
Duplicates - ??
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. . |
#4
|
|||
|
|||
Duplicates - ??
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. . |
#5
|
|||
|
|||
Duplicates - ??
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. . . |
#6
|
|||
|
|||
Duplicates - ??
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. . |
Thread Tools | |
Display Modes | |
|
|