I have revenue numbers for 2007 and 2008 in columns, I need to do a vlookup
(i think) that will classify into four columns demarking wih a check mark
whether column 1 - the revenue increased, column 2 - revenue was new for
2008, column 3 - decreased and column 4 -if it decreased ...

Is there a way to return a value from a row using two variables from the same
row?
For example
Account#      Date             Value

it should look like =sUM(a1:a3), without all the brackets etc.

I have a basic sheet that refreshes external data based on what someone
fills in for starting and ending dates in a couple of cells.  The data is
just a bunch of customer order lines that have the customer id, part, qty,
price, etc.

Hi Experts:

Hi Experts:
I would like to build a macro with the List for multiple individuals that
will then enter the data from the List to the Summary Worksheet in the same
Workbook.  This is the example of what I want to do....

Sorry for reposting but
Still having trouble.
Column A is (A2:A130), ascending, and is my Vendor list and is named
"VendorList" and resides on a worksheet named "Lists".

X= the max that can be given
S= what clients already have
T= what can be given to get the max (X)
U= what is needed to get to the max

I have the following GetPivotData formula
=GETPIVOTDATA("Sum of ProjEstV.Value",'Validated Value Pivot'!$A$6,"Status
Month","2008-04","Sum.OI Category","Other","OI Goal
Category","OPS","CloseOIYr","","Status","Assigned")

How do you shade multiple total rows in a pivot table on one click?

while playing around, i did something that seems to have disabled my
"data-validation" drop down list in a range. it seems to have something to do
with auto fill.  can anyone perhaps help?

quando estou a trabalhar em excel e tento mover o cursor para mudar de caixa,
ele nao muda e o ecran é que se mexe.
qual a solução?

hi,
i have a formula
=IF(E6="Casual",VLOOKUP('Product Detail'!L6,Types!D4:E14,2,0),IF(E6="Dress",VLOOKUP('Product Detail'!L6,Types!A4:B12,2,0)))
when i drag it down to the rest of the cells i want only E6 to become E7 and grow each time i drag the formula down.

I have created an Excel worksheet using the Vlookup command in a beginning
cell. this is to determine what month I'm in and determine what the 1st day
of the month is on. The next line I want to automatically continue down the
page to insert the next following day, and finish off ...

Is there a simple way to convert from angles in degrees, minutes and seconds
to decimal degrees?
eg 45°30'00" = 45.5°