include

  1. A

    Multiple Account Drawdown

    I'm struggling with how to write a formula that sorts by individual accounts and dates to calculate drawdown. Any help would be greatly appreciated! I was calculating drawdown by this formula =$A$2:A2/MAX($A$2:A2)-1 but that does not include date and it really needs to be in order. I'm not even...
  2. E

    VBA autofilter 1004 No cells were found

    Hi, I'm using Excel office 365. Weekly I import data into Excel then filter out certain items based on preset criteria. I do this using auto filter and a simple macro to delete the entire row. So for example, my import might look like this: <tbody> Date<strike></strike>...
  3. K

    Include VBA Code if you want a sheet protected without using a password

    This for us learners (newbies to VBA) I learned that if I include the below after writing my code and before 'End Sub', my worksheet will go into protected mode after the code is ran. ................................................... ActiveSheet.Protect Contents:=True End Sub...
  4. S

    Need Help Sending automatic emails depending on cell value

    Hello Ive, got a spreadsheet where column C is a list of drop down list of our curriers, and i want to know if its possible for it to send automatic emails when one of the cells is updated to a certain currier (in this case a currier called gopher) if so is it also possible for it to include the...
  5. Sean15

    How to make SUBTOTAL formula range to automatically extend to include newly added rows

    Hi: This formula: =SUBTOTAL(9,I2:I4489) does not auto extend to include newly added rows, example of I added row 4490 Could you help please? Regards, Sean
  6. W

    Mean between 2 lookedup values

    Hi everyone, I have a 2 row data set with over 100 cells. The first row contains time values, the second row a numeric value. I have to find 2 given time values in the first row, and the I need to get the mean between the numeric values under the found values. But here is the tricky part: the...
  7. synergy16

    date range routine

    Good afternoon everybody. i have a form that runs off some search sub functions in VBA code that i wrote, that include various ways the user can search results from an excel sheet. the excel sheet has 3 columns that are populated with various dates. i would also like to include a search by...
  8. K

    Visual Basic - Numbering Format

    Is there a way to set the number format within a macro. Currently I am having to change the formula to include & "00" (and change it to & "0" when the number of sheets goes into double digits), the format I need it to show is "AAA_001" which increases by 1 each time. See below. If I don't...
  9. R

    Adding cells dependent on selection in another cell

    My destination cell is U9. Users have an option to place an x in P9, Q9, R9 and/or S9. The can select as many or as few as they wish. If they place an x in P9 I want the value in U9 to include the value in D10. If there is an x in Q9, include/add the value in G10. If there is an x in R9...
  10. J

    VBA if Save Fails then saveas

    Hi, I have thisworkbook.save in some of my macros though if save fails I would like to saveas in the same folder.... Same file name but include V2, V3 etc.... What is the best way to do this?
  11. C

    Formula to first find and then sum

    I have a workbook with tabs 1 - 31 representing the days of the month. On each sheet we have employees name, ID, start time, date, and Comments. I currently have a Summary sheet that pulls over the ID and Comment, if any. What I now need is something to total, if a person (ID) has a comment...
  12. S

    How to include an integer variable in a workbook name VBA?

    Greetings, I would like to be able to include a variable value in part of a workbook name. The line of code requiring a variable value (the workbook name changes each time the file is accessed) is below: Set GLD = Workbooks("GLD_US_archive_EN(integer variable goes inside the brackets).csv")...
  13. A

    Logic question with Countifs function

    I have the following formula working: =COUNTIFS('Detailed Incidents'!$D$2:$D$1000,”New Jersey”,'DetailedIncidents'!$I$2:$I$1000,”Newark”,'Detailed Incidents'!$B$2:$B$1000,”January*”,'DetailedIncidents'!$B$2:$B$1000,”*2018”)) But I want to include if another corresponding column hasANY of the...
  14. R

    Get the weekday

    Hi We have job requests that come in a specific format. Most of it is fine, but we would like to change the start and end dates to include the days of the week. The current format is; Ref: HH65161651 Job role 12345 | xxxxxx xxxxx site xxxxxxx Rota: 21:00-09:30 238073 From - 18/01/2019...
  15. G

    Calculating next 5 business days excluding holidays

    I'm trying to do follow-ups by calculate 5 business days between two columns and does not want to include holidays for ex: Entered Date 5 day FU 12/17/2018 12/24/2018 (did not include Christmas and weekend) 12/24/2018 1/2/2019 (did not include New Years or...
  16. G

    VBA Code to prevent inclusion of external links in the Workbook

    Hi all, I hope you can help me with this. I need a code to prevent that any external link or reference can be included in my Workbook. For example, I have my Workbook "Master" and someone wants to include in it a reference from another Workbook called "Country", let´s say in tab "Data", cell...
  17. G

    Insert word file object at bookmark

    Hello, I am trying to insert a word file at a bookmark in Word (through Excel VBA) but I cant seem to get it right. It keeps pasting the document contents (badly formatted) where I want to just include a copy of the file. The line I cant get right is Bolded for ease. Sub CreateContract() Dim...
  18. S

    Create a list from earliest to latest dates based on another cells value

    Good morning I have a formula SMALL(Master!$O$4:$O$275,P41) - What I am looking to do is have it based on Column V - so if V is empty I want it to include it, however, if it has a value, I want it NOT to be included in the list Many thanks
  19. R

    Conditional percent rank

    I have a date column and a column that states "Include" or "Don't Include." I want to calculate the Percentile of each row in my data set given that they are marked to be included. Any thoughts on how to group them?
  20. M

    COUNTIF question

    Hey, I am using COUNTIF to count how many times a certain line of text appears in a column which includes about 3000 rows. I want to extend my search to include an additional column but can I write one formula to include two columns? Thanks!

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top