I have read many posts on this subject, and thought I figured it out.  But
the formula result is 0.
I have data in a tab named Data.  Column AA is the ticket number.  Column AE
is the ticket level (1,2,3 or 4).

i am trying to simplify my work load by creating a drop down menu for each
line of my packing slip..is this possible?

I need to extract the second "word" from a Cell.
The data comes from a database, which I do have some control over.  I'm
importing into Excel so that I can create new "elements" in order to  do
charts.

I have a circular reference designed to iterate  and recalculate when I
change an input cell.  When the input cell causes the calculation to result
in a ##NULL value I have to click on one of the cells in the circular
reference, then click on the formula bar and then press enter ...

Good morning...
I have a situation where I would like the formatting of a % number to follow
the rules:
- if the number has no decimal then print the number as is  for instance 98%

I posted last week on this problem I am trying to solve.
Sub stantiate()
Dim myRange As Range
Set myRange = Range("C10:d1000")

From the information below, I'm need a formula that when
the column A1:A3 = 6/27/07 AND column C1:C3 = in, then count column B1:B3
date           count        in/ot/dd        
6/27/07       10               in

Is there a way to assign the criteria for DSUM (or a similar funciton)
without giving a range cells but a string literal or formula?  I came
up with something that works a little bit but is still having
problems:

I'm very familiar with highlighting the document area, and choosing a column
to sort by depending upon my desired sort criteria (last name, state, etc).
Are there any methods or formulas which are able to automatically sort, and
take into account the rows and columns that I tend ...

I have a macro that counts the number of cells with a specific color and
totals the number in a separate cell.  How can I get the totals to
automatically update when I change the color of a cell?  
Thanks in advance!!

I HAVE A CELL WHICH IS IN TIME FORMAT WHICH I WANT TO CONVERT TO MINUTES AND
HAVE THE RESULT PUT IN ANOTHER CELL. FOR EXAMPLE I HAVE 10:00 (TO REPRESENT
10 HRS) AND NEED THIS CONVERTING TO MINUTES IN ANOTHER CELL. NO MATTER WHAT I
TRY I CAN'T GET IT TO SHOW 600. PLEASE CAN ANYONE ...

Can't seem to find the right formula string to subtract a $ value from a true
$ value based on a specific < or > "day" of the month - $ penalty charged
based on the "day" value is received.

My office manager just asked me to post a question to this group......
She is creating a spreadsheet for our agency "Mailing List", and wanted to
know if there was a formula or method for detecting possible "dual entries"
and deleting the older entry. Unfortunately she is grabbing ...

How do I include $x.89 value in the below formula to add $0.05 with the $x.09
& $x.59 value?

I have a worksheet with about six cells with out borders in the middle of a
bordered page. I can't seem to find the correct selection in the new Excel.