Hi, I would like to know if there is a way to find out which rows add up to a certain dollar amount. For example, I have 134 rows of different dollar...

I have a yearly work calendar that is shaded (color coded) to match work days, holidays, non paid days, etc. Is there a conditional formatting that I can use...

I have been trying to figure this out for 3 days. I have 2 criterias that need to be met and then I want the total of a column. A C

I have a cell that contains the value 5.4. The value is a result of a calculated formula. There is conditional formatting set up in that cell and it's not...

I have a set of values in column A, and 4 reference columns C, D, and E. I want to reference column A to find a matching value in either column C,D or E and...

Hi, I need a simple formula... seems very diffucult to get In Sheet 1 I have employee names on horizontal line and a lot of numbers in vertical line. In...

Hi All I have a macro that is working great - it creates an overview by searching worksheets for data / coping & pasting values into an overview - but it only...

I have 3 conditions score divided into 3 parts 50, 75 and 100 % If score in cell = 27 then -3 If score in cell = 2636 = -2 If score in cell = 1827 =...

Hello, i really like or to be honest i am excited about the cube functions in excel 2007 and excel 2010. I can't wait to create workbooks with these...

I want to be able to set an interest rate, fix a monthly budget, set a baloon/final payment, so that i can see clearly how much depost i've got left against...

I have two different datasets. Each with a common identifier. I need a formula that will reference the identifiers in both datasets and count the number of...

How do I copy the conditional fomatting of the row to the entire table?

My apologies if I have done this incorrectly. After closing off a previous post I added to this question. Is there someway to select and update Multiple...

I have a range of cells that I have formatted using Data Validation to have their contents limited to selection from a drop Down list. However the down arrow...

Can I use a dynamic named range setup in one file as a range in pivot tables in another file? When I have the data source file (with the named range) and the...

Hi. Hope you’re able to help. I’m having difficulties the SUMIFS function. Either I’m using it incorrectly or perhaps it’s the wrong function for...

There a way to turn off the screen when macros are executing so you can't see the macro running and then turn the screen on to display the results when the...

I am looking for help getting a macro that works and performs the following steps. Check Column F for information If Column F has information check Column AF...

I try to right click on my mouse when I need to edit a cell but nothing happened. Can anyone tells me how to get that function back. I have been use this...

I'm using the VLOOKUP formula and I cannot determine why there is no return on certain records, which should have a return. For instance, I execute a macro...