Are all 100 rows of Ann exactly the same, and then all 100 rows of Annette the same? If yes, are you wanting to delete 99 rows of each? Or are you trying to arrange all of your rows so that the 100 rows of Ann are together followed by the 100 rows of Annette?
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 2:59 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Excel sorting summarizing Hi I apologize for all the confusion. In this example there are 100 rows of Ann and 100 rows for Annette. The name Ann or Annette is in column f, comprising 200 records. After sorting on column f, all rows for Ann are together from a1:f100. So the first 100 rows have info for Ann in column F Followed by next 100 rows for Annette from a101 to f200. The duplication of rows is triggered by name Ann or Annette located in column F. If Excel can get rid of duplicates based on info in column 6 which is name Ann or Annette then only 1 row would be created for Ann and 1 row for Annette. ---- Original Message ----- From: "Patricia Dunbar" <patricia-dun...@sbcglobal.net> To: <jaws-users-list@jaws-users.com> Sent: Saturday, February 07, 2009 2:20 PM Subject: Re: [JAWS-Users] Excel sorting summarizing > It sounds like she is saying, Ann is on column 100 and Annette is on > row 100. > > ----- Original Message ----- > From: "Annette Carr" <amca...@verizon.net> > To: <jaws-users-list@jaws-users.com> > Sent: Saturday, February 07, 2009 6: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 > > > 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