I am not understanding what you are doing with the 2 rows or columns Maybe it is just too early in the morning for me to be reading your explanation.
Do you have headers at the top of each column? If so how many columns wide is your information? How many rows of data do you have? Is the information for each record contained to one row, or is it stored on 2 or more rows for each record? 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 7:39 PM To: jaws-users-list@jaws-users.com 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 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
