A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Duplicates - ??



 
 
Thread Tools Display Modes
  #1  
Old April 27th, 2010, 11:32 AM posted to microsoft.public.excel.newusers
jlmccabes
external usenet poster
 
Posts: 9
Default 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  
Old April 27th, 2010, 12:05 PM posted to microsoft.public.excel.newusers
edvwvw via OfficeKB.com
external usenet poster
 
Posts: 79
Default 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  
Old April 27th, 2010, 01:02 PM posted to microsoft.public.excel.newusers
eduardo
external usenet poster
 
Posts: 2,131
Default 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  
Old April 27th, 2010, 02:19 PM posted to microsoft.public.excel.newusers
jlmccabes
external usenet poster
 
Posts: 9
Default 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  
Old April 27th, 2010, 03:57 PM posted to microsoft.public.excel.newusers
eduardo
external usenet poster
 
Posts: 2,131
Default 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  
Old April 27th, 2010, 04:03 PM posted to microsoft.public.excel.newusers
Gord Dibben
external usenet poster
 
Posts: 20,252
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:54 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.