Rsq in array formula case

[iknowu99]

Hi All,
there are many formulas that should be created in this case and the example narrows it down to 2. first column identifies trial number, second column is x axis date and third column is y axis, height.

i'm trying to use array formula =IF(A:A=A2,RSQ(C:C,B:B)) and cntrl+shift+enter but getting false

trying to get column D to say 2.02% on D2-D17 and 4.5% on D18-D32

this way i can copy unique trials only to another location and vlookup to get each individual percent....

data:

numb	date	height	Rsq
1	5/5/2010	10	FALSE
1	5/6/2010	15	FALSE
1	5/7/2010	16	FALSE
1	5/8/2010	45	FALSE
1	5/9/2010	56	FALSE
1	5/10/2010	65	FALSE
1	5/11/2010	8	FALSE
1	5/12/2010	78	FALSE
1	5/13/2010	69	FALSE
1	5/14/2010	10	FALSE
1	5/15/2010	15	FALSE
1	5/16/2010	16	FALSE
1	5/17/2010	45	FALSE
1	5/18/2010	56	FALSE
1	5/19/2010	65	FALSE
1	5/20/2010	8	FALSE
2	5/21/2010	78	FALSE
2	5/22/2010	69	FALSE
2	5/23/2010	10	FALSE
2	5/24/2010	15	FALSE
2	5/25/2010	16	FALSE
2	5/26/2010	45	FALSE
2	5/27/2010	56	FALSE
2	5/28/2010	65	FALSE
2	5/29/2010	8	FALSE
2	5/30/2010	78	FALSE
2	5/31/2010	69	FALSE
2	6/1/2010	10	FALSE
2	6/2/2010	15	FALSE
2	6/3/2010	16	FALSE
2	6/4/2010	45	FALSE

 

[iknowu99]

solution:

=rsq(if(a:a=a1,c:c),if(a:a=a1,b:b))
and cntrl+shift+enter

 

[RSXchin]

user delete post