Hi alL
Please see my sheet. In column N I have a formula which will be dragged down. I have an IF Formula in column O which should return 1 if the opposite cell in column N is not blank (has numbers). If the cell is blank, I want nothing displayed in cell O. However, I have a formula in column N to be dragged down so need the IF formula to ignore this and return nothing as the cell is blank. How do I do this?
thanks!
Thanks,
R.
Where to the values in column J come form?
maybe this...
=LET(j,J2:J5000,Suj,SORT(UNIQUE(FILTER(j,j<>""))),a,A2:A5000,c,C2:C5000,r,INDEX(a,MATCH(Suj,c,0)),CHOOSE({1,2,3},r,1,Suj))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Hi rayted,
It's because your formula in column N inputs a space rather than returning blank if it returns an error. Change it to "", rather than " ".
=IFNA(INDEX($A$2:$A$50000,MATCH(P2,$C$2:$C$50000,FALSE))," ")
Regards,
Snook
Try
=IF(N2=" ","",1)
N is set to " " by its formula
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
perfect thank you all.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks