Hello All, I was just curious why I wasn't getting zero for the result of the cosine of a 90 degree angle. This...

Hello! I have a matrix with categories in the columns (from A to AG) and I use string reference (with INDIRECT) to access it in another sheet (same workbook...

In the EXCEL curve fit function for a single dependant variable should the coefficient of determination be upper case R-squared or lower case r-squared?

I have a sheet with rows of data. I have named ranges for different rows and columns within that sheet. How can I view the each named range on a second...

I have cells with ethnic groups that I need to consolidate into broad ethnic categories. For example, Cambodian, Chines, Filipino, etc into Asian/Pacific...

I have 2 drop down menues that I want to show the items selected syncronized. It is an item list with a description. Right now I can do each separately I...

Hi, I have created a project management sheet. The user enters a few variables on the overview worksheet, and using those variables Excel populates a...

I am trying to look through a list on names in one column and values in the column next. If I have a name that repeats I want to add all the corresponding...

G'day Everyone Dare I say it, but I've hit the proverbial brick wall here due to a long absence AFK & Excel (2007).. Specific work Range = $A3:$L100 The...

I need to find a value in a certain row and return a value from same row. I can't use vlookup because the lookup value can be with in any colunm within a...

opening a file from Excel 2003 into 2007, after making changes and saving in 2007. Reopen file and changes have not been saved

If I have a financial year August01-July31, is there a worksheet function(s) which I can use to convert date such as 22/08/09 to read 'Qtr1, 2009' or...

I have an Array formula below that works perfect. It sums amounts of project expenses (DataFile.xls) based on specified criteria from multiple combo boxes. ...

Hey, are you getting free traffic to your site? I just discovered this website that has some pretty good content about generating targeted web traffic, with...

Ar Bs Ec Ar Bs Ec 20 36 14 10 7 I am trying to sum the above columns. Column 1-3 supercede columns 4-6, in the sense that if column 4 has a figure in there...

I have a client using Excel 95 and when he open my workbook - Excel 2007 he gets the error message #NAME, can anyone help with this problem. Campatibility...

Hello from Steved A B C ...

In Excel 2000 I would like to count the unique entries in a range of data. Any ideas?

Hello: Would you mind to tell me is it possible to find the average on every day with the following data? Date ...

We just received new computers and the highlight option is not showing on the main screen, but items do show as highlighted when I click on PRINT PREVIEW. How...