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