please help

  1. S

    Next 5 April from any given date in Excel

    Hi All I'm trying to return the next 05 April from any given date, with the cell A11 holding the date. I was using this: =IF(MONTH(A11+1)=4,A11+1,DATE(YEAR(A11)+1,4,5)) 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...
  2. HeRoseInThree

    Counting the incidents that occur on a specific day of the week

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

    Is there a way to paste and match the destination formatting by default?

    This would be helpful. Thanks in advance!!
  4. HeRoseInThree

    I'd like to highlight all duplicate cells, while ignoring empty cells

    Is there a way to highlight all duplicate cells while ignoring empty cells? I have my data in s12:y31 THANKS in advance!
  5. HeRoseInThree

    adding iferror to an established formula to avoid #N/A error message

    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? O2#N/AO2O2=IF(ISBLANK(A19),"",VLOOKUP("tow",A$19:B$38,2,0))
  6. HeRoseInThree

    Conditional formatting cells in column B based off of values in column A

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

    If formula, with a twist

    I have an if formula that has a variable. I'd like to search for a keyword (diesel) and if it is found, return a string. I thought about IF(F23="*diesel",S$33 but that didn't work. Any ideas?
  8. HeRoseInThree

    The first part of this formula works, but not the rest.

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

    Adding new columns and keeping the old formulas

    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)...
  10. HeRoseInThree

    I don't know what to call it. That's why I cant Google it : )

    First Name Last name Suffix Complete name Last, First Phone DOB Hire Term SSN Tenure Phone SSN Age john doe jr John Doe Jr Doe, John 8158675309 5/21/73 11/28/2017 123-45-6789 2 years, 11 months, 5 days (815) 867 - 5309 6789 47 If I enter a date in the term column (j2) is there a way to...
  11. HeRoseInThree

    Rolling duplicate columns

    Every couple of days I add data to column A. After I do, I insert another column A. I would like to see, if at any time, i have duplicate data in 3 consecutive columns.
  12. HeRoseInThree

    Help counting unique numbers

    Hello. I would like to count my data in column F, but only each unique entry. If I have multiple examples of a particular number, I need to exclude those. Thanks in advance
  13. L

    I’m trying to find a match from 2 columns against another 2 columns

    Hi I want to see if column A+B can find a match against columns D+E Any help would be appreciated Thanks
  14. HeRoseInThree

    Data refresh question

    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: ='[N&I...
  15. F

    How we can remove zeros before numbers?

    Hi, I need help to solve this issue, Like i have to many customer codes and they all have zeros before numbers like, <colgroup><col><col></colgroup><tbody> Current Shape Required 000003 3 PAK LAND CHEMIST 000005 5 KHALID MEDICAL STORE 000006 6 CHISHTI MEDICAL STORE 000025...
  16. R

    VBA to ms access query date not working

    Hi 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...
  17. M

    VBA Copy/Paste Worksheet

    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"...
  18. T

    How to filter out #N/A Column BC in VBA

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

    Transpose data - offset data one column

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

    Transpose data - keep original formatting

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

This Week's Hot Topics

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