+ Reply to Thread
Results 1 to 3 of 3

Designing a table with 3 elements

  1. #1
    Registered User
    Join Date
    07-21-2015
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    40

    Designing a table with 3 elements

    Hi all,
    I know the title doesn't describe the problem well so let me try to explain:

    I need to design a table that allows me to track the usage of meeting rooms. I need to know how many times the room is used in a day and by whom. For example, Room 1 can be used between 10am and 1pm by team 1 and then used again between 2pm and 4pm by team 2. I need the table to cover every work day of the month. At the moment I have a table that has days of the month across the top and room numbers along the side. When a room is used, a 1 is placed in the table and then all the 1's are added up. What my table fails to do is to capture rooms that are used by two or more different teams each day.

    Does any one have any idea how I can capture that?
    Attached Files Attached Files

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Designing a table with 3 elements

    Where are the days/times/teams listed? If you had that COUNTIF(s) should work.
    Dave

  3. #3
    Registered User
    Join Date
    06-26-2019
    Location
    London, England
    MS-Off Ver
    Office 365
    Posts
    26

    Re: Designing a table with 3 elements

    I read the previous comment and the layout you were trying to do might have made your life somewhat complicated.

    I took the opportunity to develop something which may be of some use to yourself.

    I have added 4 sheets to hopefully answere your question. I have not used any VBA in case it doesn't work on your version.
    1. Room Trackings
    2. Validation
    3. Summary
    4. Pivot Summary

    Room Tracking - to be used to track all the bookings made for meeting rooms. It is layed out in an Excel Table
    Validation - Just has the meeting names in a list, it may need to be modified to show the actual room names
    Summary - provides a summary in the layout as laid out in the original file
    Pivot Summary - will provide a summary of the data on Room Trackings - it just requires the data to be refreshed once you have entered the data on "Room Tracking".

    I hope that this helps.

    Ian
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Excel IsNumber Function treats array elements differently from range elements
    By Alan Beban in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-31-2018, 02:22 PM
  2. Constructing new table based on elements of a pre-existing table
    By the number cruncher in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-05-2017, 06:59 AM
  3. Sum and CountIF with table elements
    By BuZZarD73 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-24-2015, 11:32 AM
  4. help designing a huge table
    By bos1234 in forum Excel General
    Replies: 3
    Last Post: 03-27-2013, 01:14 PM
  5. Need Help Designing a Macro to Search a table, match a name and paste a cell value
    By adamkingf5371 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-10-2012, 06:22 PM
  6. Replies: 1
    Last Post: 06-20-2012, 08:14 AM
  7. designing and saving predefined pivot table formats?
    By Surfstiling in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-25-2005, 12:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1