Hi,
My formula is counting unique values based on multiple criteria and I've used the frequency formula but I believe because my data set is so large it makes my array huge and so it takes a lot of time and memory to process the formula. Is there a better way to write this formula or calc something off my data set to help? Thanks!!
=SUM(IF(FREQUENCY(IF('CC Data Translation'!$C:$C=$B47,IF('CC Data Translation'!$M:$M=BW$11,MATCH('CC Data Translation'!$L:$L,'CC Data Translation'!$L:$L,IF('CC Data Translation'!$M:$M=BX$11,MATCH('CC Data Translation'!$L:$L,'CC Data Translation'!$L:$L,IF('CC Data Translation'!$M:$M=BY$11,MATCH('CC Data Translation'!$L:$L,'CC Data Translation'!$L:$L,0))))))),ROW('CC Data Translation'!$L$5:$L$80000)-ROW('CC Data Translation'!$L$5)+1),1))
Bookmarks