booked

  1. C

    Lookup in VBA

    I have a sheet with a table listing each train we have based on the unit number, e.g.: <tbody> Start End Class Vehicles Seats 101000 101999 101 2 40 108000 108999 108 3 60 </tbody> I also have another table with the diagrams and which unit is booked to work each diagram, e.g. : <tbody>...
  2. D

    Keeping track of vendor invoices: what would you do differently

    https://1drv.ms/x/s!AvjBsEPEq12ngR1M8FneK-3B1Ew7?e=1pqHkd Hey guys, Let me explain my setup. This workbook is what I use to manage invoices that we pay to other companies. Company (1) sends us invoices. We'll pay them. Each week, Company (1) will send us a statement with a list of...
  3. J

    Multiple Conditions with INDEX

    I have a table on one sheet called BOOKINGS that has information for who booked a room, what room they booked, the date and what resources they need. I can look up and display every entry for a particular room easily enough but what I'd like to do is to display only the entries for that room...
  4. J

    Count appointments per each team member per time frame

    Hi all, please help: I work in a hospital. Front office team answers the phone and books doctor appointments for customers. Our system registers the time and date of the appointment and who booked it. I want to count how many appointments were booked by each team member, per time frame. On the...
  5. F

    Cross checking booked holiday with project dates

    Hi I have sheet1 (project dates) set up like this: Start Date | End Date | Initial 15/01/2019 20/01/2019 BF 16/01/2019 16/01/2019 FB 01/02/2019 14/02/2019 BF 15/02/2019 28/02/2019 FB ...and sheet2 (booked holiday) set up like this: Holiday Date | Initial...
  6. J

    Meeting room data

    Hi - hoping someone may be able to help please. This is way beyond my level of knowledge: I have one set of data from a meeting room booking system (booked data) in one tab and another set of data from sensors in the meeting room (actual data) in another tab. I want to compare / match various...
  7. G

    Displaying % in power BI

    My data is structured as below (snippet of data) <tbody> ID Location Status AP001 Location5 Booked AP002 Location3 Pending AP003 Location2 Lost AP004 Location7 Lost AP005 Location4 Booked AP006 Location2 Lost AP007 Location6 Lost AP008 Location1 Booked AP009 Location7 Lost...
  8. R

    Delete Rows Based on Cell Value from Another Sheet with Macro

    Hi, Hopefully this will be n easy question. In my active sheet I have an identifier in cell D5. Based on that ID I want to delete all rows in a sheet called "All Remotely Booked Txn Table" that do not have that ID in column B. For example, if my ID is 982 I want the macro to delete all rows...
  9. J

    count between dates

    Hi all Is there a way to count non blank cells between 2 dates ? I have a holiday planner and would like to know how many days holday each person has taken from the start of year to now. In the example below are the holidays booked , i need to know how many H's are between 23/04/2018 and now ie...
  10. N

    Simple array

    I'm trying to learn about basic array formulas. Following is my example: Booked Actual 33 32 9 16 8 6 21 30 27 25 16 16 13 43 19 49 Formula: {=sum(c4.c11>=b4.b11)} - entered without the brackets, using...
  11. G

    Removing duplicates based on multiple criteria

    Hi all, I'm not even sure if this is possible but I just wanted to see if there was a better solution to something I am struggling with. I am trying to remove duplicate instances from a list of training attendance. People are free to book on a course themselves but the problem from a...
  12. J

    Help with Pivot Charts

    Hi, new member to the forum here. Your help would be much appreciated. I'm beginning to build a dynamic dashboard to show the current state and availability of system environments however I'm struggling with displaying the data in the correct format that I want from a pivot table and chart. I...
  13. D

    Conditional formatting

    I have an open order file. I want to give everyone who pre booked 5 months in advance a 3% discount. I have a start date column and a booked date column. Is there an easy way to highlight my cells if this formula is true. i hope this makes sense.
  14. B

    conditional formatiing

    i would like to do conditional formatting between a range of dates <tbody> <tbody> August 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31...
  15. L

    Sum If total as share of overall total.

    Using PowerPivot I am struggling to create a measure to do the following: I have a bunch of projects that people book time to. Hours are booked to either capex or opex tasks. I can create measures to compare time booked to capex or opex. What I would like to do is: Filter out all the...
  16. M

    Multiple If or And

    Hello, I have sheet one that has all the calendar dates and spaces. Sample Sheet a <tbody> WA WA1 WA2 WA3 WA4 1/1/2019 1/2/2019 1/3/2019 1/4/2019 </tbody><colgroup><col><col span="5"></colgroup> Sheet 2 has the locations with the dates they are booked...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top