Hi,
I've been having a look at the various threads already on this but every time I try it it doesnt work.
I have been trying this Array Formula which I believe in theory should work.
{=SUM(--(FREQUENCY(IF('Raw Data'!K:K="152",'Raw Data'!F:F),'Raw Data'!F:F)>0))}
What I need to do is count the number of IDs appear with the error code 152.
K is the column with the error codes and F is the column with the IDs.
Any help would be great!
Thanks,
Michaela
I've been having a look at the various threads already on this but every time I try it it doesnt work.
I have been trying this Array Formula which I believe in theory should work.
{=SUM(--(FREQUENCY(IF('Raw Data'!K:K="152",'Raw Data'!F:F),'Raw Data'!F:F)>0))}
What I need to do is count the number of IDs appear with the error code 152.
K is the column with the error codes and F is the column with the IDs.
Any help would be great!
Thanks,
Michaela