1. P

    Golf Trip Pairings w/ No Repeats

    We have a 32-man golf trip that is split up into 2 teams of 16. We play 4 rounds. I am trying to come up with a schedule where everyone has a different partner all 4 rounds, and everyone will play against different people on the opposing team over the 4 rounds (8 in total), with no overlap or...
  2. T

    Dynamic Schedule Of Dates

    I work for a small company who manufactures kitchens in Oxfordshire. We work on the basis of being able to make 9 kitchen units per day, 4 days a week - so a kitchen that has a total of 27 units would take 3 days to complete. As there are many external factors that can delay or bring...
  3. R

    VBA overwrite table in sheet1 with table in sheet2

    I have a schedule in sheet1 and a schedule in sheet2. I want to "subtract" the table range in sheet2 with the table range in sheet1. Sheet2 is the "skeleton" of the schedule, and the determined values in specific cells. Sheet1 is the "skeleton table", just with cells added afterwards. So i want...
  4. A

    Schedule with criterias.

    Hi I am trying to create a schedule with multiples conditions as below decription: I have 100 customer, each customer have 1000Kw of electric, and I need theme cut off electric few day in month, which is: Forgive for my poor english ^^ Thank for spend time to read and help.
  5. L

    Production schedulling (times of machine)

    To anyone who can help!!?? Very new to excel but I know its magic (with the right person creating it). So at my place of work, the first thing I do in the morning is print out all the jobs for each machine we have. Each machine may have 20+ jobs on (11machines in total). I then manually time...
  6. J

    counting 7th data after zero

    hello good day, i was working on monitoring the 7th day duty of guards, i don't know what formula to be used. i have a thousands of data to check it one by one. i just want to have a formula that marks or emphasized the 7th day data after zero. thank you. attached is a sample.
  7. N

    Production Schedule

    Hello, I'm trying to design a production schedule and make it visual at the same time. There are 3 machines, and I would like to allocate jobs for each machine, based on 5 days production and 10hr shifts (jobs are not allocated per person, rather, per machine). Ideally I would like to define...
  8. T

    Attempting to create a rotating work schedule...

    Good afternoon! I am trying to create a rotating work schedule. There are five main colleagues and six jobs. I want to be able to assign these jobs on a daily basis evenly. So every day, someone gets a different job when I click a button perhaps. Is that possible? For the sixth job, I want it...
  9. H

    Calendar Data to Input to Excel like Outlooks built in scheduling form

    Hey There is there a way I can create something similar to the outlook Calendar input form that I can use for budgeting analysis on my excel spreadsheet? Is it crazy hard? Would this need to be done with User forms? Is there an alternate method you would suggest? Thanks in advance! Kind...
  10. D

    Lookup/Match Based on Multiple Details (non-VBA)

    Hey guys, I am trying to set up a spreadsheet to fill in time slots based on day and time information. There are two sheets in the workbook (Calendar and Log) Here is how I have it set up: The name of this sheet is Calendar A B C 1 Wednesday (August 19, 2020) Thursday (August 20...
  11. R

    VBA Comparing Name on schedule to vacation list

    I'm hoping someone on here can help we with what I'm trying to create in our Excel work schedule. In the Sheet "Availability" it lists all of the employee's in Column B. With the date listed in Row 2. In the Sheet "Assignments" is where we enter each employee's assignment for that day (Date is...
  12. F

    Flag shifts conflicts on multi-location schedule

    Hi There, I have been working on a multilocation (6) weekly scheduling board for 19 employees with some of them having different attributes (notary/supervisor). I would like to make sure the same employee doesn't get schedule at two location for the same time, but sometimes, employees have two...
  13. E

    Calculate Days Worked and Days Off

    I’m interested in a few formulas to calculate total number of days worked and days off in a calendar year, and each month based on known values. For example: Employee Day Rate: $500/day If they work a schedule that is 3 days on and 4 days off that repeats itself for a year, I would like to...
  14. M

    variable installment months

    Hi Dears I am not an accountant person that's why i can't calculate this. so please help me i have sheet to calculate the installment amounts of price of the apartment. it's 2500000 $ if cst want to pay 10% (variable percent) in the start which 250000 $ . then install the rest of amount on 1 ...
  15. A

    Generating Sign In Sheets from a Master Schedule

    I'm usuallypretty good about self-learning/teaching myself enough to do what I need to,but today I'm at a standstill. Two reasons why, one, I can't seem to think ofthe best way to approach what I need to do, and second, trying to google thequestion in my head doesn't translate well at all. So...
  16. D

    Month by Number

    Hello, I am wondering if there is a way to calculate months mathematically. For example, if this month is October (10) and I want to go back 3 months to July (7), is there an easy way to show this? Here's what I have: <tbody> A B 1 10 <--using "=MONTH(TODAY())" 2 Oct <--using...
  17. B

    Master Schedule: Conditional Format based on Date

    I have a master schedule file to compile projects from various managers. There are four phases with start/end dates. I'd like to be able to enter the dates for the phases, and have the colors change in the cells to the right of the dates based on the entered dates. Is this a stacked conditional...
  18. C

    Power BI Return Max Date

    I have rummaged through posts but cannot get any formulas to work I have a project table that has Project ID's (only one occurrence of each ID) then I have a schedule table that has the same project id's but multiple occurrences for each task that a project has. Each task has what is called a...
  19. K


    HI ALL, I'm planning to use some formulas to return my employee's schedule which looks clean and more simply from a complicated database. Here are what i have in the original schedule @ sheet_schedule for my 3x employee and a formula to return a concise layout @ sheet_result formula in...
  20. E

    Browser Page Refresh: Reflect new data after scheduled refresh

    Hi, Does any one knows if there is a way to refresh the Chrome view of a power bi report in the service after the schedule refresh? (without using Chrome add ins) [ i have a report that is presented constantly on a tv and refreshes once a hour or so, the view does not update after the...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
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 "".
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