I have two lists of items.  The first is, for example 50 items - List A.  I
want to look at another list (shorter, say 10 items - List B).  I want to see
what items in List A have a matching item in List B and return a value in
that row.  

Hi, I'm trying to select the highest value in a column (which I can do with
=MAX), but only if the value in an adjacent column is a negative number e.g.
           A       B
1         10      18

I started a side by side compare in excel and the program closed abnormally
before I closed the side by side compare and now when I call up this
worksheet, there are two worksheets with the same name except one is :1 and
the other is :2 at the end of the name.

If Edit, Paste Special values strips the formulas from a range and leaves the
values, I would expect Edit, Paste Special, Formulas to do the opposite. But,
it doesn't. So, I have two questions: 1) Is there anyway to copy a range and
paste just the formulas in the result?  2) What ...

All my searches have lead me to ways to eliminate duplicates in a
column- not what I'm trying to do... If the value in column C is the
same as the value in column D for the same row, I want to erase it. Is
there an easy way to do this? (I think I remember reading about a way

Hey guys,
I'll try to explain this as best i can...i'm creating a (I'm using this term
loosely) "form" for my sales guys to fill out.  I have three fields for them
to fill out and i want to do a drop down choice for them on each one.  

This seems like it should be something so simple, but for some reason
I haven't been able to come up with a solution:
I'm counting gift certificates.
Column A has their numbers, some in ranges like cell A1:

I have in worksheet 1 a list of names in order with more data, but there's
same places without a number, like this:
1    Mary    AL    6665xxx
3    Peter    PT    6654xx

I am trying to figure out why sumproduct is suddenly returning #value!
At JE McGimpsey's suggestion, I have been using the following formula
as a double check on a spread sheet
=SUMPRODUCT(ROUND($F$63:$F$549*L63:L549,0)), it was working

I made the rows and columns bigger but I still cannot see the contents of the
cells.  When I click on a cell, the contents display in the formula bar, but
not on the sheet.  PLEASE HELP!

I am setting up a shared Excel document for a group.  Each member of the
group will have an individual worksheet identified on the worksheet tab by
their initials.
How do I set up the workbook so when a user opens it, it will go directly to

Hey guys
I've created a "sheet" for our sales guys to fill out...i've given them a
drop-down (validation list) box with their accounts that they can choose
from.  I'd like to have the cells grey until they choose their account name

I have a spreadsheet that has 2 columns of dates.  In the first column, I
want to find the earliest date and in the second column, I want to find the
latest date.  Is there a function within excel that will find that
information for me?

I need to create an excel formula that is tiered,in that when using drop down
menus, the selection you make will determine the  "consider list" for the
next cell.
Example: A1=1, then selection for A2 is A,B,C,D, etc.

I have a data set that I would like to run a linear regression analysis on.
Can Excel help me with this and if so how do you do it?