I tried to use the indirect function (i.e. indirect(A3)) where A3 contains a
number (say 3), but the result came back as #REF.  Any idea what caused the
problem.
Thanks,

This one has me stumped. Here is a sample of my data. There are actually on
the order of 10^5 lines. This set was ordered by "OrderNum" but the normal
order is by "SeqNumAAE". I hope the data displays well enough to see.
Anyway, what I need is to determine the initial quantity. ...

How do I use Excel 2007's Lookup function to find information on another
spreadsheet in the same workbook and display that information into cells
corresponding with the information?
For my project, I am needing to type in the Product ID Number into a cell in

I would like a running total to be updated in one cell based on that cells
total plus a number added from a different cell.  Setting up the iterations
per the excel help I was able to accomplish this for one cell.  Using the
same formula in any other cells in my spreadsheet ...

Excel "helped" me construct this (it told me I should correct my function to
the following)
=IF(I2="",(F2&" "&G2&" "&H2),OR(IF(F2=""+AND(I2=""),(G2&" "&H2)),(F2&"
"&G2&" "&H2&", "&I2)))

I am working on a workbook that is several pages. I have one page that gives
me a total that i need to appear as text in another worksheet. How would I
get $100.00 to appear on another page as One Hundred Dollars and No Cents?

I have data that contains a variety of dates that I have sorted by date. I
am trying to count the nuber of occurences in a given month. EI:
Customer x 1/1/07
Customer x 1/1/07

Though the subject explains the question, I would still like to elaborate on
what i need.
The comment that we enter in the cell, it has your windows login ID by
default. I want the comment to have today's date by default instead of the

I need help to fit rows or columns to content in Excel 2007

I need to have a 16 digit number with - between each number.  I created a
custom format, however the 16th digit always reverts to 0 (zero).  I need
this to accept all the numbers that are entered into the field.  We are on a
deadline so any help is appreciated.   I have tried ...

I want to view the set of records that were counted by the SUMPRODUCT function.
=SUMPRODUCT((ReturnToAsset="")*(((DaysAfterExpy<30)*(CEAName<>""))))
The answer was 14.  How am I able to see which 14?

...into a single occurance. I have 1 sheet that can have multiple text
(Client) entries, duplicates permited. On another sheet I would like to see
each text entry only once. I'll use this "field/result" with a sumproduct to
determine total items by Client.

I have this formula that works in excel.
=IF(AND($K$2>(SUM($U$2*0.8)),$K$2<(SUM($U$2*1.2))),"true","false")
And when I try to get it as conditional formatting I get the "not enough or
too many parenthesis" error.

Good day im opening a cafeteria in the hospital and i need a proposal please
give me an idea thanks durrah

Have data on a spreadsheet:
Shipdate     Quantity
The data goes back 5 years, and is constantly updated with new
shipments being added.