Re: Excel Sorting and summarizing
- From: "Dave Carlson" <dgcarlson@xxxxxxxxxxxxx>
- To: <jfw@xxxxxxxxxxxxx>
- Date: Fri, 6 Feb 2009 16:06:19 -0800
Not sure if it's exactly the same, but there's something similar. I don't have
it any more, but check the help system in Excel and type in "remove duplicates"
and see what comes up.
Dave
----- Original Message -----
From: Ann Marie Medlar
To: jfw@xxxxxxxxxxxxx
Sent: February 06, 2009 2:31 PM
Subject: Re: Excel Sorting and summarizing
Does this work on Excel 2003?
----- Original Message -----
From: Dave Carlson
To: jfw@xxxxxxxxxxxxx
Sent: Friday, February 06, 2009 4:52 PM
Subject: Re: Excel Sorting and summarizing
Yes. In Excel 2007 use the data menu, and then on the lower ribbon,
arrow/tab until you get to Data Tool, and then you'll come next to Remove
duplicates. Works great.
Dave
----- Original Message -----
From: Ann Marie Medlar
To: jfw@xxxxxxxxxxxxx
Sent: February 06, 2009 1:13 PM
Subject: Excel Sorting and summarizing
Hi Folks,
Just wondering if anyone knows how to do folloing in Excel?
I created a spreadsheet that tracks where I go on my PC. The file is
called PFirelog.xlc.
In column f there is a IP address but many of IP addresses are the same.
So I would like to sort on column f and only have 1 line per IP address.
Does anyone know how to do this in Excel?
Thanks,
Ann
Visit the JAWS Users List home page at:
http://www.jaws-users.com
Visit the Blind Computing home page at:
http://www.blind-computing.com
Address for the list archives:
http://www.mail-archive.com/jaws-users-list@xxxxxxxxxxxxxx
To post to this group, send email to
jaws-users-list@xxxxxxxxxxxxxx
To unsubscribe from this group, send an email to
jaws-users-list-leave@xxxxxxxxxxxxxx
For help from Mailman with your account Put the word help in the subject
or body of a blank message to:
jaws-users-list-request@xxxxxxxxxxxxxx
Use the following address in order to contact the management team
jaws-users-list-owner@xxxxxxxxxxxxxx
If you wish to join the Blind Computing list send a blank email to the
following address:
blind-computing-join@xxxxxxxxxxxxxx
--------------------------------------------------------------------------
Checked by AVG - www.avg.com
Version: 8.0.233 / Virus Database: 270.10.18/1937 - Release Date:
02/06/09 11:31:00
----------------------------------------------------------------------------
Checked by AVG - www.avg.com
Version: 8.0.233 / Virus Database: 270.10.18/1937 - Release Date: 02/06/09
11:31:00
Other related posts:
