include

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

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

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

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

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

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

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

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

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

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?

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

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

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

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

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

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

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

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

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?

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!