1. ibmy

    How to structure the formula properly?

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

    Display start time and end time overlapping

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

    Stacked Chart - One series not stacking

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

    VBA Pivot Table Overlapping

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

    Creating An 'Overlap' checker

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

    Total Time Less Lunch Overlap

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

    Column Chart - columns overlapping Y axis

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

    Identify Overlapping Times with Multiple Criteria

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

    Exclude Overlap between date and time in excel and calculate Down Time

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

    catch and report overlap times

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

    Formula To Calculate Dates That Overlap

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

    Please help! How do I create a chart showing overlap of working hours

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

    Two Time Ranges, Count and List of Hours That Overlap

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

    Radar Charts

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

    Comparing two range of dates

    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)...
  16. R

    Comparing two columns using Match Function (Approximate)

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

    Error message- this selection isn't valid. Mske sure the copy and paste areas dont overlap

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

    Formula to highlight overlapping dates within a criteria

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

    Odometer/Mileage Chart with Two Gauges

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

    Plot labels not showing up

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

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