How do I create a levey-jennings chart in excel?

i have a large workbook with several tabs and many formulas. For some reason, even though auto-calc is turned on it will not recalc cell formulas when i...

Hi there, I'm running Excel 2000 and would like to add a new column to an existing pivot table. This would be a new column from the original datasheet. I...

I have a worksheet with multiple dates in a column. I want to count how many cells in that column contain dates for a particular month. Right now I am using...

1270.588235 is correct. You probably have H13 formatted to hide the decimal places, but its value is 42.35294118, not 42 (which would give 1260). Formats...

I would like to know which function is more accurate to use when calculating the IRR for quarterly cash flows. I know XIRR is to be used for irregular cash...

I'm linking to dynamic named ranges (i.e. the ranges resize to include all items in a column based on a formula in the name field) in another worksheet. It...

The override mentioned in the last sentence below does not work in Excel 2003. Can anyone help with this? Fixed decimal: Enter the number of decimal places...

I hope I can get your help please. I want to know how to obtain consecutive data from a sheet to another sheet in the same excel book. I registered data in...

Hi, Is there a way to run the macro from the list of custom formats??What I am exactly looking at is running a small procedure/event macro and add it to the...

I have an Excel sheet with row and column formatting of different sizes and some cells merged. What I woul like to do is to copy the sheet 25 times below on...

Hi I would use a pivot table but there are other restrictions that apply. 1. Some columns are merged and the pivot table doesn't work. 2. I need to do further...

I am summing a row of cells to calculate return mail over a range of days. Each day's outgo number is multiplied by a different return rate (this is...

Try adding the following VB to a button on your master sheet In Cell B1 in Sheet2 put a 1. =========================== Set myRange = Range("A:A") x = 3 y =...

My self-esteem is in the crapper; I simply cannot imagine being "good enough" to help, darn it. Perhaps someone will recommend you try VLOOKUP. -- Greeting...

Hi, I have numerous check boxes in a worksheet that I would like to clear automatically by running a macro. I already have a macro set up to clear some other...

I am trying to take a whole number and decimal and convert to minutes. Production numbers are displayed on report as 1.41 where 1 is 60 minutes, and .41 is 41...

Please help! When working in Excel both headings in the column and row areas are numerical, making it difficult to do simple addition using the SUM feature. ...

Hello, I'm trying to create a formula in a spreadsheet for the date. This is to monitor the shares in the market. How do I make the date field automatically...

I am trying to copy a function from the formaula bar and paste it to each row and will not work for me. Everytime I get something pasted it has added the row...