What I am trying to do is track a 10 week rolling average, where scores
are entered weekly in row A6 thru W6.  The formula needs to count back
starting with W6
until it counts 10 scores then average them.  Some cells may be blank.

sir in excel how we convert number to text in english version???

I have 2 worksheets with the following data:
Worksheet 1---All Project (A1-A21)---Number of sites (B1-B21)
Worksheet 2---Customer Name (A1-A39)
then columns B-H have the All Project value if applicable.

how do i round down the number contents of a cell to a complete digit
ie 1.6 to 1 or 1 to 1
thanks jnf

Hi to all good people,
I am workin on an excel sheet in which I have to make Maping of Payment
received and mode of payment is Cheque and Cash. I am in collection business
and have to map daily payment received that i am doing by vlookup but when a

i want to create an excel sheet where by i can get the inventory pre
calculated by just changing one or two data cells

I want the user to save a protected worksheet by clicking on an action
buttom. The file should be saved with another file name taken from a cell in
the worksheet.

This might be a very simple question to most of you, but I am a novice
user.
If A1 has date in the format 04-Jan-06, then how do I have B1 display
only the first two characters "04" in number format, which means 4?

As the subject. I would like to list all sums in sheet1 to sheet2
Example:
Sheet1:
Date                          Amount

I have created a workspace to open 4 different workbooks, however
whenever I open them, they all open and go directly to A1.
Each workbook goes to rows 300+, meaning I have to scroll all the way
down each time.:mad:

Hi all,
I am using the following lookup statement -
=VLOOKUP($B11,Distribution!$B$12:$B$150,1,FALSE)
If the value does not exist, excel returns #N/A, which is to be

Hi - Can anyone identify & rectify the error
I gave this formula at Data->validation->List ; Source
results shows first item of next range also.
=OFFSET(INDIRECT(N2),0,0,COUNTA(INDIRECT($N$2),1))

I want to evaluea  hex expression say AABB and split it to individual cells
in binary
1010
1010

Everything was fine, when I was using Office XP.
Fill colors are disappered from all of my Excel Workbooks & Worksheets, when
I upgraded to Office 2003. The main problem is that I can't fill anymore in
any cell. Why?

Can I do something like this?
A    B
1    =F(A1)
2    =F(A2)