availability

  1. J

    Macro for checking if articles are online in an onlineshop or if a 404 error code appears

    Hi I have a list with a lot of URL adresses of articles where I would like to check if the articles are actually in a specific onlineshop or if a 404 error code appears. It would be great if excel would show the value 0 if the article is online or the value 1 if an error accurs. Here is an...
  2. L

    Create Matrix, exhaust the excess funds and avoid circular references

    Dear All, below is by far the most complicated case I've ever encounter. Hopefully, that is not the case for you and you will be able to help me solve this. Table 1 and 2 are supposed to be Matrix of Stand Top Tool Type and Stand Code Description. Table 3 is the data set where the relationship...
  3. R

    Alternate column alert

    Hello, I have a data, basically to count product availability per day. I want to put an alert or something like that on the first 2 column for example in column B, that if there's any of the product on any given day is less than 5 then it will list all the dates that are on low availability...
  4. C

    Help needed with INDEX MATCH

    Hi guys I am trying to do an index match only some of the cells that I am matching against are in a merged cell. Would this make a difference? Column B Column C Forecast 5000 Sales 4800 Waste 4% Availability 98% So...
  5. S

    How to set rules/criteria in a excel report

    Hi all, Currently I have an excel tracking file to keep track of the trainers’ availability for a list of scheduled programmes for the entire year. Based on their availability, I have to go through each programme one by one to match and see who to deploy. Typically for each programme I will need...
  6. S

    Conditional Formatting - Highlighting calendar dates

    Hi there: I'm having difficulty trying to figure out conditional formatting. It's probably simple, but I just can't get the rules laid out properly to work for me. I have a calendar on the right side of my spreadsheet. I highlight the whole month. I have 3 columns on the left of the...
  7. M

    SharePoint & file with code/userforms

    I am developing a file that will need to be used by only 2 people at the same time but the file contains code and userforms. The file will consist of the following sheets Drivers Master List Driver List Availability Master List Availability List The initial data will be added via a userform...
  8. S

    Refer to Sheet title in Formula

    Hello Friends, I would like to reference the name I give worksheet in a formula. The Situation: I am creating a weekly review chart for a dynamic sales availability: how much of each product we are projecting available for sale in the next 18 months. The Availability is generated in a...
  9. R

    Agent schedule based on timestamp

    Hello guys, I've been struggling lately to find a way to show up on a wallboard what was the availability of our agents during a day based on their timestamp statuses. I am using Cisco UCCX and I can get a report named Agent State Detail which provides me agent name, Time when status change...
  10. E

    Room Availability Testing - Help please

    My self and a colleague schedule a training plan for our business on a national scale. We are trying to streamline the processes by building the facility to check the availability of rooms based on a date variable we enter. Our issues is that a training room will be used for multiple courses at...
  11. A

    New To Excel

    Hi is there anyone who has a spreadsheet for scheduling employees that can also limit availability. I want to be able to only be able to schedule the staff for any given shift according to when they are available. For instance, Employee A, is available not available Tuesdays or Fridays and can...

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