Thank you

Can I view my last 10 sorts in Excel & how?

Hi,
When I drag formula down, it will copy the value of the cell, even through
the values of the formula get updated.
What I mean, if I were to drag the formula in 1A down to 3A, it would result

Is it possible to protect a worksheet and still be able to use the subtotal
(grouping and ungrouping) function in excel? I need to protect a document but
be able to allow others to group/ungroup the data. Can this be done? Thanks,

Hi.  Does anyone know if there is a formula that I can use in Excel (XP 2003)
to calculate an end date if you are given the start (9/29/2004) and then the
number of Months (6), that the formula cell would show (5/29/2005)?
Thanks in advance,

I would like to find a maximum value across a row of 24 and return the title
I have given that column.
So, if the max value of row R is in cell R20, I would like the function to
return the name in cell A20.

Has anyone had a problem where dragging a formula down, and the new cells
display the value from the original cell even though the formula itself is
correct?  If I clear the cell and reenter the formula, it calculates
correctly.

I'm trying to do a spread sheet with a timeline based on weeks.
In the excel sheet attached I have tried to show what I want. How do I
get excel to do row 1?

I need some help with a worksheet function.
I have 2 columns. Col 1 contains Values and Col 2 contains True/False
I need a function to calculate the total value of col 1 where col 2
false.

I sure could use some help with this. I have been trying to do some code
without enough experience.
I have a workbook (#1) that has one sheet and it generates a sequential
number each time it is opened. I use the number in another workbook(#2) to

5060
i want to count that : A=1 and B="a"  .
thank
+-------------------------------------------------------------------

I am trying, with no luck to find a formula will sum the amount of times
unique data is in a list, eg range b2:b6 contains
apple
pear

I have a list of time spent per call on the phone. It is in the format
0:00:00:00
Where you have days, hours, minutes, seconds
I have trimmed this to hours, minutes and seconds.  However when I use the

Is there a way to have a function/formula when evalutating a cell, look at
the result of the formula within that cell and not the formula? For instance:
The formulas in range A1:A20 is =IF(LEFT($G4,3)="DET",G4,""). How can I
count/sum the instances in range A1:A20  where ...

Ok. I have a master worksheet that has rows containing lots of data I need.
In another worksheet, I have a short list of items I would like to select
from the master. (Master has about 5k rows, short list is approximately 90
items)