Note I mistakenly posted this in "excel.misc". Not trying to cross post.
Sorry.
Hi,
I have two columns 300+ rows long. One (A) contains names. One (B) contains

I need a formula that basically works like this....
If the total (currently =F14-F47) is less than zero show zero, else
show the number.
any suggestions??

Has anyone solved the mystery of Data Validation drop downs going AWOL?
I ran a macro to clear Web stuff (shapes, hyperlinks etc.) and its
impossible to get DV back on this sheet. I had to copy and paste to another
sheet and re-enter the DV.

I have a table that looks something like:
Group variety
1    taco
1    burrito

I have multiple consecutive rows that get information from every third row
earlier in the spread sheet, is there a way to reference my 2nd row to the
first row in a formula.
Example:

Below is a portion of some code I have.
It works fine up to the point that I have noted.  When I step through
this,
it works fine.  Just before the step that I flagged below, I can use

 I have inherited several MS Excel templates that have external querys to a
MS Access database.   The Database has moved, now when opening the template
it gives the following error: "[Microsoft][ODBC MS Access Driver] The
Microsoft Jet database engine cannot find the Table or ...

I would to automatically lock/protect cells after entering data.  Is this
possible and how do I do it?
Thank you in advance for your help.

I have a spread sheet where several items are
preceded by an *.
I need to remove them, I tried "replace with" but everything I tried removed
all data, I guess because * means any words.

I need a crash course on macro and forms,
Specific thing I need to know how to do is to create a sheet that gives me
the specific salesperson on a specific zip code when entered on the zip code
blank field.

I want to show a column of data (% of City) as a % of a sub group
total.  Here's my example of how the pivot table should look:
State   City       Carrier    Sq Yards    % of City (Sq Yards2)
Alabama

Why does COUNTIF see "01" and "1" in text formatted cells as equals? I need
them to be seen as different. These should be evaluated as different in text
formatted cells. In numeric formatted cells the leading "0" would not be
displayed.

I am trying to find a means to track the different grants we get for our
research that also provides a means for our Executive Director to quickly
view them for their status.  I found a workbook at a non-profit website that
has 3 sheets:

I'm trying to figure out a way to format cells so that I only have to input
minutes and seconds only, rather than having to type in the hour as well.
Is there a way that Excel will do this automaticaly, or is there a way to
format without the hour being included?

Error: 'The document was saved succcessfully, but Excel cannot re-open it
because of a sharing violation. Please close the document and try to open it
again.' Not sure what angle to take on this. She has full rights on the
directory where the files are saved and it doesn't happen ...