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" <[email protected]>
To: <[email protected]>
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" <[email protected]>
To: <[email protected]>
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: [email protected]
[mailto:[email protected]] 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/[email protected]
To post to this group, send email to
[email protected]
To unsubscribe from this group, send an email to
[email protected]
For help from Mailman with your account Put the word help in the subject
or
body of a blank message to:
[email protected]
Use the following address in order to contact the management team
[email protected]
If you wish to join the Blind Computing list send a blank email to the
following address:
[email protected]
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/[email protected]
To post to this group, send email to
[email protected]
To unsubscribe from this group, send an email to
[email protected]
For help from Mailman with your account Put the word help in the subject
or body of a blank message to:
[email protected]
Use the following address in order to contact the management team
[email protected]
If you wish to join the Blind Computing list send a blank email to the
following address:
[email protected]
--------------------------------------------------------------------------------
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/[email protected]
To post to this group, send email to
[email protected]
To unsubscribe from this group, send an email to
[email protected]
For help from Mailman with your account Put the word help in the subject
or body of a blank message to:
[email protected]
Use the following address in order to contact the management team
[email protected]
If you wish to join the Blind Computing list send a blank email to the
following address:
[email protected]
--------------------------------------------------------------------------------
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/[email protected]
To post to this group, send email to
[email protected]
To unsubscribe from this group, send an email to
[email protected]
For help from Mailman with your account Put the word help in the subject or
body of a blank message to:
[email protected]
Use the following address in order to contact the management team
[email protected]
If you wish to join the Blind Computing list send a blank email to the
following address:
[email protected]
