[mso] Re: Frequency/Count per Number of Visitors per date in Excel or Access
- From: "Van Baardwijk, Adri" <adri.vanbaardwijk@xxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Thu, 3 Feb 2005 20:57:40 +0100
Hello Ray,
Thank you for your reaction.
The column Visitors (B) contains the number of visitors on that day.
The column Number (B) is the same as the column Visitors (B).
The column Count is counting:
the number of days on which there was 01 visitor,
the number of days on which there were 02 visitors,
the number of days on which there were 03 visitors,
the number of days on which there were 04 visitors,
etc
the number of days on which there were 41 visitors,
the number of days on which there were 42 visitors.
I tried to use the (array) function:
=FREQUENCY(B2:B18;B2:B19) Result 0
{=FREQUENCY(B2:B18;B2:B19)} Result =FREQUENCY(B2:B18;B2:B19)
Dear Ray, how do you see the Crosstab query solution?
Thanks, Adri
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Ray Blake
Sent: donderdag 3 februari 2005 17:50
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Frequency/Count per Number of Visitors per date in
Excel or Access
I think we'd need to know a little more about how your data is held in
Excel, but I think a Crosstab query should do what you're after.
Ray
------------------------------------
GR Business Process Solutions
Ray Blake
Head of Software Design
ray@xxxxxxxxx
Braedon
Newell Road
Hemel Hempstead
Herts HP3 9PD
tel: 01442 396518
fax: 01442 389353
mobile: 07834 226601
------------------------------------
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Van Baardwijk, Adri
Sent: 03 February 2005 15:18
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
*************************************************************
*************************************************************
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:
