I work for a university and have been trying to automate a staff expense claim template but have been stuck with the following for far too long (help is much...

I am trying to sum numbers in a column based off of another column. I only want to sum the numbers in a column if the other column meets the criteria. An...

When using Vlookup to copy dates from one excel file to another, is there a way to copy the font color of the date to the new sheet while still using the...

I have the following table. part start mid end ABCD plan 01-Jan 01-Feb 01-Mar ...

I have a data set from A3 to D60000. In any selected row the data values in columns A, B and C correspond to a value in column D. Eg. If A4=1.04, B4=.96 and...

I need to calculate the Adjusted Closing Price for the day which is adjusted for all applicable dividend distributions. Data is adjusted via dividend...

I would like a formula to find the value of a cell 1 row before certain conditions are met. Beginning with data in row 34 down I want to know the value of...

I have Dates in column A with an associated text in column B. How do I evaluate the text in an If function for a given Date when I don't know which row I...

My red X on my title bar is grayed out how can I get it back? -- AG

I work for a university and have been trying to automate a staff expense claim template but have been stuck with the following for far too long (help is much...

I am looking for an optimization software (Plug-in) for Excel-2003 to solve problems with multiple variable. I tried one such trial version from Solver.com...

I need formulas to calculate a dividend when it occurs between 2 dates. I’ve tried a few options & looked through the group but I don’t have the skill to...

I've got a column of ten cells that I want multiplied together, i.e., =A1*A2*...*A9*A10. A couple of these cells are blank, and I want to ignore those...

HI, I am attempting to update our medical benefits spreadsheet. I would like to calculate how many employees are enrolled in each plan type. Column A lists...

I want the contents of 3 cells to move when i add a number in one of them. e.g Permanant info in A1 & C1. When I put a number into B1 I want the info in A1...

I need to find the total if conditions in two columns are met. I'm doing a school lottery for enrollment and need to see how many students met the criteria...

In column A, I have values equal to either YES, NO or NA. In column B, I have values equal to either YES, NO or NA. I want to count the # of cells in...

In column A, I have values equal to either YES, NO or NA. In column B, I have values equal to either YES, NO or NA. I want to count the # of cells in...

I am looking to complete my formula for calculated weighted averages. Here is what I have: A B C ...

Tenho uma tabela dinamica com varios dados sobre vendas, clientes, valores, etc.. O nome do vendedor vem na Pagina. Assim seleciono um vendedor e vejo sua...