I am using =SUMPRODUCT(--(WEEKDAY(A$5:A$9999)=1)) to count the incidents that occur on a Sunday and =SUMPRODUCT(--(WEEKDAY(A$5:A$9999)=2)) for Monday and so on. They are working great, except for Saturday =SUMPRODUCT(--(WEEKDAY(A$5:A$9999)=7)). I am getting a value that is 9000+ higher than...
I have a formula that works great when the spreadsheet is empty, but when I start adding any data it presents an error.
Is there a way to add iferror to keep the cell blank until the cell has pertinent data?
The first 4 parts work, but none of the rest. Any ideas why?
=IF(ISBLANK(A19),"",IF(A19="tow","Towing",IF(A19="etow","Emergency roadside towing",IF(A19="itow","In house towing",IF(A19="inspect","Inspect to determine necessary repairs",IF(A19=”dot”,"DOT re-inspection fee",IF(A19=”scene”,"Clean...
I recently ran an experiment that required participants to select exactly 35 out of 100 squares on a 10x10 grid. I now need to calculate the mean of all possible pairwise distances between the 35 selected squares on the grid.
I have attached images of a file that has two tabs...
If I add a new column A, that changes all of my other formulas. Is there a way to add a new column (every 2 days) and have it add the new column in the formula?
Example. I have in M2 a formula: =COUNTIF(A$2:C$30,L2)
But, when I add a new column A, the new formula will be =COUNTIF(B$2:D$30,M2)...
John Doe Jr
2 years, 11 months, 5 days
(815) 867 - 5309
If I enter a date in the term column (j2) is there a way to...
I have dates in w24 (start date) and w26 (end date) with the resulting math taking place in w28. Easy enough.
The issue is I need to not calculate the weekends. I tried the workday function, but that isn't what I am looking for... Any ideas?
I have a spreadsheet that has my driver's names (and other data) and another spreadsheet that I use that data for.
When a driver is removed from the driver data spreadsheet, I receive an error on the other sheet...
The formula works well until I remove a driver.
The formula I use:
I am trying to replace "Selection.PrintPreview" with "Application.CommandBars.ExecuteMso ("PrintPreviewAndPrint")" but I am missing the "Selection" component.
How do I preview the selected range with the new print preview window?
I'm stuck in one of the business use case where we need to add duplicate entries in a new custom table from the inputs given in other table.
e.q. consider i have a table with
Now i want to dynamically create a custom table...
Perhaps this is a straightforward one for you experts here....
I'm trying to find the best way of building a product selection tool for around 3-500 Adhesive Tape products. These are quite technical and have many criteria associated with them. For example:
Adhesive Thickness Side 1 & 2...
I am somewhat new to VBA, I have created a userform that will open a word document and update several lines of text within the document before saving and closing it. I know that it is possible to insert text at a bookmark, but I do not currently have the understanding to do this. My code is as...
I'd like to know what kind of formula/what is the formula to have Excel figure something like this out:
D=Scaling(1-100) Like a unit's level
And it will make Q=((A*B*C)+(C*D(also D-1, etc)) like an Arithmetic progression. Where D is Q/((A*B*C)+(C*D(also D-1, etc))
So for the...
I am trying to copy an example from a textbook so that i can edit it for my own use and i have typed out the Macro they apparently used. i Have checked a few time and can't see the error but i keep getting a 'invalid control variable reference' error and can't get any further. I would...
I'm new here so please forgive any of the stupid things I might say :)
I'm trying to create a macro that goes thru all the cells in a row, double clicks them and goes on to the next cell (all the cells already have values in them).
When I record this then this is the code that is...