Am i losing my mind here? I could have sworn that in the past I was able to autofill the alphabet series using excel and starting the series with an "A" and...

Want to put 2 colors in cell to show over lap of tasks in excel calendar that I've made. Can this be done or only one color at a time?

Is there a formula/function to to this? Each student get 3 attempts at a test and I take the highest score. I want a formula that will display the highest...

How do I count number of cels the matches 2 conditions (I am using COUNTIF and AND) ??? I need the total of cels that matches the 2 conditions and not the sum...

IF funtion and or funtion returningen wrong result when using decimal numbers. Exampel: a1= 300 b1=303,6 c1=b1-a1 d1=3,6 e1=if(c1=d1;"ok";"not...

very strange behavior of if function resulting in wrong result which might be a bug. try it out at your own, and try other values just remember the same...

I have designed a form that is to be filled out on-line by a group. How do I format the worksheet so that when they tab through form, they go down left side...

In an Excel 2000 spreadsheet I inserted some rows and deleted some cells. The gridlines in these inserted or deleted and restored cells lack gridlines. I...

I know it's basic, but I can't find it in the manual. How can I create the current date in a cell so that it is the create date of the sheet, and is not...

In Excel, I keep setting the "always create backup" in the "save as" toolsoptions menu, but it keeps on getting erased. How can I automatically produce and...

I need to get the name of a number. For example: I have in A1 cell a value, 25 and I need its name in the next cell B1, I mean, I need to get into B1 cell the...

I'm going absolutely batty trying to figure this out. SUMIF simply will not work for me when I try anything that requires the criteria portion of the...

I have some stock names in Column A, I have some "Buy" or "sell" in column B, I have Transaction amount written in Column C I will specify the stock name in...

How to sort data containing formula For example Column A Column B Column C 1 10 =B1-B5=4 2 9 =B2-B5=3 3 8 =B3-B5=2 4 7 =B4-B5=1 5 6 =B5-B5=0 Now if I sort in...

I am trying to use a cell with an indirect validation to lookup a value in a list. It does not work. I tried to fix the error by adding a column that will...

I've got a fairly complicated workbook. The lead worksheet picks up matching cell info in several other worksheets. I'd like to have a duplicate of this lead...

Hello, I made a function, this function returns a value that i would like to put in a certain cell. In a cell you can put for example =now() then the field...

Hello! Does anyone know of a quick way to sum one cell (for ex. A1) for all worksheets in the workbook (say there are 10 total + 1 Summary worksheet) on...

Hello, I have read the threads about similar problems on this site, but nothing seems to work for me so perhaps I am doing something wrong. I need to...