Formula to check equal or greater than 2 among results

Question

Good morning,I have to do a very speciffic query where I have some columns with different data and I was wondering if I could create a formula in order to do it automatically.The thing is that I need to know if any of the columns value is the double (or more than the double) higher than the second highest value between these columns. And to obtain as an answer the lablel of the column that has this satisfactory value.For example, imagine we have:Language&nbsp;&nbsp;&nbsp; SVO&nbsp;&nbsp; SOV&nbsp;&nbsp; VSO&nbsp; VOS&nbsp; OSV&nbsp; OVSAkkadian&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 29&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0In this case, the value in the SOV column is the double or more higher than the second highest value (SVO or OSV), so the answer would be: SOV.If there is no column with this double value, the result would be: no dominant order.Is that technically possible? I know it's very speciffic and I can't reach a formula that fits these requierements.

oliverscheurich · Accepted Answer

ToniBrosa&nbsp;=IF(LARGE(B2:G2,1)&gt;=LARGE(B2:G2,2)*2,INDEX($B$1:$G$1,MATCH(LARGE(B2:G2,1),B2:G2,0)),"no dominant order")Does this return the expected result?&nbsp;

Forum Discussion

Formula to check equal or greater than 2 among results

Share

Resources