I'm trying to return the next 05 April from any given date, with the cell A11 holding the date. I was using this:
Which works fine unless the date I'm using is a month less than 4 (eg jan,feb,march,April) as it will then return to me the 5...
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?
I am trying to highlight column B based off of values in column A.
If A has the word parts in it, then I want B to change. I Googled it and seen several examples, I just can't find a way that works for me...
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...
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 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:
Hi, I need help to solve this issue, Like i have to many customer codes and they all have zeros before numbers like,
PAK LAND CHEMIST
KHALID MEDICAL STORE
CHISHTI MEDICAL STORE
im hoping someone can help me with this because i am really struggling.. I am having issue with ".CommandText = Array( _ "SELECT * FROM Consolidated WHERE [Start Date]> '2019-01-01 00:00:00'")"
it seems to be working fine if i do the criteria on brand or anything else.. however it...
Hi All -
Having an issue with copying a worksheet and saving into destination on local drive with the data inside moved with all the equations and data validation - need to copy it only as a read only [No equations, No list] - values only -
On Error Resume Next
strDirname1 = "XYX"...
The columns relevant here are BA,BB&BC although I may put this data on a separate sheet just in A, B & C
The number of cells occupied and contents in BC changes. Which is why I can't press record and be happy.
On Columns BA,BB&BC data filter is applied.
I click the header drop down in BC and...
Hi all -
I have the below code to copy a set of row data from one tab and paste/transpose when a Command Button is clicked on a second tab. How do I edit this so that every time the Command Button is clicked, the data is pasted to the right on the first blank row? Currently, when it's clicked...
Hi all -
I've got the below code to copy column data when a Command Button is pressed and paste/transpose on a different tab. Each time the button is pressed, the data is pasted on the next subsequent row.
Is there a way to paste/transpose the data but keep the original cell formatting where...