Hi -
Im trying to enter an array formula into VB if possible - i know the formula is too big but struggling to get it to work.
the formula im using is entered in Cell C180 and looks like this.
=SUM(--(FREQUENCY(IF('Raw Data Prev Year'!$B:$B<>"",IF('Raw Data Prev Year'!$D:$D=A171,IF('Raw...