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