I am running a Web Querry and importing a table into excel. I need to
deterime the sum of  of D:1 Based on A:2.
A:1 Customer   B:1 ETA Date   C:1 Labor$       D:1 Hours
A:2 Request     B:2 Duration    C:2 Total Cost   D:2 Material $

I have a query in MS Access that uses the monthname function.  When I try to
create a pivot table from external data (using the DB as the source) I get an
error that the function isn't supported in Excel.  Is there another function
I could use?

I need to insert a & symbol in a footnote in excel and it keeps disappearing.
(ie.  peanut butter & jelly)

When I paste data from information available on the web and paste it into
Excel the page view changes by removing the visible cell borders.  This makes
for a strange looking screen and makes cell selection tricky.
How can I restore the worksheet to the standard format?

In excel you have to protect the entire worksheet and then select a range
that can be edited.  You should also have a function if you want to protect
individual cells only or a range of cells and the rest of the worksheet can
be edited

I have a inventory spreadsheet that I load serial numbers on and o
sheet 1 I have look up tool. I need some help so I can create seperat
pages for each item, and have my lookup tool search through each page
Currently it only looks up on the one page. Ok Here is my code I hav

I created a pivot table that somehow interpreted one of my data points in two
different ways. In the table the value is shown as a left justified value and
a right justified value even though the source data is all General, Left
(Indent). So there are two of the same value in the ...

I have Worksheet 2 with a lot of data. I need to have an input cell on WS1
where I can input serch criteria ("text") as needed and it will then show the
results on WS1.
Any  help would be appreciated!

Hi I was wondering if anyone can help me with a formula that will calculate
times on a time sheet.  I tried =TEXT(P18-P15,"h:mm") but don'y think this is
the one. I have a shift start time for example 8:26 AM and shift end at 6:15
PM and would like my hours worked to be ...

Lets say that I get a soduko grid in the beginning.  The grid starts
with a couple of number, but I would like to know all the other numbers
with the constraints.  How would I solve the soduko using excel.
Thanks

OK I have 2 spreadsheets.  They are very simple and so is what I want t
do...I just can't seem to figure it out!
*SS 1* shows which weeks a child will be attending a daycamp program.
"N" means they are not attending.  4964

I must set up a spreadsheet and extract the last and next-to-last entries in
certain columns.  Those values will be linked to another sheet in the
workbook entitled "Summary".  The columns are set up as shown below.  I have
a second set of columns which are from 14:00 Friday July ...

I need help with a form to be used by many people.  There are severa
fields that I would like to have populated with text, date, phon
number, etc. before the user can save the form.  Is there any way t
force someone to enter a field prior to saving the worksheet

I'm trying to write a function which returns the quantity purchased
from the most recent order given a list of customers, order dates, and
quantities.
Input would look like this:

I am having a problem with the following function:
=ROUNDUP((C5*C4),2)
Upon entering the above the cell shows: "#VALUE!" when cell C4 i
empty. I would like it to show zero when cell C4 is empty