gap

I have an Excel question, in the example below I have a very long list of dates times where I added a column to calculate gaps, and tagged rows where the gap were less than 15 minutes to try to determine a possible consecutive activity. Do you have any idea how to get the groups of tagged rows...

Hi, Is there a possible way for my requirements? it would much grateful if I get any help. Row reference based on the lookup and return lookup values according to my conditions Column B2:J2 contain as a text A,B,C,D & E and corresponding to the code ( B3:B7, C3:C7, D3:D8, E3:E7 & F3:F7)...

Hi all. I have the following problem: I have a table and for each record there are multiple date fields. Here is a brief example (these dates use the British format of Day/Month/Year): <tbody> Date1 Date2 Date3 Date4 Date5 Date6 06/09/2017 03/11/2017 06/10/2017 28/09/2017...

I had an if condition written and it worked just fine, but I want to add to it a condition that will allow the code to stop a couple lines before the end of the code, but the else if won't work. I keep getting an error saying "Compile error: expected: Do or For or Sub or Function or Property"...

Hi Guys, Really looking forward to your help with this one. I needs to combine cell data and have a comma spacing between them. however I don't want empty cells to merge. For example, <tbody> 1. Apple 2. Tomato 3. Banana 4. Apple 5. Apple 6...

Mr.Excel, I am in a major time crunch from a customer. I have csv files that contain over 40k rows of data each. I need to adjust the data to the customer. Example raw data: <tbody> time ExternalProductionNumber InternalProductionNumber Model MeasurementPointIndex Name Gap Flush 2/21/2018...

Hello all, First post here. Looks like a great community! I'm pretty new to coding macros and I'm having trouble figuring out how to code a loop that works for my specific scenario, described below: I've been tasked to create a macro that checks for gaps in production time by employees. The...

Hi, I've been struggling with this for a while, but I am trying to do a Opportunity Gap calculation within the pivot table. Below is how i have my data laid out. I am able to calculate $% Change, Retailer's Share (TY/LY) and the Share Point Change all within the Calculated Field portion. But...

Hello All, I have a template in excel with Header and Footer, I need that template to be saved in pdf format. I'm able to save the template in pdf, but when I do this my Header and Footer does not fit the whole page. My Footer leaves some gap in left and right margin, also there is a gap...

I am trying to move an array based formula from a worksheet into a for loop in VBA. I currently have a list of from dates in column A and to dates in column B. These dates represent where an employee lived during a period of time. I have a formula in column C that shows the dates if there is a...

Hello all, I need some assistance with this formula - I have a sheet that calculates a gap between two given values, and then represents that gap against one of the values as a percentage. Example: Value 1: 1000 Value 2: 700 Gap (Value 1 - Value 2): 300 Gap %: (Gap / Value 2): 43%...

I've reduced both to 0% gap...yet, the bars still show a slight white sapce between them...theyre not touching....someone please help!

Hi all, I have a very simple spread sheet I have to look at daily and I wondered if anyone might be able to help me with a formula or macro which can save me endless hours working things out? Basically, I have a stock report which I am looking to create a line of balance for. A1 - TODAYS DATE...

A1=start from 10.000 A2=end from 150.000 IF C1=10 D2=10,D2=20,D3=30....UP to 150 values should appear in D column iF C1=20 gap should be 20 D2=20,D3=40....up to 150 values sjould appear in D column

I have a column of data with gaps in it. I want Excel to copy the value at the top of the gap filling the gaps below, eg. 013 015 016 So between 013 and 015 I want to fill in 013 and between 015 and 016 with 015. It is a very long column with loads of gaps. I just wonder if there is a...

Hello Experts Today, I stuck with a different problem, I need to calculate numbers of days between 2 dates and also calculate the gap of days in yrs also. <colgroup><col><col><col><col span="2"><col span="2"><col></colgroup><tbody> See the below example <tbody> <tbody> Start Date...

Hi, I'm using a Mac. I have a cell one column wide by 11 rows long (merged). How can I fit a picture exactly inside the cell so there is no gap between the picture and the cell border when printed? I have tried using the ALT and CMD keys to drag the picture in place but the document still...