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 ) ) ?
Bookmarks