=Small(AE:AJ). Columns J:U. How would I exclude Column K and Column P. The columns are needed, but they are not to be included in the ranking.
Thank you
Hello,
I don't really understand your question, but I assume you want to use =SMALL(J:U) but excluding K and P columns, if so then just split it up. =SMALL(J,L:O,Q:U)
If my assumption is wrong, please be more specific what it is you want, a sample file is nice to have too.
Br,
Anders
I apologize, I did not give you enough information. File is attached.
Thank you
Hi mymalone,
No file attached. Click on Start Upload after selecting the file.
Regards
Phil
My apology, here you go...
Hello,
First of all my apologies, I confused the SMALL function with the MIN.
You need to use the CHOOSECOLS function to build your array.
=SMALL(CHOOSECOLS(J8:U8,1,3,5,7,9,11,12),2)
See attached for an example.
Br,
Anders
