overlap

Hi, My objective is to identify (assign "1") the current row (interval) if it overlap from previous rows (intervals). I have found the formula (thanks to these 3 sites : #1 , #2 , #3) but the problem is when there is a row (interval) that do not overlap (stop assign "1") and start new identify...

Hi Everybody, I'm new on the board. I have a problem with ovelapping time and impossible to find a good solution. I need to display the start hour and end hour of overlapping. Bellow a sample: The "What I need" column, is what I need ;) The row 2 is the reference time for overlapping. The...

Hello, I have a combination stack columns with line chart. The stacked columns being hours worked and the line being hours available to work. The data sets being stacked are hours worked per discipline. The problem is one data sat is not stacking on top of the other data sets. It's gone rogue...

Hi, I've found the below code to display overlapping pivot tables, which will look at every pivot table in the file and then it will pop up messages where the overlapping pivot tables are. Can someone please update the code to make it so I can select the sheet that to code checks (I was...

Hey, I need a way to calculate overlap between Groups but not within the same group. I need to make a template where a user can input the group name and the Numbers associate and have a easy checker to see if there is any overlap between the groups. Ideally there is a Button which runs a Macro...

Hello is there a way to adjust the formulas in Column I so that if the times overlap the lunch break (12 pm to 12:30 pm) it deducts that time? I have the Lunch In L12 and Lunch Out L13 if that matters. So it should be a 30 minute break. The result of the new formula would then be I5 2.5...

I have eight data points in a column graph, ranging from -13.9% to +4.5%. The Y axis of zero is in the middle of the chart. The columns overlap the Y axis, and this overlap grows as the column width is increased. At a 1 column width, there is no overlap. At a width of 5, there is a light...

I've been struggling to find a way to identify pairs of entries for which at least of portion of their time overlaps. To make the challenge more difficult, I need potentially overlapping entries to meet multiple criteria before they are determined to be overlapping. I have two fields for...

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>#DAE7F5[/URL] "] A B C D E F G H I J K L M </thead><tbody> 2 SN. #B4C6E7[/URL] , align: center"]A #B4C6E7[/URL] , align: center"] DT #FFFF00[/URL] , align: center"]Actual DT...

Hello, I have a table like bellow. How can I use excel formula functions to have another column/columns that puts corresponding "Course" name/names if there is/are overlap/overlaps? Thank you <colgroup><col width="64" style="width: 48pt;" span="5"> <col width="78" style="width: 58pt...

Morning all, Another little piece of help required please, this time regarding dates/times that overlap. Example Data: I need to calculate the number of days overlapping within the data for each unique Name. <tbody> Name (A) Start (B) End (C) Dave 08/02/2018 09:00 08/02/2018...

Hello, I'm needing to create a chart with the ability to show where there is overlap in hours worked. For example, if an employee is working several places and the hours logged at each place overlap (thus the employee is fraudulently claiming time at once place that they're not actually...

Hello, I have two time ranges that are somewhere between 0-24 (this can loop around as well, such at a time that starts at 17 and ends at 6). I need to be able to have excel tell me what hours overlap between these time ranges, and also tell me the total number of hours that overlap. The data...

Hello, How do you move labels on a radar chart? I have 45 "Pie" slices that have a description for each and they are illegible at twelve and six o'clock positions. The labels overlap each other. Is there a way to separate the labels a bit further or change their axis to be radial instead of...

Hey everyone, So I have a bit of a conundrum with a code I've been working on. So currently I have this code running: Option Explicit Public SelectItem3 As String, pos3 As Long Private Sub AddDate() Dim b As Object, RowNumber As Integer Set b = ActiveSheet.Buttons(Application.Caller)...

I am trying to compare two columns, each of which contain company names. The list is over 6,000 rows so I would like to use a function and drag it down. Normally, you would use the Match function, but the problem is the company names are slightly different. Example: Column A...

Getting this message when trying to create a name from a selection. I have not copied anything.

Hi I'm struggling to adapt a formula I currently have which helps indicate overlapping dates. I need to adapt this into a conditional formatting technique please. The table below shows an employee's employment record in a company: <tbody> A B C D E F 1 2 Record Start Date End Date...

Hello, I am trying to create an odometer chart which I've successfully done using one of several online posts on this topic (combining a doughnut and pie chart). However, I'd like two have two 'needles' on my chart. I've added a second pie graph to do this but the problem is, my needles won't...

Hi, I have plotted a 2 x 2 according to the instructions here: How to Create a Static Four Quadrant - Matrix Model in an Excel Chart | Critical to Success ...but I'm encountering some problems: 1) Not all of the labels are showing up for all of the dots on the map - any idea why this is...