Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

Counting sites visits within a year [Solved/Closed]

Report
Posts
13
Registration date
Friday February 17, 2017
Status
Member
Last seen
February 24, 2019
 -
Posts
1829
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
 -
Hi All,

I have a small database that is regularly updated keeping track of site visits and I want to be able to create a table of number of visits within a certain year PER site. Please see a sample of my database below:
Site Site Report Date Year Visit Reason
ID Name ID
3 MO 39 17/03/2015 2015 Gen Maint.
3 MO 40 02/04/2015 2015 Fault FM
3 MO 41 02/04/2015 2015 Fault DVBT
3 MO 42 02/04/2016 2016 Gen Maint.
3 MO 43 02/04/2017 2017 Fault FM
3 MO 44 02/04/2018 2018 Fault FM
5 VAV 51 02/04/2015 2015 Gen Maint.
5 VAV 52 03/04/2016 2016 Gen Maint.
5 VAV 53 08/04/2017 2017 Gen Maint.
32 MAD 64 21/04/2015 2015 Fault FM
32 MAD 65 22/05/2016 2016 Fault DVBT
32 MAD 66 22/06/2017 2017 Fault FM

The database is about 2500 rows and it keeps updated. There are 82 sites each site has its site id. For each visit a service report is issued and entered in the table with the date visit and the visit reason. All i need is to have on a separate sheet reading this info and by entering the year to produce me a table with the number of visit per site within that year.

Thank you all

Christos
See more

3 replies

Answer 1 / 3
Posts
1829
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
 135
christossol, Good afternoon.

I won't put the formulas here and explain how to assemble the layout because it will get too big text to explain.
I hope you understand.

I did an example for you using your sample.

https://www.sendspace.com/file/ehzmuj

Please, tell us if it worked as you desire.
I hope it helps.
--
Belo Horizonte, MG - Brasil.
Marcílio Lobão
Thank you
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 3438 users have said thank you to us this month

Report
Posts
13
Registration date
Friday February 17, 2017
Status
Member
Last seen
February 24, 2019
Hi Marcilio,
Thank you for your response but I can't download throu sendspace does not allow me with the free account....can u send via email please or a dropbox link?
Answer 2 / 3
Posts
1829
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
 135
christossol, Good afternoon.

To use www.sendspace.com is simple, without registration and totally free.

a) Click a blue link at my message.

b) When window opened, click a blue retangle written DOWNLOAD

c) When gray box opened click OK and file is saved at your computer.
Only this.

".....can u send via email please ..."
Sorry, it's against the forum rules.

I hope it helps.
Thank you
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 3438 users have said thank you to us this month

Report
Posts
13
Registration date
Friday February 17, 2017
Status
Member
Last seen
February 24, 2019
Dear Marcilio Good afternoon,

U were right it was downloading and I did not see it....
Your solution worked perfectly. Thank you very much and I appreciate the effort.
Christos
Answer 3 / 3
Posts
1829
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
 135
Christos, Good evening.

Glad to have helped you.

Thanks for the feedback.
--
Belo Horizonte, MG - Brasil.
Marcílio Lobão
Thank you
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 3438 users have said thank you to us this month

Ask a question