Well if you sorted on the column where the names are stored, you would have all of each name grouped together. I've not had much with filters, and I've never worked with the delete duplicate feature. I usually just manually delete the rows I do not want.
Annette -----Original Message----- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Ann Marie Medlar Sent: Saturday, February 07, 2009 1:48 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Excel sorting summarizing Hi Annette, I just used our names as an example to demonstrate my problem. I guess what I meant is that my name appears in rows 100 times in column f and your name appears on 100 rows in column f. So I believe if I sort on column f all ann rows will be together and 100 rows annette would be together. If I could drop duplicates or summarize on column f then I would have 1 row for Ann and 1 row for Annette. I sort of found something for Excel 2003 in data, filter, advanced filter, drop duplicate records, but it did not work as I thought it would. I'll try again later or tomorrow. I find when I walk away from something and go back to it later I usually solve problem. But thank you for your suggestion. Even the sort on column did not work for column f. The real data in column F is an IP address because I am tracking the c:\windows\PFirewall.Log file because I thought I had a hacker on my PC. Long story but this sighted person had access to my desktop inside my home. I blocked exceptions in Windows firewall, changed passwords on DSL, modem, banks. I added passwords to all sensitive documents on my PC. So I thought this file if sorted and summarized would go from about 37,000 rows down to about 100 or less. I then could do research on IP addresses. It is just my way of trying to investigate. I have AVG Free edition 8.0 and Super AntiSpyware software installed. I'll let you know if I succeed. I am uncertain if I could even research these 100 IP address. Most IP addresses are mine or ones that I know about. Hope this makes sense. Ann Ann ----- Original Message ----- From: "Annette Carr" <amca...@verizon.net> To: <jaws-users-list@jaws-users.com> Sent: Saturday, February 07, 2009 7:03 AM Subject: Re: [JAWS-Users] Excel sorting summarizing >I do not get how both Ann and Annette can be on row 100. > > -----Original Message----- > From: jaws-users-list-boun...@jaws-users.com > [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Ann Marie > Medlar > Sent: Friday, February 06, 2009 7:42 PM > To: jaws-users-list@jaws-users.com > Subject: Re: [JAWS-Users] Excel sorting summarizing > > Sorry Annette, > I meant that Ann is on 100 rows and Annette is on 100 rows. After sorting > and possibly summarizing I would only have 2 rows, 1 for Ann, 1 for > Annette. > Ann > > ----- Original Message ----- > From: "Ann Marie Medlar" <amedl...@bellsouth.net> > To: <jaws-users-list@jaws-users.com> > Sent: Friday, February 06, 2009 7:38 PM > Subject: Re: [JAWS-Users] Excel sorting summarizing > > >> Hi Annette, >> Yes I think I know how to sort but say in column f is my name Ann and I >> am >> on 100 columns. Then Annette is on 100 rows. I want only 2 rows 1 for >> Ann >> and 1 for row. I hope I explained it okay? >> Ann >> >> ----- Original Message ----- >> From: "Annette Carr" <amca...@verizon.net> >> To: <jaws-users-list@jaws-users.com> >> Sent: Friday, February 06, 2009 6:58 PM >> Subject: Re: [JAWS-Users] Excel sorting summarizing >> >> >>> If I understand you correctly, you have information stored in an Excel >>> spreadsheet. Each row is one complete record. You want to sort/arrange >>> the >>> rows by the information you have stored in Column F. If this is >>> correct, >>> you can do the following: >>> >>> Move your cursor to the first row of data in column F, or if you have a >>> header row, place the cursor on the header for Column F. >>> >>>>From the menu bar open the Data menu and navigate to sort. I think it >>>>is >>> the first item. >>> >>> A dialog box will open. JAWS 8 and 9 act a bit odd when reading some of >>> the >>> fields in this dialog box. >>> >>> You will be able to select the column you want to sort on. You will >>> either >>> see the header names or the column letter. Hopefully by placing your >>> cursor >>> on the header of column F, you will see the columns names instead of the >>> letters. >>> >>> Sometimes you have to tab away from a field and back again in this >>> dialog >>> box to hear what is in it. >>> >>> There are a few other fields you can change that will effect your sort. >>> Just let me know if you need help figuring any of these out. >>> >>> HTH, >>> Annette >>> >>> -----Original Message----- >>> From: jaws-users-list-boun...@jaws-users.com >>> [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Ann Marie >>> Medlar >>> Sent: Friday, February 06, 2009 3:46 PM >>> To: JawsUsersList >>> Subject: [JAWS-Users] Excel sorting 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@jaws-users.com >>> To post to this group, send email to >>> jaws-users-list@jaws-users.com >>> To unsubscribe from this group, send an email to >>> jaws-users-list-le...@jaws-users.com >>> For help from Mailman with your account Put the word help in the subject >>> or >>> body of a blank message to: >>> jaws-users-list-requ...@jaws-users.com >>> Use the following address in order to contact the management team >>> jaws-users-list-ow...@jaws-users.com >>> If you wish to join the Blind Computing list send a blank email to the >>> following address: >>> blind-computing-j...@jaws-users.com >>> >>> >>> 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@jaws-users.com >>> To post to this group, send email to >>> jaws-users-list@jaws-users.com >>> To unsubscribe from this group, send an email to >>> jaws-users-list-le...@jaws-users.com >>> For help from Mailman with your account Put the word help in the subject >>> or body of a blank message to: >>> jaws-users-list-requ...@jaws-users.com >>> Use the following address in order to contact the management team >>> jaws-users-list-ow...@jaws-users.com >>> If you wish to join the Blind Computing list send a blank email to the >>> following address: >>> blind-computing-j...@jaws-users.com >> >> >> > ---------------------------------------------------------------------------- > ---- >> >> >> >> >> Checked by AVG - www.avg.com >> Version: 8.0.233 / Virus Database: 270.10.19/1938 - Release Date: >> 02/06/09 >> 11:31:00 >> >> >> 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@jaws-users.com >> To post to this group, send email to >> jaws-users-list@jaws-users.com >> To unsubscribe from this group, send an email to >> jaws-users-list-le...@jaws-users.com >> For help from Mailman with your account Put the word help in the subject >> or body of a blank message to: >> jaws-users-list-requ...@jaws-users.com >> Use the following address in order to contact the management team >> jaws-users-list-ow...@jaws-users.com >> If you wish to join the Blind Computing list send a blank email to the >> following address: >> blind-computing-j...@jaws-users.com > > > ---------------------------------------------------------------------------- > ---- > > > > > Checked by AVG - www.avg.com > Version: 8.0.233 / Virus Database: 270.10.19/1938 - Release Date: 02/06/09 > 11:31:00 > > > 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@jaws-users.com > To post to this group, send email to > jaws-users-list@jaws-users.com > To unsubscribe from this group, send an email to > jaws-users-list-le...@jaws-users.com > For help from Mailman with your account Put the word help in the subject > or > body of a blank message to: > jaws-users-list-requ...@jaws-users.com > Use the following address in order to contact the management team > jaws-users-list-ow...@jaws-users.com > If you wish to join the Blind Computing list send a blank email to the > following address: > blind-computing-j...@jaws-users.com > > > 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@jaws-users.com > To post to this group, send email to > jaws-users-list@jaws-users.com > To unsubscribe from this group, send an email to > jaws-users-list-le...@jaws-users.com > For help from Mailman with your account Put the word help in the subject > or body of a blank message to: > jaws-users-list-requ...@jaws-users.com > Use the following address in order to contact the management team > jaws-users-list-ow...@jaws-users.com > If you wish to join the Blind Computing list send a blank email to the > following address: > blind-computing-j...@jaws-users.com ---------------------------------------------------------------------------- ---- Checked by AVG - www.avg.com Version: 8.0.233 / Virus Database: 270.10.19/1938 - Release Date: 02/06/09 17:28:00 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@jaws-users.com To post to this group, send email to jaws-users-list@jaws-users.com To unsubscribe from this group, send an email to jaws-users-list-le...@jaws-users.com For help from Mailman with your account Put the word help in the subject or body of a blank message to: jaws-users-list-requ...@jaws-users.com Use the following address in order to contact the management team jaws-users-list-ow...@jaws-users.com If you wish to join the Blind Computing list send a blank email to the following address: blind-computing-j...@jaws-users.com 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@jaws-users.com To post to this group, send email to jaws-users-list@jaws-users.com To unsubscribe from this group, send an email to jaws-users-list-le...@jaws-users.com For help from Mailman with your account Put the word help in the subject or body of a blank message to: jaws-users-list-requ...@jaws-users.com Use the following address in order to contact the management team jaws-users-list-ow...@jaws-users.com If you wish to join the Blind Computing list send a blank email to the following address: blind-computing-j...@jaws-users.com