I have a DataEntry sheet that allows for the entry of the date, and 6 points
of data (2 columns of 3) for each piece of equipment.  Every day, someone
tests the devices and records all 6 points of data on the DataEntry sheet.  
This is done for each piece of equipment that ...

I have a worksheet for my YTD business expenses.  Column C is Description.
Column E is Category.  If for example, Union 76 is in the Description
column, I want to the corresponding cell in the E column to be, "Auto: Fuel"
so all the descriiptions of Union 76 will be categorized, ...

I have a row of 6 random ordered numbers.  I with to find out how to
automatically copy them into another row and have them in Ascending numerical
order.  I'm at a loss to figure out what function can do this.
Example:

I would like to be able to have an email sent to me when a change is made to
a Excel worksheet that is shared.  How can I do this or can it be done?

Hello, I have a simple application which retrieves a list of users from
an Active Directory, and exports it to an Excel file.
Each user is on a row with columns A-E containing name, user name,
department and a few other columns. Column F and the successive columns

I am trying to use the VLOOKUP function to auto-complete an order sheet with
product information.
I am using the following formula in the C4 cell:
=VLOOKUP(B4,'Product List'!$A$1:$D$100, 4, FALSE)

I am using Excel 2007.
I am using the following formula to calculate the total cost based on 2 cells:
 The formula is in Cell "F3"   and is entered as this  =B3*C3
How can I keep it from displaying $0.00 when the fields are empty?

I am using the following Sumproduct command and it has been working great.
=SUMPRODUCT(--('[Past Dues Aug.xls]Sheet1'!$A$1:$A$5000="Tom
Bonnette"),'[Past Dues Aug.xls]Sheet1'!$B$1:$B$5000)
However, the Past Dues sheet I am pulling information from, the names in

I need a formula that will look a table with 3 columns and 13 rows in which
the data is:
OE Metric         SW List
0                  34,999,999     $27,930

if i start work at 7am and leave work at 5pm
how do i calculate the time worked using a formular?

I have large data consisting of around 500 rows. Most of them are
highlited with colour; I would like to count coloured cells only. Is
there any function or macro to support solve this problem
Looking for your guidence

In Colum "A" I have sub totals and I would need to find the GST and QST, I s
there any formula that will do it for you or would I have to do each sub
total manually and with a calculator

Hey guys,
I have to perform a DSUM function that has an AND condition in it in the
Criteria portion.
When I set up the DSUM function without the condition as below, I get an

I want to have a column which has a formula which multiplies an absolute cell
by a number which increases incrementally.
=1*$A$4
=2*$A$4

How do I get the worksheet to place the hyperlinked target cell in the A1
position, when I jump to the section I want on a computer with a smaller
screen I loose the left/upper area--
Carl in Vegas