Forum Discussion
Excel Formula - Calculating the difference between the two identical values out of four and....
I have four data columns in an Excel worksheet, B:E. Sometimes there are two identical data values in a row. This is indicated by the 2 value in column F. I'm trying to write a formula that, when th...
Hi, to both!
You could try this shorter formulas:
[Q2] : =IFERROR(AGGREGATE(15,6,1/(1/(MODE(B2:E2)-B2:E2))/(ABS(MODE(B2:E2)-B2:E2)<2)/(ABS(MODE(B2:E2)-B2:E2)<>1),1),"")
[R2] : =IF(Q2="","",IF(ABS(Q2)<1,"BEST","GOOD"))
Check file with formulas applied. Blessings!