Hello everyone,
I am trying to get the top 10 largest values in column E based on 3 arguments in column A, B and C. I tried the following for my top 1 for example:
=LARGE(IF(AND(A:A="All",B:B<>"Other",C:C="All"),E:E),1)
If I just press Enter, I get the #1 value of the entire column E (66.216), without qualifying for the 3 arguments. If I press Ctrl+Shift+Enter, I get 0.
Can I not use IF AND on an array ? If not, what would be the way to do it ?
Thanks in advance !
Susanne
Bookmarks