When I enter in linset and hit ctrl shift enter it still doesn't display the information as an array, what is the problem?

Here is my formula - it ends up with FALSE - I must have a ) in the wrong place can anyone help? Essentially I don't want to end up with a ##### (negative...

What is the formula to copy email addrs from one sheet column to another sheet column IF Lname = Lname AND Fname = Fname in the same...

The numbers represent rounds. So a name will go with a round (number) but some names know more than one round. Name a 1 name b 2 name c ...

Hi, Can any one tell me how to get rid off the "-" at end of the data (downloaded from SAP). The data I download from SAP look like this (203) 968-7273-. ...

I am trying to fiqure out if there is a way to not print cells?

Hi, I know if I have few columns I can transpose it to rows by using the function "Transpose". But if I have hundreds of columns that content the same...

In cell C 13 is the quantity of units. In cell G 13 is the total cost. In cell G 6 is the percent of overhead and in cell G 8 is the percent of profit. I...

In cells H15 and H36 I have 10/31/09 and 1/31/10 respectively. In J 15 and J36 I have the following formula: =DATE(YEAR(H15),MONTH(H15-DAY(H15))+2,) ...

I need to copy a range of cells, then export or copy them to another program, they don't have to be functional, i.e. still in Excel format, i just need the...

I am working on a spreadsheet that has three columns. A(Equipment Description) C (Part Number) and AA (Price Each) What I would like to be able to do is to...

Why doesn't the autofit height in excel work properly ? -- jpd414

How do I remove the Excell HEADER in Office Professional 2007?

I am trying to summarise dates from 01/04/09 to April. Can any body help. I have tried = month(cell) , but it comes up with a value . Any ideas?

I would like my workbook to open to the same page every time it gets opened. I found the following code in another post he Sub WorkBook_Open() ...

I have A workbook that contains 26 worksheets. Sheet 26 is a summary page that gives a running total of of the information entered in the previous 25 pages....

I have eight responses to an evaluation that scored experience from 0 (worst) to 10 (best). From the results posted below, I need to compute % of responses...

I am using an Input box for my sheet to sort, I have 28 sorts and it is not working. Can someone tell me if my code is incorrect. The sort works fine when...

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. I am trying to get a total of...

Why is this giving me #REF! error =INDEX('(312) - POS Pricelist'!$E$5:$E$8148,MATCH('Store Price List'!$A4,'(312) - POS...