MeraWindows Forums - Get your Computer Problems Fixed

Hi All ..
I think the below data explains  my problem very clearly.
I hav used DGet  function one a ell and succesfully retrived the value from the database (price - 400 ).
How can I extend the formula to the next row cell ???? Pls Help

INPUT DATA							OUTPUT DATA
Part no.	Part	Operation	Price				Part no.	Part	Operation	Price
ABC	Male	TRUE	400.00				ABC	Male	TRUE	400.00	DGET(INPUT,"Price",$H$2:J3)
ABC	Male	FALSE	350.00				ABC	Female	TRUE	#NUM!	DGET(INPUT,"Price",$H$2:J4)
ABC	Female	TRUE	200.00				ABC	Female	FALSE	#NUM!	DGET(INPUT,"Price",$H$2:J5)
ABC	Female	FALSE	125.00				ABC	Male	FALSE	#NUM!	DGET(INPUT,"Price",$H$2:J6)

Hi,

With ref to looping issue xls file:

• A person can do  any no. of job  in a day but the the sumation  of the jobs for a particular person on particular day has to be calculated .
• In this case I have to loop the n of rows where "n" is dynamic in nature based on no. of job done by a person on particular day.
• So, how and where  do I define the critrea  to select the n rows???? Which is dynamic in nature.??

with ref to your sol given:
 
IF(OR(COUNTA(C11:H11)=0,AND(C11=C12,D11=D12)),"",SUMPRODUCT((C$8:C11=C11)*(D$8:D11=D11)*(H$8:H11))-280)

above undelined  are applicable only to the records having to loop only 2 rows....

2-Dec-10	ABC	job1	125	1.50	187.5
2-Dec-10	ABC	job2	145	2.00	290		197.5
2-Dec-10	xyz	job2	200	2.40	480		200

In this case databse was minimal  ...so the comparision was simple...to loop 2 row ( fixed the loop for two by manually conclusion)
wat if the case is for "n" no of rows???? where n is dynamic?????????