I am trying to calculate the number of Customers within
each hourly period during the day - for statistical
analysis.  ie how many callers between 9 am and 10 am

Is there a way, and I believe there is but I cannot remember it, to show the
formulas in the cells instead of the values?

Is there any function or other way to have data in a cell
updated automatically from data in Access?
I have a scale program entering records into a table in
Access, and I need access to pass the data it recieves

I have been asigned an ICT project at college and I have lost an
knowledge I once had when it comes to using MS Excel.
To be brief, I have to have one field that will display a pric
according to which payment category has been entered in a differen

how can I write a formula that counts the number of cells
that contain numbers and then add up those numbers

I would appreciate any help...
I am working with a master price list in a worksheet from which I woul
like to select items and compile into a customer specific quote in
second worksheet...ideally I'd like to say "tick" a cell adjacent t

Hello everyon
we have a problem with the import from csv-files with semicolon with
vba-macro. in the past with the old system (windows nt 4.0 german wit
office 97 sp2) it worked without problems

In sheet1 there is a column A with numbers
A1 > 10
A2 > 15
A3 > 7

Is there a function or another way to convert a numeric dollar amount into written text
I'd like a $1,809.34 to convert to One Thousand Eight Hundred Nine Dollars and 34/100
I can easily figure out the cents portion to add to the string with concatnate but the rest I was hoping ...

I need to find the last cell that is filled in with a value.
Cells A1:A6 is the area and the user fill in values from A1 but all cells
are not always filled.
A1: 5

I was wondering if the data analysis add ins products onyl
come with office professional products or do they come
with the office standard products too?  I have students
who want to use the functions but cannot find them even

How do I get cell A3 to show the smaller of A1 or A2?
Thanks for any help.

What I have is in Row 3:
    A    B      C        D        E           F
3 Date  Ref   Hours   Revenue    Cost       Margin
Data is 400 rows deep

This is no doubt very easy but it's really bugging me.
I've achieved this with no problems using a button to set a macr
running, but its an ugly solution which I want to sort out.
I have a chunk of data in this sort of format:

Hi, does anyone know what the formula for the following
would be (or if it can be done):
In one column I want to insert a date of birth (Say,
Column A) and in the next column I want it to calculate