Forum Discussion
Solved
Formula to check equal or greater than 2 among results
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 tha...
=IF(LARGE(B2:G2,1)>=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?
=IF(LARGE(B2:G2,1)>=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?
OliverScheurichamazing!!!!!
I was having problems because it's quite a complex query (it seems for you it wasn't).
Thank you so much. I've done a short test and it seems that works perfectly.