I have a column with birth dates.  I want to assign the individual
birth dates to age groups (21-30, 31-40, etc.).  How can I get Excel
to calculate if a birth date falls into a date range, and have it
assign a value.

Hello, I am working on an assignment and have problems with getting
the result I need using array formula. I have three columns: Vehicle
Type (e.g. Car, Moped) - data in E5:E104; Vehicle Colour (e.g. Blue,
Silver) - data in F5:F104; Residence (e.g. W1, EC4) - data in G5:G104.

I have a simple spreadsheet with 4 columns the first 2 columns have user
entered values.
Column 3 & 4 have "=A4*B4" & =SUM($C$4:C4)/SUM($A$4:A4) respectivly and this
works fine.

Hi, I have so many files in a folder, what I want is to insert a common
header and footer to all these files. Is this possibe, so that i dont have to
open each file and do the same agian & again. Thanks. Amit.

How can I change the font color of a column heading?
Regard

Hello  if I arrow  to the left it hides the previous column if I arrow  down
it hides the previous rows  HELP have no idea

I am currently trying to save a file in excel 2007 to a DBASE IV format.  The
2003 version of office allowed me to do this by simply going to the "save as"
menu and selecting the dbf format from the "save as type" drop down menu.  
Using office 2007, I currently do not see that ...

I am trying 2 figure out a formula like a conditional sum but for counting
and not summing up.
Tried:
{=COUNT(IF($A$2:$A$7="A",IF($B$2:$B$7>2,$B$2:$B$7,0),0))}

I have a list of names that I would like to use for a groupd of ranges.  
Insead of typing each range name in the diaolgue box, is there a way to
upload or automatically use te list that I have created?
Beagle

Question is in the title ;-)
I need every single user of my file to open it in A DIFFERENT PROCESS only
by clicking on the shortcut, and without having to open excel separately and
then open the file from the instanced process...

I am working with a large set of data using coloured fills to denote various
stages of a process.  It would be handy to have the key visible on the screen
at all times, rather than having to scroll to the bottom of the data each
time an entry alters.  I am familiar with 'freezing ...

I have a user who recently has been saving excel files and then they have
been corrupted. It's not all the time but it does seem a little strange.
I was wondering if someone could suggest what to check for on the users
machine and why excel files get corrupted in the first place.

I am using Windows XP and Excel 2000.
I have 2 worksheets 1) Data 2) betwen_2_dates
In the sheet between_2_dates the cell D2 has this date input 01/01/2007
In the sheet between_2_dates the cell G2 has this date input 31/12/2007

I want to enter the same data in different worksheet and in different cell at
the same time..

This newsgroup community is of great value to non-techies like me.
I know i should not place this quesion here. Can anyone you direct me to a
Windows XP community that is similar to this?
Thanks