Hello, is there a way to change a formula for example '=a1+a2+a3' to show its
constant values instead in the cell so it would show '=10+20+30' assuming
'a1' = 10 etc...
Would this be a VBA solution? Any help suggestions would be much appreciated.

Is there a way to select a table and have excel produce a list ranking the #
of times each item shows up in the list, i.e.
dog 5
cat 2

want to find the number of standard length pieces (47" or 59") from a given
nember in a cell ( example 149 1/2 = 2 @59" and 1 @ 31 1/2") and the length
of the non-standard length piece.

I have to regularly update a spreadsheet with stock prices  but can
only do a certain number per day.  I therefore need to see the last
time I updated any cell.
I would like to automatically generate an absolute date in the next

HI, I have a problem with the VLOOKUP as it is working only with limited
range ( 1-90 ) out of 500 items , i wonder if any one can help me with that &
why it is not working on rows more than 90 ? thanx

Bit stuck here wondered if anyone can help? Is this possible?
I'm trying to create a sheet to record the movement of stock. I have
large number of stock items listed by name in one column. What I'd lik
to do is a have a single cell at the top where I enter the name of a

Can anyone provide a formula to take a time value in one column (A1) and
subtract 2 hours to show central time (B1) and subtract 3 hours to show
pacific time (C1)?
Also, how should A1, B1, and C1 be formatted?

I a table that shows interest compounding for a savings account.  A
variable amount of money will be taken out each month and that should
be taken into consideration.  As well as a variable amount possibly
being deposited.

I need to reconcile some data for a hockey team and am in need of a "
Statement of Account " spreadsheet.  I don't know how to draft my own
so does anyone have a template? I tried to use the one on the Microsoft
web site the problem is I can't seem to be able to sort the Description

I have struggled with this all day and was not able to pinpoint the
problem.
I have a table for poker odds that I have created for texas holdem. It
has the first hole card, by second hole card with probabilities wo win

What I am trying to do is a kind of distribution. What I want to come
to is something like this:
Book#------How long to read?------
1234          1-2 hours?         2-3 hours?         3-4 hours?    

How can I create an age field in excel using birthday info and possibly the
"today' function.  I would not care if the answer is decimal or days as long
as it makes sense.  Thanks in advance.   Tim

How can I place the current worksheet name into cell A1?

HI all, I have six cells; c9,c17,c25,j9,j17,j25
if the number entered in any of these cells is over 39 then I want to total
the number over that amount.  is that clear? for example-
cell c9     has 30

On my worksheet is a date column (formatted DDD DD MMM YY), I have a cell
which I want a formula which would incorporate the date from cell A1 and
A14, the result should like something like this:
01 Jan 06  -  14 Jan 06