I have 10 Account Managers that have 8-12 Sales Reps assigned to them.  Each
sales rep has estimated their products to sell for 2009.  Each AM has
summarized these estimates for their respective districts.  I have a
spreadsheet that looks something like:

I have one workbook that is a full choir roster and three separate
worksheets, one for women voices, one for men and one for children all with
addresses, etc.  How can I tie them together so when I update one of them it
will update the full choir roster?

3.51%
3.45%
6.60%
3.04%

Via the INDEX and MATCH functions I can get the intersection of a column and
raw cells in the multiplication table. Is there a reverse formula that shows
a value from the first column, using two values, one from corresponding
intersection and the other from the first row of the ...

Can someone tell me how to write a function that will:
(a) concatenate 1000 rows of data (into a single cell)
(b) delimit each of those rows with a ;
The "A1&";"&B1&..." method is painfully slow, even with copy paste.

I have two suggestions to improve VLookup:
1. Add an optional parameter that provides a result if the Vlookup returns
NA so that you don;t need to wrap it in an If (ISNA...
2. Make the column offset capable of negative values so that you can offset

I am new to Excel spreadsheet functions.  I would like to average the
data over a minute for a 24 hour period.  How can I do this?
The data looks like this:
Col A             Column B               Column C

I want to change the default name on the comments that I post into Excel
spreadsheet.  RIght now, each comment opens with "Preferred Customer."  I
would like to make the change so that all comments will open with my name.  
Thanks!

How can I make a positive number in cell say B12  turn to a negative number
in cell B18?
thanks

I use a nursing schedule that shows all nursing staff's schedule for a whole
month. This is referred to as the master schedule.
From this schedule I need to be able to identify specific staff scheduled to
work on a specific day during a specific shift on a daily basis in a ...

I am trying to convert a PDF file into an Excel spreadsheet and am getting no
where.  Please help.
thanx a bunch

I want to use Solver to solve the following problem, but I can’t work
out how and its driving me crazy.
I have to organise a prize giving dinner so I know I need to work out
my expenses and make sure I cover those.

I can make a drop down menu just fine,. My problem is that I want the choice
for the drop down menu to then fill in something other than what the choice
is called. For instance, one of the choices could be Physics and when
selected, instead of filling in Physics, it fills in P310 ...

I have 2 worksheets - 1 sheet to pull into and the second sheet is a list of
source data.
First sheet
Number   Date        Qty    Date          Qty

Am trying to convert A, b, C (text) into 1,2,3
Can anybody help me in putting the right formula?
Cheers..