Please help me to turn normal letters into CAPITALS automatically, in an
excel sheet. Thank you very much!

I have a colleague who wants to use the Data Validation List function
to create a drop down list.  Depending on where the list is used (21
different places on the spreadsheet) the contents of the list vary BUT
the original data is all in the same database.

I believe there is a formula that has something about max(row, etc), but
cannot recall it.
Col A would contain a list of numbers.
I'm trying to find the first empty (blank) cell in col A.

I have a table similar to Sheet 1 and need convert to Sheet 2, Exist a
function or how work???
Sheet 1                                       Sheet 2
Cod   Value         |                     C1     C5     C7

Hi all!  Using Excel 2003 here, and trying to help my BF with a worksheet
problem.  The file contains 5 tabs with specifications regarding 5 types of
products.  For example, one tab is different brands and models of a disk
drive in column A, the speed of the drive in column B, ...

Please help...
I need to check one list of names against another list of names and to
determine if any of the names appear in both lists.
I.e.

I have a spreadsheet that I want to use a formula to conditionally format the
spreadsheet but there are too many ANDs and IFs and I'm getting confused and
I need some help, please.
It's set up like this:

I was using the control tool box feature and I clicked on the properties
option while in the design mode.  I then inadvertently clicked off of the
control button onto the spreadsheet and then accidentally selected   the
xlsVeryHidden option...and now i can't find the worksheet... ...

I think a macro is the best way to do this; if there is a way that is better
I am open to all suggestions. I am trying to create a backup copy of one of
my spreadsheets on a daily basis. I need this to be done every weekday night
@ around 11PM when I know all updates for that day ...

I'm using Excel for accounting functions and have the I have the following
two formulas: "=MONTH(C6)+3" & "=VLOOKUP(A10,'Schol 2007
(Expanded)'!$A:$AE,$C$5)"
What the formulas do is pull financial information from one tab and insert

I copy data into Excel from a website on the Web.
The only place I can find the Text Import Wizard option is in the paste
options box which is a drop down box that appears after I have pasted the
data into a cell.

I love array formulas (though, I’m not expert at them). My favorite is:
{=sum(if(sheet2!a1:a100=a3;if(sheet2!b1:b100=b3;sheet2!c1:c100)))}
Which will find the appropriate number in sheet2!c1:c100.
To my great disappointment, I’ve discovered today that it will display the

I'm trying to do a multiple regression but using formulas but it seems
I can't get these formulas to work on multiple dependents.
=CORREL(Y,X1,X2,X3,X4)
=RSQ(Y,X1,X2,X3,X4)

I would like Excel to create a new sheet when a value is pasted to an
(empty) cell in a template sheet.
Details:
- the template sheet (which already contains formulae) should treat

I have 20 separate spreadsheets that are emailed to me monthly with updated
information.  Every month I need to sum the data (example: add the B10s in
all of the spreadsheets).  I've created a master spreadsheet linked to each
of the 20 spreadsheets, but I've found I need to ...