Forum Discussion
Return only values that's include true only
Hello guys, So i've two sheet ( Main , Summary ) In Main sheet i've O column that's have True , False and blanks like : O5 =True O6 = False O7 = " " ( Means Blank ) O8 = False O9 = " " ( M...
That means O7, O9, O10 and O11 are not empty cells but contain some spaces or other invisible characters in them. Try replacing your formula with the following one and see if this works for you...
=IF(Main!O5=TRUE;Main!J5;"")