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
