Search results for query: *

Hi Skip, Yeah, so those are some of the issues I'm facing, that's why I'm thinking there might be an alternative. So the two rectangles, which are linked to two values in two cells are expected to be contained in one cell. The size of the one cell for each customer that contains both...

Hi everyone! I am trying to build a table in excel (2010). Ultimately, I would like to be able to have two rectangles within a cell that automatically resize based on different numerical values. The tricky part is, I would like to autoshapes to fall within one cell and not overlap. I have my...

Skip - just did a test run. Set the amount at $100. Effective date 1/1/2013 and completion date 2/1/2013. For some reason the formula is pulling in 94 and then 6. I am pretty sure it should be 97 and 3 based on 31 days in January and 1 day in Feb. Does this sound right to you?

Perfect, you rock!

Skip - I tried to conform to the way that monthly/quarterly results are reported and hard coded the dates. I used the formula provided but think I did something wrong. So for the first amount ($199,185), it should start to contribute for part of September 2012 (first day of revenue is the 20th)...

Thanks Skip. That worked for the dates. This is what the data looks like. I think I may need to calculate the number of days in the month in order to get the contribution for each month. The data below starts at A1 (Customer) Customer Amount Effective Date Completion Date OSS $199,185...

Hi all, I have an excel sheet that has a number of invoices that include dollar amount and the start date and completion date. So one is $200K and it goes from 9/1/2012 to 9/1/2013. If I divide the amount by 12 then I figure out the monthly contribution. However, I don't know how to automate it...

Great, thank you! I was just informed my company is upgrading to a newer version. :)

Hi all, I have been moved over to Lotus Notes 6.5 and I am trying to create an agent to forward an email with a certain word in the subject. I have successfully created an agent to do this but when it forwards the email it does not include the subject line. However, everything in the body of the...

I realize I posted this in the wrong forum- sorry.

Hi all, I have been moved over to Lotus Notes 6.5 and I am trying to create an agent to forward an email with a certain word in the subject. I have successfully created an agent to do this but when it forwards the email it does not include the subject line. However, everything in the body of the...

Understood, I think I have it. Thank you.

Ok, I deserved that response... There is no problem. I dont doubt your or my ability to drag and fill right. I was actually trying to limit the amount of user interaction within the sheet. I just didnt want someone to forget to fill all the way and then end up with an incorrect number. A...

Hi all, I am having trouble trying to figure this out. I have cell A1 in sheet 1 which contains data going through column BA1. I have another sheet called sheet 2 that I have linked to cell A1 in sheet 1. Within sheet 2 I would like to be able to link to the other columns in sheet 1 with...

Thanks everyone!

Hi all - I am trying to make this formula a little easier - it currently works but it is kind of long. Does anyone know of a way to shorten it up? Oh, I have to have the ISNUMBER check in it... Thank you =IF(ISNUMBER($O168/AF168),(IF($O168/AF168<0,"-",(IF($O168/AF168>50,"-", ($O168/AF168))))),"-")

Yes, I tried setting the fill color to none but that makes all the bubbles clear. I would like to have some color with transparency. I think it's an excel 2003 issue. I can't believe MSFT didnt think about that. Oh well. Thanks for the help everyone.

2003 - SP 3.

Does anyone know if there is a way to make the bubbles in a bubble chart (within excel) transparent? I have searched and tried to mess around with this myself and have had no luck... Thank you.

I forgot to mention that the date in my post is not accurate, there are currently 17 days left in the quarter, my bad. Actually, now that I think about is there a way to pull number of "working days" in the quarter? I think that could be more applicable than just days in the quarter. Thanks again.