For example, the cell I need to repeat is A1 ie MS, the number of times to repeat is 20 times ie B1 and the result in column C, ie automatically filled with...

Hi, I would like to ask you whether you know an excel addin for interpolation a missing maturity in the yields? For example I have the 5 and 7 years and would...

I've try associate IF OR AND all toghether like IF cell A4 1 AND ( cell A5 = "AAA" OR Cell A6 = "BBB" ) Then ... but not with sucess I...

hi! if i make a constant amount of deposit on a periodical basis for a certain period at a given rate of interest what would be the final amount i get.? for...

Complex functions like VLOOKUP need better examples. Specifically, all examples shown use a multi-column cell range reference for the table that start with a...

Hello How can I disable excel when copying from exp. Cell C4 and past special formulas into C5 that copy the same cell number exp C4 and not C5. p.s. –...

example data: a1 b1 c1 d1 e1 f1 S-213A 10/19/2006 60. 10/20/2006 S-213A S-213A 11/3/2006 ...

I do not seem to have all functions with the Excel2003. For example INTRATE and EFFECT is not there when I try to insert a function. How to I get these...

2008 Australian Excel User Conference - Sydney, March 12-14 Sydney, Australia will host the first Australian Microsoft Excel User Conference (Holiday Inn...

An Excel file sent to me used a YMD date format. Since then, all my old and new Excel files default to the YMD format. Selecting a cell, a cell range, or a...

How do I underline every third row in an Excel 2007 worksheet?

SUMPRODUCT(--(YEAR('Budget Expense'!$D$3:$D$10393)=$A$1),--('Budget Expense'!$E$3:$E$10393=D$2),--('Budget Expense'!$J$3:$J$10393=$A19),'Budget...

example data: a1 b1 c31 d1 e1 f1 S-213A 10/19/2006 60. ...

Here is my conundrum: I am trying to make a list with five fields such as: Person : Dollar Amount : Date : Type On a seperate sheet in the same workbook I...

Okay here is my problem. I have a huge worksheet that has every day of the week in it (Sun-Sat). Each of the days have the same number of...

Hi, I'm using array functions to calculate conditional sums for attendance by department, but when I drag the bottom right box to autofill across rows and...

I have a workbook with a series of worksheets (more than 25). I need to do the following: For each worksheet 2 through 'n' Sort/Filter on column M "Impact"...

Hi All, I am trying to use 1 sheet for my data storage then sort that info to another sheet that looks only for a value I am looking for. Here is a example...

How can I link text to a cell reference? Depreciation Asset - Cell D4

Hi, I'm trying to highlight a cell using CONDITIONAL FORMATTING if the cell has the word "Repair" in it anywhere. Example: "123456 - REPAIR" will be in the...