I have to work out the following problem and I can't figure out how.
A bonus formula that addresses the following requirements:
A sales person needs to sell more than 260 units per quarter to qualify for
a bonus. Create a cell that is labeled "Bonus Quantity" and put the value ...

Excel2003 ... Range A6:G6 contains Formula's
Cell A6 contains a Name (returned by formula)
Range B6:G6 contains values 0 to 7 (returned by formula & may repeat)
I wish to set conditional formatting in Cell A6

I have an array of cells, B3:J34 on sheet2.
On sheet, 1, column, I have a range of values that can be found in the
array on sheet2. I'd like to put a function on column b, sheet1 to
return the value in row 2, above the searched value from sheet1 ,

how can i auto insert a line between different blocks of data in a single
column?
for example, in a year to date export of shipments, i need a total count of
shipments for each month based on the outbound shipping numbers (BOL's).

I'm running both 2003 & 2007 versions of excel. How can I make 2007 the
default application? I could have sworn it already was at one time but now
when I click on a file it opens in 2003. I tried changing the file type in
the folder options menu but that didn't work. Any ideas? I ...

I am making a chart and need to put a verticle straight line from certian
points on the chart.  When I go to the Insert Tab, then to shapes, I select
line.  I picked the two end points for the chart... the first one is exactly
where i want it, the other is slightly off (to the ...

Would like to have one comment, AND have the indicator be directed to
multiple cells.  Is this possible?  If so, how?  The goal is to have one
comment box that refers to numerous cells.  This will be much easier and
simpler than having multiple cells (with the same comment), each ...

I need to have a cell give a name of a person who has the most sales. there
is a column with the names of the people and another with the vales or
totals. I am told I can use the IF and MAX function, but I must use them
several times in the same formula to do this. I can use them ...

I am taking help of community for answering my question but I am facing a
problem, when someone reply of question I am not able to present my views to
his/her answer. There is a option of reply but when I click on that option,
it takes me again on that page. Also I am not able ...

I have a spreadsheet with multiple months across the top, rows for data entry
and a total row at the bottom.  There may be months with no data, followed by
months with data.  For example:
       1/07   2/07   3/07  4/07   5/07   6/07

Can I select a text box or a group of cells so that whatever I type is seen
on my screen but is not visible on the print out?

I am trying to find a way to Find and Group duplicate data in an Excel
spreadsheet. Is there a way to do this?

I am creating a mailing list in Excel by typing in the data. To save time, is
it possible to scan my hard-copy and import the data into Excel? The hard
copies come in various formats.

I'm trying to send out a worksheet to clients that contains copyright
information in the footers of the excel file.  I don't want those to be
changed, yet when I protect a sheet it still allows a user to edit them.  Is
there a way to protect the footer?

I need to email single pages and not the whole workbook.  This was easy in
2003 version, but after the upgrade to 2007, I can no longer seem to do so.