sort(), filter() and IF() combined
I have a formula:
=SORT(IF(AX2 = “1+1”; FILTER(A2:J200; E2:E200 >= MAX(P:P)); 1; 1); FILTER(A2:J200; E2:E200 >= INDEX(P2:P200; X4-1)); 1; 1)
I want to sort a column by a condition statement.
For example, if the statement is true I want to filter and sort the numeric column with values only bigger and equal to the max() function result,
otherwise, I want to filter and sort the numeric column with values bigger or equal to max() – 1 (the preceding value).
Are there any workarounds for this, because the Excel pop-up with the window “can’t calculate this formula” without helper columns if possible?
I have a formula:=SORT(IF(AX2 = “1+1”; FILTER(A2:J200; E2:E200 >= MAX(P:P)); 1; 1); FILTER(A2:J200; E2:E200 >= INDEX(P2:P200; X4-1)); 1; 1)I want to sort a column by a condition statement.For example, if the statement is true I want to filter and sort the numeric column with values only bigger and equal to the max() function result,otherwise, I want to filter and sort the numeric column with values bigger or equal to max() – 1 (the preceding value).Are there any workarounds for this, because the Excel pop-up with the window “can’t calculate this formula” without helper columns if possible? Read More
