Jun 04 2022 03:00 PM
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 = " " ( Means Blank )
O10 = " " ( Means Blank )
O11 = " " ( Means Blank )
O12 = True
so i just want in Summary sheet to get only "True" in column O in main sheet and if true give me the J cells
so what i used in Summary sheet in A5 is : =IF(Main!O5,Main!J5,"")
so what i get was :
A5 = give me what i need
A6 = " " ( Means Blank )
A7 = #VALUE!
A8 = " " ( Means Blank )
A9 = #VALUE!
A10 = #VALUE!
A11 = #VALUE!
A12 = give me what i need
So i just need only to get ( give me what i need ) row under row without ( #VALUE! and " " ( Means Blank ) ) how can i get that ? and get rid of ( #VALUE! and " " ( Means Blank ) ) ?
Jun 04 2022 08:16 PM
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;"")