How I test if the name is in a array?
I try
RR= array("John", "mary")
IF A in RR then

Hi, I believe there is a way to do this but it's been quite a while since
I've had to do anything like it.
Is there a way to create one template datasheet as a 'master' sheet and then
have several copies of the master.  Whatever changes occur in the master

Sir,
I want to use data filter command in protected sheet. Oncly Because that
formula i m using in the cells should not display or suddenly can delete or
currupt.

Howdy All,
Just wanted to see if this is possible.
I want to display text in cells vertically so that cell A1which contains
0001 will appear like this:

we re trying to use
xp pro & an old version of excell ver 5.0a
does anyone know if these two products are compatible
we are getting files unable to open after working on a spreadsheet for a

I need to create a "save file" command in my macro which allows the file
to save to the current directory to prevent "run errors" if the end user
has a different directory tree.
E.g. I may be using a default c:\ directory, but the spreadsheet user

I need to sort all records by the last 4 digits in a particular column.
ie, my data looks like
alskjflkja0023
lkahsflkjf0021

Please Please help!!
I have two spreadsheets each with one data ranges (same range -
B7:O200), I need a lookup formula that copies the value in column O7 on
s/sheet1 to O7 in s/sheet2 if the values in s/sheet1 columns B7,C7 and

I have exported two sheets of data one from ARCGIS dbf and one fro
SPSS toand excel sheet
I am trying to use vlookup to match the data from both sheets an
replace any missing values with zeros. The result is all are regarde

I am developing an application which uses Excel as the input interface.
I want to use a cell as a "button", i.e. the user can use keyboard to
navigate to that cell, and press enter to "click" the button. I don't
want to use a button clicked by mouse, because that would be slow.

I have a challenge for you...
Below is taken from an excel spreadsheet, if you copy it and paste it
into excel it should make a bit of sense:
Abertillery JC Ph01b    IMP1239Ph01b    05/12/2005

I just updated to office 2003 and I am trying to record a macro.  The
directions refer to "Stop Recording" toolbar.  I see nothing that looks like
this on my workbook sheet.
I feel like a nut, but could someone help please?

A little redundant but maybe someone can help me a little further.  I am
trying to write an excel spread sheet to order products for jobs that I
send my employees out on.  For example, I own an air conditioning
company and we use thousands of products for lots of different jobs.  I

Hello, and hope I explained my situation clearly:
I have entered =IF(B4<3,"<3",B4).  Applying the formula will have the
effect, any number less than 3 will show <3 in the cell, any number greater
than 3 will keep the value.  So if I have 2 in a cell, the cell will show

Excel 2003 SP2
I have a new blank workbook,
and on a new blank worksheet
I format columns A - D as Text.