overlap

  1. M

    Index & match overlapping data

    Hi experts I have a set of velocity speeds for soils and rocks and I'm using an index and match formula for these speeds for data I'm importing. The formula is =INDEX(H28:H45,SUMPRODUCT(--(I28:I45<=D7)*(J28:J45>=D7),ROW(I28:I45))-ROW(28:28)+1) The reference table H28-J45 is shown below...
  2. J

    VBA to reposition data labels on a bubble chart so they do not overlap

    Hello Mr. Excel, I'm new to the forum and a relative VBA novice. I have automated the production and export to .png file of multiple bubble charts based on a dynamic SharePoint list. These charts can then be lifted into Access to overcome the problem with the dated chart engine. My issue...
  3. A

    need to add something to macro delete checkboxes to prevent overlap

    Can someone help me add to the macro below to delete checkboxes with the row that is being deleted? The row is deleted per the macro, but the ticked checkbox transfers to new sheet. Sub EndofCycle() ActiveSheet.Copy After:=ActiveSheet Columns("AS").Select Selection.AutoFilter...
  4. D

    VBA to insert/delete rows when expand/collapse overlap pivot tables

    Please help me with code that inserts or deletes an appropriate number of rows when expanding or collapsing pivot tables that would otherwise overlap another pivot table when expanded. I have several pivot tables stacked on top of each other on one sheet, all with the same column headers...
  5. M

    Count number of date ranges that have a specified number of overlaps

    <!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:HyphenationZone>21</w:HyphenationZone> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>...
  6. J

    How to calculate overlapping hours between departments

    Hello, I have an employee working 37 hours per day by accident, (even though there are 24 hours) I used military time. Column A is the month/day/year Column B is the Department 1 In Time Column C is the Department 1 Out Time Altogether there are about 15 departments with In and Out times...
  7. J

    Overlapping hours more than 37 hours paid in a 24 hour period

    Hello, this is my first post. I need some help. This is a problem to be solved and it has been awhile since I had to calculate something this complex. The sales person is in a store working but the time sheets show more than 24 hours per day, up to 37 hours working and paid for. The scenario...
  8. E

    Overlapping times for staff

    I am having a hard time finding anything that specifically addresses my situation. I have staff that work with clients. Typical shifts will be on a single date, but occasionally, hours will cross midnight. Service codes can vary, and staff may work 12pm-5pm with one service and 5pm-8pm with a...
  9. S

    Overlap text into adjacent cell

    I am using an IF formula to return a text string if conditions are satisfied and return a blank cell "" if conditions are not satisfied. My problem is that the when the text is returned from the formula, half of it is cut off by the adjacent cell because excel does not recognise "" as an empty...
  10. P

    separating bars on two-y axis graph

    Right now, the bars corresponding to each y axis are overlapping, primary axis in front of secondary axis. I want them to be side by side. Can anyone help?

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top