Hello,

I have a large set of data that I am trying to build KPI's off of. There are some items in the data that I need to exclude because they are giving me false results when calculating the large function to rank top 10. I used the following array formula.

=LARGE(IF('Cleaned Data'!$F:$F<>"UNIONTOT",'Cleaned Data'!$BG:$BG),Dashboard!B9)

This formula however only excludes one of the three items. I have tried imbedding more if statements, I tried using AND as well as OR and none of them are working. The other two items are 2338TP and 2341TP. Any help would be appreciated.

Thanks in advance.