Re: Excel Sorting and summarizing
- From: "Dave Carlson" <dgcarlson@xxxxxxxxxxxxx>
- To: <jfw@xxxxxxxxxxxxx>
- Date: Fri, 6 Feb 2009 13:52:51 -0800
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
Other related posts:
