I have a pivot table displayed in monthly columns.
I have rows grouped by a vehicle make, then by a vehicle model.
First value: Under each vehicle make, vehicle model, and month I have a row
value displayed as a whole number. This data is supplied from separate

I have a worksheet set up like this:
A3:A10=Employee Names
B2:AH=Months (April 2008 - December 2010)
I need a formula for B3:AH10 that will lookup on another worksheet to see if

OS: MS XP, Excel 2003
I have a table and using relative addressing to read down column B.
I can select the cell and make it active but don't know how to assign the
cell value to the variable.

We manually enter order numbers in one column of our spreadsheet, which are
usually, but not always sequential.  Can I use validation to alert when the
next entered order number is NOTa sequential whole integer? Thanks for any
assistance!

I know I've asked before, but didn't receive any response, so maybe it's how
I asked.  Let try again.....How do I create a spreadsheet to track order
quantity vs. quantity receipts?  I need to make sure we order appropriately -
but more importantly, the supplier ships a ...

Looking for a way to Track Last years sales  and this years sales along with
Total sales last year.

Greetings, i am looking help on following. I have 4 columns in worksheet 1 -
Name, Dept, Salary advance &  Salary to be paid,  in worksheet 2, I have list
of names. Every month i need to take worksheet 2 containing list of names and
search in worksheet-1, if i find a match need ...

I have received 3 responses to the question that I posted.  Each e-mail
notification contains a link that is supposed to take me to the response.
HOWEVER, the link instead produces a blank page (a new Internet Explorer page
whose content is white space, with the word DONE in the ...

In one column I have City State and Zip info.  In a nearby column I am
attempting to extract data simply the state and zip.  For example in the
first column I have "Clanton, AL 35045".  I am attempting to simply put "AL
35045"  In a second column.  The function I am using is

Good morning, I have a list of names (several thousand) that I have imported
into Excel. I will have to import an updated list around once a month. Is
there a way to have my current list add only the new names that appear on the
imported list versus replacing my list with the new ...

I am using Excel 2007 with Win XP.
I am trying to create a current inventory count in column B of each row of
items.  The count as inventory comes in or goes out will be located on the
same row, in every other column starting in column H.  In other words the

I am using Windows XP and Excel 2007.
My problem is visual--I have old eyes. When I have a range of cells
highlighted for data entry, I cannot clearly see which is my active cell. The
color differences are just not that distinctive for me. Is there a change in

In my worksheet, Column A1 has project start date and A2 to A3000 has
subsequent dates based on A1. Column B has data. After each 14 days, there is
bi-weekly total. I would like to add a row on top, which will show me
bi-weekly total for the current week. So, let's say, if ...

What I'm trying to do is, in one cell, get a count of unique values in
a column that, in the adjacent column, do not have a value of 0.
For instance, if my table looked like this:
A    1

I already have the following formula in this cell but I also want to add that
if the sum is greater than or equal to 4, it will turn red and/or have a pop
up message.  Any help is appreciated!
=SUMIF(C3:CE3,">=" & DATE(YEAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY())),E3:CE3)