Imbedding exclusion criteria into Large function

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.

Sure thanks. The file is attached. It is a trimmed down version of the file I am working on. The cleaned data tab is all of the information I am pulling from. The Dashboard tab is in the beginning phase. Do not pay attention to all of the boxes. I copied the first one over a bunch of times because I am going to be ranking different things. If I get help with the first one I can work with the rest. the box on the Dashboard in cell B6 through F18 is ranking the top malls based on total % change over prior period. There are three malls that I need to exclude because the prior period was zero so it is showing them at the top. They are the UNIONTOT, 2339TP and 2341TP.

Hello,

Thanks. I am doing the CSE but it still isn't working. It works with the one if statement but as soon as I add the other two to exclude it ends up not giving me the right result.

I think this may be working.

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

with a CSE after.