I've got this formula that works if my lookup range is in ascending order.
=VLOOKUP(A41,INDIRECT("'[Name "& M$25 &" 07Analysis.xls]Overall Top
Ten'!$AA$2:$BJ$401"),MATCH($V$3,INDIRECT("'[Name "& M$25 &"
07Analysis.xls]Overall Top Ten'!$AI$1:$BJ$1"),0)+8)

How do I move formulated data from one worksheet to another? I have a master
worksheet that uses simple formuals such as =sum(b8/c8) and I want to take
the answer and apply it to a diffrent worksheet in the same work book but I
get the #REF! error.

I would like to know how to update another worksheet in the very next column
as the main worksheet is updated... Currently when I update rows a1 and a10
on main page, a1 and a10 are updated on the linked page.. What I am looking
to do is update rows a1 and a2 on the linked page ...

I am trying to write a formula that will count the unique values in an
array.
I have been able to get this far...
Month      Branch    Item

I have a database with employee name in column 1, hire date in column
2, and termination date in column 3.  I need to be able to provide
reports showing who has been with the company <30 days, 30-60 days,
61-90 days and over 90 days.  THIS part I have figured out and have it

I have a worksheet where the first column contains a special code
specific to each product we sell, containing a code for 1) the
territory where it's sold; 2) the vendor; 3) the product name; etc. I
am trying to figure out a way to create a sumif formula (or other

I am trying to create a check register type spreadsheet, and wanting to use a
UDF,(or if you know another that will work too) to automaticly find the last
balance in the balance colum and return it in the cell at the bottom of the
page.  Heres what im trying but it keeps locking ...

I wish to multiply then add arrays of numbers of different size.
eg
array 1: A1:C1
array 2: A5:A8

Is there a way that following could be used without an array
=IF($C6="","",IF(ISERROR(INDEX(Matrix!G$5:G$475,SMALL(IF(Matrix!$C$5:$C$475=$C6,ROW($1:$471)),COUNTIF('Matrix
REPORT'!$C$6:$C6,'Matrix
REPORT'!$C6)))),INDEX(Matrix!G$5:G$475,SMALL(IF(Matrix!$A$5:$A$475=$C6,ROW($1:$471)) ...

Is it possible to start a timer and stop.
Timer should start when i add a value in a cell and it should stop when i
add a value in another cell.
Thanks in advance

i have a work sheet that i am trying to have it count the total number in
months.  I have several different months in the same colom.  and need to have
it count the total for that month.   if i sell 200 in may and 300 in april
and 20 in june .  

I am trying to create a check register type spreadsheet, and wanting to use a
UDF,(or if you know another that will work too) to automaticly find the last
balance in the balance colum and return it in the cell at the bottom of the
page.  Heres what im trying but it keeps locking ...

COL A: Items
A1: "Item 1"
A2: "Item 2"
A3: "Item 3"

I am attempting to set up a spreadsheet to monitor time worked.  I changed
the cells for the time format, ie. 06:00.  I need cells for the following,
start time, end time, total time worked, hours over 8 hours, (for overtime).  
I have been able to get the time worked from the end ...

I have a worksheet where the first column contains a special code
specific to each product we sell, containing a code for 1) the
territory where it's sold; 2) the vendor; 3) the product name; etc. I
am trying to figure out a way to create a sumif formula (or other