Functions

Header Information
I am doing a spreadsheet for my school. I am trying to put a title up top like where the letters A, B C D are. How do I go about doing that??? Thanks ... 28 May 2010 23:36

I can't input anything I type on Excel. What can I do? Nothing p.
I can't use Excel worksheet. I can't type anything on my Excel worksheet. What can I do to clear this and be able to work with the go-to command? ... 28 May 2010 19:17

Yes - No Interactive Text Box
Working in Excel, I am looking for help using interactive fill-in check boxes. I am creating a form. Setting up a cell or a bunch of cells merged, or not where you enter a question. Then that question can be answered by clicking in a "Yes", or "No" box. Then a "check mark" appears if their is not one, or,... 30 May 2010 19:47

Hold a cell range for an "average formula"
I add a column every week to my work sheet and want the formula to always calculate the current 5 column range. ... 28 May 2010 20:23

zero value in cell
I have a table of engineering calculations. The same formula in each cell operation on variables in the row and column headers. i use the MIN function to evaluate two formulas. Then I take the minimum result and operate on it outside of hte MIN function. I'm getting zero values displaying in my table. When I p... 28 May 2010 18:11

Need to do a data check - not sure the best way.
Okay, I'm working with a team that does QC checks. One person does the work, another QC's the work and a third QC's the QC. To further complicate matters some clients go through a first pass QC, some also go through a second pass QC and a select few go through a third pass QC. If I knew the client name I could ... 28 May 2010 19:17

export data between spreadsheets
Hello, how do I setup an excel file that each time when I enter data in one file it will export to another file in the same column of subsequent rows? Example: if each time data enter in one spreadsheet column A of row 1 it will export this data to another spreadsheet column B of row 1,2,3... and so on. ... 28 May 2010 18:11

ranking
How can I rank the top 5 or 10 items in the category for a location. Location PSA Category item Day 1 day 2 day 3 day 4 day 5 day 6 1501 17 Grill Hot dog 10 12 3 8 11 7 1501 17 Grill Hot Link 3 11 12 11 5 ... 28 May 2010 15:59

Date formula rounded up
June 30, 2010 A B C D Birth Date Date of Hire Appt. Int/Act. Appt. VP November 22, 1962 September 1, 1988 N/A September 1, 1998 Total Admin Service Total Bd Service E ... 28 May 2010 18:11

Count using IF / AND
If cell B3 is between a number range and another cell in same Row =(Z) count. As cells are populated the count will increase. So the cell must be between 10 and 20 and the second cell must =Z to count as 1 ... 28 May 2010 15:59