step

I am working on a project where I am trying to add up times and dates together. Below is the data that I am working with. <tbody> Steps Time Length (Days) Time Length Converted to (H:MM) Step 1 0.33333 2:40 Step 2 2.16667 17:20 Step 3 0.33333 2:40 Step 4 0.29167 2:20 Step 5 7.97917...

Hi everyone, I am hoping someone can help me out - I am new to EMG analysis so I know I am already behind the 8 ball but my advisor wants me to use the butterworth filter in excel. First I only have mac computers so I had to borrow someone's computer to download the add in but now I can't seem...

I am stuck with a VBA code and badly need your help. Here's what I am trying to achieve - Step 1 : I have to iteratively capture strings in column D (the count of which is mentioned in C2 which will change depending on the data set) - Done Step 2 : Each of these strings will be split based on...

Hello, I am attempting to create a step plot while using the following data shown below. I have been unable to so far because my x-axis values are not dates. <tbody> x-axis y-axis 0 25.85 0.67 25.85 0.67 -63.69121262 3.68 -63.69121262 3.68 44.58121262 4.35 44.58121262 4.35 -6.74...

I'm using this to replace the subject in an outlook message; Item.Subject = Replace(Item.Subject, " - IMPORTED", "") Can someone show me how to take it a step further and remove not only the above but any text after 'IMPORTED'?

Hey Guys Looking for some help as not that expereinced with VBA, i've created a consent form for clients to fill in and that data then gets recorded, there are several pages and each step is recorded step by step as to stop it all being down in one go, i found this was a quicker way to do...

Is there anyway to amend the below code to allow it to work in multiple worksheets. Also can it be amended to work as soon as data is input the the sheet rather than the use of a command button. Sub Macro4() 'Step 1: Declare Your Variables. Dim LastBlankRow As Long 'Step 2: Capture the...

Hi forum, I'm new here and I've been having a problem to do a 2 step search. Let me (try to) explain: I've got 2 tables I need to compare Table A (30 records) name, Street, zip, town, Value 1 Table B (50000 records) name, Street, zip, town Step 1 - Compare the following to narrow it down...

I have a list of nodes (List B in col A) and corresponding temperature in Col B. List B in Col D is a subset of list A. In cell E2, I used the Index+Match formula to find the corresponding temperature. The formula is =INDEX($B$2:$B$6,MATCH(D2,$A$2:$A$6,0)). I copied this formula down to cells E3...

Hey guys, hoping I can figure out if this is possible to do. So basically I'm constructing a sort of project manager buy breaking down the steps. The below table is an example of what I am trying to achieve. <tbody> Priority Project Step #1 Step #2 Step #3 2 Education >> Reading >> Think...

Hello all I hope you can help me on this please I want to change this code so that it delete all row NOT equal to "INS" instead of deleting "INS" Any ideas please arrWords = Array("INS") xlCalc = Application.Calculation Set rng = Range("c1:c2000") For rw =...

Hi to all, I want to identify the last confirmed yield and operation activity from the same Order. Some times the balance not complete the last step. So I want to know in wich step is the balance. Order: 215775959, Last Balance = formula?? <tbody> Order Operation/Activity Operation...

Hi to all, I want to identify the last confirmed yield and operation activity from the same Order. Some times the balance not complete the last step. So I want to know in wich step is the balance. Order: 215775959, Last Balance = formula?? <colgroup><col width="72" style="width: 54pt...

Dear all, I am trying to merge 2 queries. They both have unique numbers but whenever I link the two queries, duplicate rows appear. Not after the step "Merged Queries", but after the step "Exapended [name query]" ... I am desperately looking for the cause or a solution to my problem. In 1...

Hello all, I have a folder that averages 100+ excel files per week that I need to print. However, I need to be able to print them in order based from a list in Excel (either by file name (column A) or a sequence number (column D) ) not the order they are found in the folder so I don't have to...

I've created a formula by concatenating multiple cells which each contains pieces of the overall formula. Once I have the full formula concatenated in a cell I do a copy paste special - VALUE so it will create the text of the formula and eliminate the concatenate function. Once I get to this...

Hi All, I'm having a problem when trying to import an SQL stored procedure into excel 365, Step 1: Data tab –<wbr style="box-sizing: inherit;"> > From Other Sources -> From SQL Server Step 2: Enter Credentials. Your server name can be an IP address Step 3: Choose any old table or view. Pick...

Hello, In column C, I want the following action: forward calculation if the criteria is met but reverse calculation if other criteria is met. This is a two-way action. <colgroup><col span="7"></colgroup><tbody> if from dept = "Step 1" & to dept ="Step 2", then QTY * WEIGHT if from dept =...

im new on vba guys.. i wanna ask, hot to add mouseover effect colour on that shape (when i move my mouse there the colour change to white or something) can someone help me how to do that step by step.. thanks before

I have the below program for delete row if specific value content in column . but it getting too much time for running . I want to run the same program but take less time. Also help me for the run that program for different sheet (Sheet2) Sub DeleteRowContents() last =...