coverage

Hi all, I have got an interesting problem . I have got a sample Data below: <tbody> A B C D E F G H I 1 1 2 4 4 1 2 2 3 4 2 13 3 5.5 </tbody> I have got a target number in A2. I need to find how much of the range A1:I1 that number would cover. Each cell in the range...

Hi folks, very new to Excel and need to do a chart that im not too sure how to do, although im sure its possible with how exceptional of a program this is. Basically, I need to do a chart (bars probably easiest), that would have Sunday to Saturday along the top and opening hours along the Y...

I have client in column A. Coverage in column B. Location in column C and Income in column D. I'm hoping someone can help with the formula for column E. In column E, I want to sum everything for Client A as long as the combination of Client&Coverage&Location doesn't already exist. If that...

Hello, I have another issue while finishing my excel workbook. I am trying to compute coverage for a specific number. I finished my code but then I realized, that I am actually comparing the same rows in different sheets, while I need to compare matching rows and columns by a corresponding...

Today I use this function to calculate months of coverage =coverage(Cell that holds inventory, range of cells that have the monthly forecast) =coverage(F7,G5:I5) I want to use a function that does the same thing, but with value in the function such as : =coverage(1000,500,250,150,50)...

I call this function to calculate current months of coverage. It compares 1 column (Inventory ) to a range of cells ( future forecast ) and give me a current month's of coverage: Function coverage(inventory, forecast) Application.Volatile For Each c In forecast inventory = inventory -...

Hello Buddies, I have come up some typical problem of preparing the planning/procurement sheet. My procurement planning is based on seasonal medicinal herbs, when was preparing the sheet, I have stuck with from next coverage month to till next season starts, what is the gap in terms of...

hello everyone, I am trying to calculate the stock coverage in numbers of months and I haven't figured out how to do this without a macro.:confused: My data is something like this, with stock available only for the current month and I would like to see how many months would this figure would...