I have a spreadsheet with about 26 columns. The rows of
information are sales invoices.
One of the columns contains a salesperson code.
In a separate spreadsheet I want to extract some of the

I want to know does Excel provides such function to me?
I've my own-made function (f), and if my function f(10,20,30,x)=0,  Does excel has a function to find out the x for me?
Thanks
Joey

In a matrix similar to this
                Fruit       Vanilla      Chocolate   .....
13                £20           £15         £18
12                 18            16          15

I have a disc that has spreadsheet documents in the
files.  It says that I need Ecel to open it.   I have
Windows Xp Home Edition.  Is there an Excel for the
Windows Xp Non Office?  I really need to open these

How can I show the current month in a cell?

I like to ask any experts know how to get data form sheet 2 into sheet 1
Thx you very much
From
Kazaam

I tried to create a simple worksheet containing 3 option choices, I
want the data of the choice picked by the user be reflected in the
other cells. To illustrate the picture better, I hv enclosed a simple
workbook here....

Hi sample of my spreadsheet
      SHEET 1
   A    B    C
1  joe  258  Joe

How can I protect cells on a worksheet and still use the autofilter

B2 = "5-12-03"
How do I make it check to see if the date in B2 exceeds 6
months (compared to the system clock) then enter C2 in red
text.

Hi hi..
In Data Validation, can we allow people to key in only certain numbe
which is not in series... eg. 30, 40, 50, 60... In another word, th
user could just key in these number, they cannot key in 31, 32, 55 o

I have 3 spreadsheet files 2 are look up tables.  Basically
they contain catalog information from 2 different companies.
On the main spreadsheet if comany A is put in say cell A1
I want to look up the information in that companies catalog eor look up tabl

               I need to convert a time value which appers as hh:mm:ss to
minuets so that it appears in a decimal format.......eg.1:30.30 appears as
60.55. Does anyone have an idea of how I might do this. Its for analysing
phone usage. Thanks in advance.....John

Hi
Below is a sample of my spreadsheet
Lane    Name     Game 1     Game 2
 1     Joe       199        201