[mso] Re: Frequency/Count per Number of Visitors per date in Excel or Access
- From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Thu, 3 Feb 2005 11:44:55 -0500
Hi Adri and welcome. I'm not sure I understand....you have a date and
visitors in the first example, but in the results you show "number" and
"count"....I assume the count is a count of visitors for each date? But,
what is "number"?
Linda
Linda's Computer Stop
http://personal-computer-tutor.com
ABC Free Ezine ~ Free Ebooks and Tutorials
*all outgoing mail scanned by Norton AV. If you got a bug that looks like
it came from me, it did NOT!
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Van Baardwijk, Adri
Sent: Thursday, February 03, 2005 10:18 AM
To: MSO Freelists
Subject: [mso] Frequency/Count per Number of Visitors per date in Excel or
Access
Frequency/Count per Number of Visitors per date in Excel or Access
Hi dear MSO colleague,
Since 1 week I am a new MSO_user from Belgium.
I am very impressed what I already saw in the MSO Freelists Archive!
Now my problem:
I try to determine the frequency of the numbers of visitors per date.
I gather the data in Excel and copy it also in Access Tables.
In Excel I already have tried aray formula =Frequency, =count(if etc.
but I did not succeed.
I also want to try it in Access. But I don't know how to do it.
I already did look in the MSO Freelists Archive but I could not find the
answer.
Please I hope you can help me. Thank you in advance.
Details:
Input: Visitors per date
Date Visitors
3/11/2004 19
6/11/2004 42
10/11/2004 20
13/11/2004 03
17/11/2004 01
20/11/2004 07
24/11/2004 36
27/11/2004 03
1/12/2004 30
4/12/2004 17
8/12/2004 25
11/12/2004 11
15/12/2004 03
18/12/2004 10
22/12/2004 02
25/12/2004 09
29/12/2004 18
Result: Frequency/Count per Number
Number Count
01 1
02 1
03 3
07 1
09 1
10 1
etc
41 2
42 1
Thank you very much.
Adri
Adri van Baardwijk
1030 Brussel
Belgium
E-mail: adri.vanbaardwijk@xxxxxxxxx
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
