I'm wondering if you might have to do that manually removing the
rows/columns yourself.
I remember doing some sorting by names and Excel was picky on how the names
were written separated by a comma with the last name first, it didn't seem
to work on first names. I haven't done it in many years though and I used
Office 2000 back then and I'm using 2003 now which probably isn't much
difference.
But I wondered if it was too much trouble to select the rows you didn't want
and delete them or maybe you've already done this.
I use Excel some doing very basic stuff and I might be way off base here in
what you need to do.
Then I wondered if the find and replace feature worked in Excel same as for
Word. Maybe that would solve this problem for you in regards to
duplications?
----- Original Message -----
From: "Ann Marie Medlar" <amedl...@bellsouth.net>
To: <jaws-users-list@jaws-users.com>
Sent: Saturday, February 07, 2009 1:58 PM
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
