intersect

Hi all, Is there a way to get the number of hours intersected by 2 time periods? For example: 09:00 to 18:00 vs 21:00 to 06:00 = 0 hr (no intersection) 18:00 to 03:00 vs 21:00 to 06:00 = 5 hrs (this is from 22:00-03:00) 00:00 to 09:00 vs 21:00 to 06:00 = 6 hrs (this is from 00:00-06:00)...

Hello All I am currently trying to do a 2 way lookup with unsorted data. So let's say that I want to return the value for where the value matches number 4 on my left column and G on the overhead row. So where 4 and G intersect return that value. In this case it would be 700. and the same for...

So most charts plot a positive X and positive Y and look kinda like this: Others have negatives - so the zero point is in the center, where the X and Y axes intersect: Do these two different graphs have different names? Like, if I said I wanted a "transgential interspecular graph", a...

Maybe I am not providing the best search terms, but I can't find a clear answer (probably due to my lower Excel experience) Here is an example. Let's say... I have a table called tbProjectionsBudget that is populated from a SQL query. I have example columns (Item, Proj Qty, Proj Cost, Proj...

Hello, everyone. This is my first post! And I'm also brand spanking new to VBA, so bear with me. First, I'll explain what I'm trying to do. I manage a work order system in Excel and I want to pop up a message to the users inputting new work requests that alerts them if their requested...

Hello, I am new to the forum, and hope someone can help. I need to create a "dashboard" for my end users that will automatically return a result like my sample below. <tbody> A B C D Over_4_Years Over_6_Years Over_8_Years 1 Salary_3 70,000 72,000 74,000 2 Salary_2 60,000 62,000...

Hello everyone. First, I hope I'm posting in the right place. I'm new to the forum. I have a spreadsheet that opens an input box when I double click a row within column F. The contents of the input box is then placed into the corresponding row of column AA when I click OK. (i.e. If I'm in...

For the IntersectRange example for shading overlapping regions in Chapter3, how exactly and where can I see the definition for "Range1" and "Range2"? Thanks

Greetings. I have two cells that are both drop down lists referenced from a Vlookup Table. When One cell is "D11" for the "Group" and the other is "D12" for the "Campaign". When the user selects from the drop down cell what they want, I have 3 pivot tables that should change their filter based...

Hello Mr.Excel board! Today I am working with pivot tables! I'm trying to get select all values of a secondary rows labels. so the pivot table looks something like.... <tbody> Models Drivers Owned Chevy Amy 1 Mike 4 Jim 3 Ford Chris 2 Amy 5 </tbody> I want to...

Hello. I am trying to fill a cells interior color if a condition is not met. The issue is while the columns where I am texting the condition move, the column that I want to fill does not. So I think it the offset that I am trying to figure out how to replace. Thanks Private Sub...

Hello everyone, This is my first post. I couldn't find the right answer I want, that's why I am posting another select multiple range question. I've checked the forum and found couple of methods to select multiple ranges, but none of them worked for me. here is my question: This is my...

Sorry if this is obvious, but I have no idea how to even look it up. I've never done anything similar. I have timecard values on one sheet that look something like this: employee # 1 1 2 2 type ST OT...

Hi, I have the following code that should recognise a value change on a range of cells and then run a simple piece of code to add in a formula etc. However on the range I have given the cells have data validation applied but the user can also free type whatever they want in the cell. What I...

Hi, I'm an Excel 2010 user. Last time I tried to code "Fortran" was being taught but, a lot of it has come back to me. Simplified: through vb code I've created a form with cbobox1 for column header selection (Jan, Feb, etc.) and cbobox2 for row header (wk1, wk 2, etc.). Done. The form also...

Ok, so i haven't been able to find anything like this anywhere. I'm going to have a pareto curve, and basically i want to highlight the tail of this curve (last 20%) using just an insertect rectagle shape with a shading. however my main question is can i have this object automatically inserted...

Hello! I'm trying to make a range selection in a pivot table as per the snapshot below: http://imageshack.us/a/img27/4411/ixaj.jpg The values I am trying to select are the ones that are both red and italic. (Mobile, Other Fix, Fix) from CBU_NA. I've searched and found a way to select both the...

Hello, I am working a new job that requires a lot of Excel use. So far, this site has been incredibly helpful. I'm graphing revenue over time from 2012 and 2013 and I want to know if and when the lines will intersect. The x-axis is dates (e.g. July 1-10) and the y-axis has total revenue (e.g...

Hi, How can I determine whether or not a selected cell is part of a named range? Thanks for any help! Kelvin

I'm using Excel 2010. I have two rows, H and I, that both have data validation enabled using a list. What I want to do is when a value is entered in one of the cells in column H have it be the default value in column I (same row) which can still be overwritten. I have named the two rows H =...