I have 6 workbooks. 5 of the workbooks are password protected to read and modify because they contain very confidential payroll info. The 6th document is a...

I have set up an account book so that Page 1 is January, Page 2, February and so on. I wish to transfer the final row of data from page 1, to line 5 on page...

Is it possible to have Named dynamic ranges for a worksheet included in formulas in another worksheet; but have the formulas automatically add rows of more...

I have 3 columns of Data, Location, Date and Stock Variances. I wish to Add up The total PLUS Stock Variances per Location in one cell and the MINUS Stock...

The function SERIESSUM(X,n,m,Coefficients) gives an error for X=0 How to solve it, the function is useless as it is?

I have been charged with designing an excel workbook to manage our teams holidays. Our team works from remote locations so I was thinking of designing a...

Could anyone please provide a little help? I have, after a lot of effort and fact finding on this group & the net managed to sort out 2 simple formulas to...

I need to sum values in a column only if criteria are met in two other columns. For example - sum column $AV:$AV if $A:$A="Level 2"...

for example: i have a row with 20,40,50,80,120 and i want it to be 0,20,30,60,100 (so all -20) how do i do this?

1stworksheet City/Couty Gross Tax county name (formula) Formula city Name (formula Formula 2nd worksheet (data) City name ...

I have been using named formulas in my spreadsheet. Often, the formulas don't seem to calculate, or are very delayed in calculating, when one of the variables...

EX: Cell C2's value = B2. and cell B2 = "Hello" How can I get A1 to show the value in B2 by using the value in C2? Is there a string value? =($C2)

Every morning I prepare a sales report that I send out to the staff. I am saving files from our POS into tab delimited files and everyday when I open them I...

How do I get the colors to change automatically when I use a drop down list. Per say here is what I am trying to do If a certain "word" is used from the drop...

I am having a problem with my linked workbooks. The workbooks are in three levels and I can't get the top level workbook to reflect data from the bottom level...

I will try to explain clearly what I am trying to accomplish. I hope this makes sense. I work in the transportation Industry and have the dubious pleasure...

Why oh why is it that when I drag the field to the column area it is fine..I then drag the second one to this area and it gets lost? Sometimes it does not...

I searched for all posts regarding rank formulas and did not see exactly what I was looking for. Here is what I need to do - Rank by dollar values, some...

Hi, I am having some trouble with this marco that I'm attempting. Hoping someone could give me a hand. I am trying to sum an array based on a date...