please activate the formulas

jack

Member
http://www.mediafire.com/file/dn516bh13fqf979/gerar_trios.xlsx/file
formulas as follows:
=INDEX($A6:$O6,SMALL(IF($A6:$O6<=4,COLUMN($A6:$O6),""),COLUMN(A1)))
=INDEX($A6:$O6,SMALL(IF($A6:$O6>=5,COLUMN($A6:$O6),""),COLUMN(A1)))
=INDEX($A6:$O6,LARGE(IF($A6:$O6<=4,COLUMN($A6:$O6),""),4-COLUMN(A1)))
=INDEX($A6:$O6,LARGE(IF($A6:$O6>=5,COLUMN($A6:$O6),""),4-COLUMN(A1)))
Note: these are all array entered formulas which are confirmed by pressing *CTRL+SHIFT+ENTER* to activate the array, _not just ENTER_. You will know the array is active when you see curly braces *{ }* appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
 

Sidebar

Top