[mso] Frequency/Count per Number of Visitors per date in Excel or Access
- From: "Van Baardwijk, Adri" <adri.vanbaardwijk@xxxxxxxxx>
- To: "MSO Freelists" <mso@xxxxxxxxxxxxx>
- Date: Thu, 3 Feb 2005 16:18:15 +0100
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:
