I have a defect database with a list of people's names, defect numbers, date
entered, etc, which  I have imported into excel. There is a finite number of
names that appear multiple times in column A. I woud like to create a second
column that automatically associates a role with ...

you know how sometimes when you paste a value into a cell it reads like a
number but Excel thinks its text and aligns it to the left and gives you a
little dropdown menu with options such as keep this value as text or to
convert it to numeric data.  I have a whole column of ...

I have "inherited" a workbook used to generate budget documents. As
part of the book, there are several sheets that contain the formatted
"form" which includes boxes or borders around certain cells. My
problem is I cannot change the format of these cells using the

I have a grouped pivot by date.  Works fine except for the format of
the date doesn't allow sorting in the way that I need.
The data has the dates in the format:  4/17/2006 14:21
After grouping in the pivot on that field by day (to remove the time

I don't know if this is possible but what i'm looking to do is customis
the way autofill works when copying formulas.
I currently have a formula which references cells in other workbooks t
get an average:

Dear Sir,
I want to give microsoft excel a suggestion. I could not find the proper
e-mail address where i can send suggestion. I wanderd a lot in many many
pages because of lake of knowledge of searching. I don't know how i found

This is my first post, and I'm sure the answer to my question is
probably a simple one...maybe why I can't think of it?
Anyway, here is my questions: I have built a sheet that tells me the
hours I have worked for any given month. What I'd like to be able to do

I have a column A with rows 3 to 20  which has prices in the cells
I want to put in say B1 the highest price from A 3 : 20
and to put in say B2 the lowest price from A 3 : 20
Can someone help me with a formula

I want to use a formula in a cell (fixed)  that contains a cell as reference
which in turn is subject to "move" by sorting.
Is this possible?

Is there a way when entering data in a spreadsheet - to have the cursor move
to column A after entering data in Column F or beyond?

In column A I have several Names, In column D I have certain values.
In a cell I want to collect the values of the line in column D if a
certain name is on the same line in column A  
I know if I use  sum  I will get the total value, but is there a way

Using Microsoft Office Excel 2002 Iwant a good Template

I run a hockey pool and I want easy roster management. What I woul
like is to have the 1st sheet to have every single NHL player on on
sheet. Then 10 different sheets with for the teams in my hockey pool.
What would be great is to have a formula that would look at column

Hi I need a formuls to drop the lowest value and add the rest as in.....
Cell (AF4)    Cell (AH4)    Cell (AJ4)    Cell (AL4)    Cell (AN4)
       100                90                80                70
170

I have a problem with the menu bars in Excel:  I replaced an old hdd in my
PC by a new, larger one.  Therefore I had to reinstall Win and all the
applications there, also Excel.  Unfortunately I have problems to transfer my
old menu bars.  I already tried the trick with opening ...