I have a spreadsheet for calculating labor rate. Column A contains tenths of
an hour (.1, .2, .3 etc...) Column B has a simple formula (=A1*32.39), and
is filled down. Column B is formatted to currency, and 2 decimal places
(which I need to maintain). When I look at, for example  ...

I'm having a problem with Dynamic range for a named list. I define a dynamic
range for a list that is referenced on a seperate worksheet as follow:
Refers to:
=OFFSET(Lists!$A$5,0,0,COUNTA(Lists!$A$4:$A$18),1)

Hello All, please forgive me if this is a stupid question, but is
there a way to copy and paste the result of a formula and not the
formula? For example, if the the cell has a formula of "=A1+B1" and
the result is 2, how do I copy the "2" not the actual formula? Hope

When I plot data I dont want plots to jump to 0 and back where there is
missing data.  The data are being created with formulas so I need to find out
how to make a formula result a cleared cell rather than 0

Why am I getting this message.  I have an array formula in E614.  I am trying
to copy it across and down to fill the range E614:I633.  I have been copying
these arrray formulas across this range with no problem at all.
Now all of a sudden I have changed one of the functions within ...

I have many rows of daily data by employee. For example, at the minimum,
there will be 2 rows of data per employee by day for over 5000 employees. I
have sorted by employee by day and then executed subtotals by employee and by
day.

Can anyone tell me which Excel functions require sorted ascending arrays.  
For example, I know that the Lookup function only works if the array it looks
at is sorted in ascending fashion:
LOOKUP(LookupValue, Ascending Array)

Need help figuring out a large amount of data.  Here are the particulars.  I
have a large worksheet of data.  Data is sorted by location, then event date,
then total hrs. I need to calculate total hours used within each week for the
entire year, by location.  the data looks like ...

Need help figuring out a large amount of data.  Here are the particulars.  I
have a large worksheet of data.  Data is sorted by location, then event date,
then total hrs. I need to calculate total hours used within each week for the
entire year, by location.  the data looks like ...

I have a number in a cell that is in whole numbers that I needs to be
reported in $,000.  In the Format cells menu on the nubers tab there are
several (###.00) type cells.  I am importing a lot of data that is in million
of dollar and I want to convert to be reported in thousands ...

I need to count items in one column when the word active appears in another
column.
What I am trying to do is count all members who are "active" and who have a
shunt. Active and Shunt are in different columns and I know that I could just

I am trying to write a conditional formula that calculates the number of days
outstanding, as described below.  Here are the pertinent column designations:
Column P = Priority level (1 or 2)
Column R = Date Assigned

In my workbook, I have a bunch of worsheets, where I'm average all numbers
in one column. I'd like to add one more stat, to where I'd like to average
the last 5 #'s in a column. Only thing is that no column ends on the same
row, so I can't specifiy specific cells..

Hello - I am new to the Office Discussion Groups and am despartely looking
for some help.
I have data from a time management system that reports start time and end
time.

What function should I use to find the probability of 2 girls being absent
out of 5 total students being absent in a class of 25 total students?