Forum Discussion
sort began to include false results within the sort rather than filtering them
The following formula previously sorted AZ30/Q30 thru AZ629/Q629 in sequence. At some point in its development the sort began to include false results within the sort rather than filtering them to the bottom of the sort. Can someone inspect my code to see why this problem has occurred?
=IF(AND(
AD30<=AE30,AF30<=AG30,AH30<=AI30,AJ30<=AK30,AL30<=AM30,AN30<=AO30,AP30<=AQ30,
P30>=$X$13,Q30>0,BA30=$BB$18,
((BC30>=0.05)+(BD30>=0)+(BE30>=0)),
BC30>=0.5,BE30>=$Z$13,
AV30>=53,AW30<=AX30,AX30<=AY30,
(($E$21>=0)+($F$21>=0)+($G$21>=0))),
(AZ30/Q30),"")
3 Replies
This issue is now resolved. I turns out that the reference BC30 that appears outside of the parentheses makes a spreadsheet modification after the sort, and in some cases make some rows in column R false. Thank you all for attempting to help Greg Bonaparte
Hi Greg,
From formal point of view your formula is correct and if you drag it from row 30 down it shall keep the logic. Please give bit more details what exactly is wrong.
- Can you maybe post some example data or an explanation of your problem? It's almost impossible to follow your function at present without context.
If you are in Office 365 then a SORT / FILTER function combination might be easier.
