thanks in advance!!!

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

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

    This would be helpful. Thanks in advance!!
  3. 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!
  4. 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))
  5. 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?
  6. 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...
  7. E

    Participants selected 35 out of 100 squares on 10x10 square grid - Need help calculating mean of all possible pairwise distances between 35 squares

    Hello everyone, 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...
  8. 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)...
  9. 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...
  10. HeRoseInThree

    Count business days that have past - not weekends

    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?
  11. 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...
  12. A

    Trouble with Print Preview

    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?
  13. M

    How to add rows to a new custom table based on values in other table? Options

    Hello, 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 Subscriber Effective_date Expiriation_date Service_Code Now i want to dynamically create a custom table...
  14. S

    Building a Product Selection Tool With Excel - Advice Please

    Hi, 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...
  15. A

    Insert text at a bookmark via VBA

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

    Unsure of How to write this equation

    I'd like to know what kind of formula/what is the formula to have Excel figure something like this out: Say A=7 B=12 C=30 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...
  17. J

    'invalid control variable reference' error

    Hi all, 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...
  18. L

    Keyboard shortcut for highlighting cell

    What is the keyboard shortcut for highlighting cell? Can a frequently-performed task be assigned a keyboard shortcut by user? If it is done by VBA, please post the code. Thanks.
  19. L

    Excel table auto-sorts while updating!

    How to design an excel table that auto-sorts while updating? If VBA is the only option, please post the code! Thanks.
  20. J

    Creating a Macro that double click a cell

    Hi All! 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...

Watch MrExcel Video

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