G
Guest
Hi,
I seem to have become a bit lost, hoping you guys can help, I am wanting to
replace a number of array formulas.
Example:
=SUM(IF((DUDListData!$T$2:$T$65536=DUDListData!$Y$1)*(DUDListData!$U$2:$U$65536=Summary!$G$2)=1,1,0))/SUM(IF(DUDListData!$U$2:$U$65536=Summary!$G$2,1,0))
I thought these were great idea, and they work great, but I understand I
should be using the offset and indirect functions to declare the ranges.
Is this correct? If so could someone give me a start to work on please. My
mind has gone blank on this one as I have never used these functions before.
Many thanks in advance
John
I seem to have become a bit lost, hoping you guys can help, I am wanting to
replace a number of array formulas.
Example:
=SUM(IF((DUDListData!$T$2:$T$65536=DUDListData!$Y$1)*(DUDListData!$U$2:$U$65536=Summary!$G$2)=1,1,0))/SUM(IF(DUDListData!$U$2:$U$65536=Summary!$G$2,1,0))
I thought these were great idea, and they work great, but I understand I
should be using the offset and indirect functions to declare the ranges.
Is this correct? If so could someone give me a start to work on please. My
mind has gone blank on this one as I have never used these functions before.
Many thanks in advance
John