Hi I will explain what I am trying to do.Two columns of football scores in
A1 and B1 they could be 0-0 1-1 1-0 0-1 etc I am trying to use the IF
statement to work out if they are say draw, score draw, home win, away win.
I am getting nowhere can you help please

In Excel 2003 what is the trick to linking to a closed work sheet using a
formula?
I'd like to put a list of file names in column A then use a formula to ling
to cells from those books.

I have an installation of excel 2003 that for some reason is opening
all kinds of files when it opens.  As far as I can tell it is opening
all visible files on the root of C drive at the moment.
Any ideas on what would cause this or how can I fix its?

I have been asked to compare lists from my 2 main systems. They believe that
the information of them is not consistent. How would I compare the 2 lists in
Excel since there are over 30 thousand records on them. Information:
List 1                                                ...

I have a bit of query I hope someone can help with.
I have a spreadsheet that I update on a regular basis which uses pictures,
flags of countries to be precise in, cells.
For some reason, when I opened the spreadsheet to update this today, the

Generally COUNTIF would ignore the case of the text, but I would like
to count the text on a case sensitive base. Suppose in Cell A1 contains
"jack", and in Column B contains "Jack", "JACK", "jACK" and "jack", I
want to know what formula could count the number of "jack" in Column ...

here is something that should be much simpler to accomplish but somehow
is very difficult to figure out.
Basically, for simplicity's sake, let's say I have a simple spreadsheet
shown in TABLE 1 below which has Mon-Fri in one column and dollar of

i have in excel 5Rows & 5 Column
i 5th column if i type like ok / any thing, change the Red colour to
whole row, if nothing means it will be plain
how to use this in Conditional formating option / any

when ever i copy certain information inta a cell the cell formats to some
arabic language. the data i copy in is A4-1500.
when i copy in A4-500 or A4-1000 it works fine only this specific number.
also it doesnt mater how the cell is format before copying it always over

I would like Sunday, October 01, 2006
to show up as Sun Oct 1st
Thanks for your help!
...Lisa...Excel 2003

I run Win2K with Excel 2K
I have a spreadsheet that is protected. Some cells on the sheet are not
protected so that data can be entered. The problem I have is that sometimes
people copy and paste this data from an external source and this results in

I cannot print any borders on my sheets. I used to be able to. I
checked old sheets that printed OK before and cannot print now. What
has happened? Running Mac OS X 2.3. Do not know the version of Excel as
I am not at that machine now. By borders I mean all underlines in a

I'm trying to make a primitive Excel application. It is almost done but
i need some help.
This application would be in my shoe store. At the end of each day one
sheet(or maybe two, or three) should be E-mailed to me at home and I

I'm not sure if you follow the FSForum section in the FlightAdventures
Forumns. There's a question for you there: "Extra 300L vs F1 Rocket
(question for Patti}".

Something just happened to XL causing the cursor to freeze and pressing the
up and down arrows just moves the worksheet and teh cursor has to be moved
by mouse click. Can anyone tell me how to unfreeze the cursor.
Thx