=SUMPRODUCT(--(B2:B1000=(INDIRECT(ADDRESS(ROW(),2)))),T2:T1000)
returns #Value!
both
=(INDIRECT(ADDRESS(ROW(),2)))

On recording a macro in my personal workbook everything seems fine. If I
close down excel and reopen the macro has been deleted and the elements put
into the trash can. i assume I must have a setting somewhere that is deleting
the macro, but I don't know what. Please help!!

I have manipulated some data and managed to get the week number of each row
and the day of that week (a number from 1 to 7, 1 = monday, 7 = sunday) in
any particular year.
e.g. for today (27 Mar 2007):

I calculate the number of hours daily worked. I have column A: timeIn, Column
B: TimeOut, Column C calculates the total hours done, which is fine. I am
trying to enter a formula in column D which will say something like this: If
the number of hours in column C is greater than 4 ...

example:
IF A2 = "1",
shade cell E4 "green"
if A2 = 2, shade e4 blue

Re-post the question
Does anyone have any idea on how to determine the values under following
conditions?
Given a list of numbers sorted by ascending order from top to bottom under

I would like to look back my past post question, does anyone know how to
search my past question?
Thank you in advance
Eric

I want to set a constraint on one excel column so that when the input
is duplicate
with other column, excel sheet will refuse to accept. It's string
type. Does anyone

I Need to multiply A1 by B1, then A2 by B2, etc to get a column total (my
actual worksheet has 245 line items and about 20 column to multiply out and
total. Column A represents a $ amt and column B, C, D, etc represent Qty.  I
need a formula at the bottom of each column to ...

I want to transpose a list from a single column to a single row however I
only want certain items transposed not all of the list.
The items I want are the duplicates of peoples names so if a name appears
twice then I only want the second instance to be transposed into a row.

I have 2 worksheets in the same workbook where i'm trying to lookup store in
both.  In sheet 1 the store is entered normal, in sheet 2 it is preceeded by
'     spaces.
I tried using trim(sheet2!range)etc but get a #value! error.  I messed

Does anyone know how I can use SumIf to calculate the following?
Column  A    Contract    Hrs    Cost
212    31C1    10    12
209    31C1    12    40

I whold like to convert phone number(9886334401) to ********** only while i
give print out in certain cells ( this is to hide the ph number)
Manju

I have a column of time (0:08) I would like to count the amount of times the
time of 0:08 (for example) but I cannot get my formula of
=COUNTIF(S4:S128,"0:08") to count. This column is a subtraction of two times
=B4-E4, I copy and Paste Special the value into column "S"

I have a user who when he opens a workbook two versions of the same workbook
are opened.  In the titlebar the name of the work book appears with the two
versions of the same work book denoted by the name followed by a :1 or :2
depending on the version of the workbook.  My ...