Re: Excel Sorting and summarizing
- From: "James Homuth" <james@xxxxxxxxxxx>
- To: jfw@xxxxxxxxxxxxx
- Date: Fri, 6 Feb 2009 19:10:21 -0500 (EST)
This isn't really a JAWS related question, and should have probably been
asked on the blindtech list as opposed to this one. I'd appreciate it if
anything further was taken either to private emails or that list. Thanks.
James,
List Admin
On Fri, February 6, 2009 19:06, Dave Carlson wrote:
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
--
JFW related links:
JFW homepage: http://www.freedomscientific.com/
Scripting mailing list:
http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
JFW List instructions:
To post a message to the list, send it to jfw@xxxxxxxxxxxxx
To unsubscribe from this mailing list, send a message to
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
Archives located at: //www.freelists.org/archives/jfw
Alternative archives located at:
http://n2.nabble.com/JAWS-for-Windows-f2145279.html
If you have any concerns about the list, post received from the list, or the
way the list is being run, do not post them to the list. Rather contact the
list owner at jfw-admins@xxxxxxxxxxxxxx
Other related posts:
