If I want to create Date Cells in Row A (Jan 2007. Feb 2007, etc) is there a
quick and easy formula that allows me to merely copy and paste, as opposed to
typing each Date and Year in each indiviudal cell? I'm setting up dates for
2007 and 2008, and just want to find a quicker ...

I am looking for a number in a column and the result I want is either 0 or 1.
if number is there i want 1 and if not 0.
I am trying with vlookup function and it is not working.
Can anybody help please.

Hi wondering if anyone can help me with this one...
Have 31 cells in a row which i want to get the average value from, some of
these 31 cellsmay or may not have data in them. The end coloum would be the
one working out the average value of that row of cells.

Is there an excel formula to convert base 32 (6digit) to decimal?

I know the month and want a formula that will tell me number of days in the
month.  For example, April would be 30 days and May would be 31 days.

Can I have a cell in a worksheet (any cell at this stage) that shows
say a '1' if that worksheet tab colour is green, and a '2' if that
worksheet tab colour is red, nothing if there is no colour?, and if
so, how would i do that?

I have loaded a customer data base with name, number, and email addy in three
separate columns on one page.  On another page, is my weekly planning sheet.  
How can I type a name on my weekly planning sheet (also located on the
customer page) in column A and have Excel ...

Hope this maks a little since. I'm very new at this and don't use excel alot
but what I'm trying to do is sort items in cells A1- A7 and have it to add
the amounts for that protictuler item which are in anouther group of cells
and  get a total  amount. maybe this will show what ...

I am trying to produce the upper reference (C2) and lower reference C(11) of
my array by use of Address, row and column functions and use them in SUM
function.
It works when I put them separately in different cells and use concatenate

I have an invoice book of 100 invoices.  I need something that will
show me the next number to use for the invoice number.  The invoice
number series (say 10001 - 10100) is set manually on the covering
worksheet, but i need something to add the correct number to the

In EXCEL 2003, what is the procedure to change the Column headings from R1C1
to A1?

I am making Material Received Datasheet.
It goes like this,
Min Order Quantity..( 1000 Pcs )  =  C1
Max Allowed Quantity ( 1200 Pcs ) = D1

I am trying to create a test for year seven pupils in IT at a secondary
school in the UK.
I want a sound clip to play automatically when a user enters a new
worksheet, or when an image is pressed. The first is my preference.

I need a formula to compare two worksheets and create a new spreadsheet
without duplicates and with the new data in it? Can it be done?

I am doing a mock exam and  am trying to do a database function which counts
the number of orders but excludes one of the products.    But I just cannot
work out how to show this in the criteria.  I'm doing my advance ECDL exam in
10 days and really need to know how to do this in ...