overlap

I searched the forums for a similar question and did not see one that helped with this question. I need to know on average how many airplanes are on the ground at the same time during the day. To get an accurate number it needs to look 30 minutes ahead of and behind the departure time and...

Hi, I'm having a problem with this code. I have the formulas right and the filters aswell, the problem is although I select only visible cells, the formulas are overlapping each other and I'm losing the ones that I wrote before. Is there any way I can concatenate formulas or just select the...

Hi everyone. I am new on the forums so please point out any error I make in the process. I work with Excell 2010 SP1 on Windows 7. I need help with finding if any 2 horizontal sets of numbers next to each other overlap with other sets in same two columns. Numbers are cumulative times group of...

Hello! Excel version: 2010 I'm trying to compare a value range from a unit in a table with every other unit in that table to find out if there are any overlapping value ranges. The range to compare consist of a minimum value and a maximum value. If one or more range overlaps are found, the...

I'm looking at a consortium of databases which are all representative of the country (little to no skew in each database). Adult population in the country is 48m. The databases in order of size: 19m 12m 4m 4m 4m 3m 1m 0.5m 0.5m I'm trying to calculate the net number of records I'm likely to...

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

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

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

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

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

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

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

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

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

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?