Hi,
I am trying to work with the below formula:
=IF(TEXTJOIN("",1,AE3:AO3)>0,IF(ISNUMBER(SEARCH(CI1,A1)),TEXTJOIN("",1,AE3:AO3),"No"),"No Bank")
The range of AE3:AO3 should return the name of only one bank; this is a report that was exported to Excel from PDF and it did not put them all in the same column. If there is a bank in the range, it works, but the "No Bank" is where I am running in to problems.
I want to identify which cells do not have a bank name with the "No Bank". The "No" is a filler for rows that the formula does not apply to (there are six rows between each line where the formula applies).
I have tried <>0,=0,<0 and ISBLANK. None of them work.
Any insight would be appreciated!
I am trying to work with the below formula:
=IF(TEXTJOIN("",1,AE3:AO3)>0,IF(ISNUMBER(SEARCH(CI1,A1)),TEXTJOIN("",1,AE3:AO3),"No"),"No Bank")
The range of AE3:AO3 should return the name of only one bank; this is a report that was exported to Excel from PDF and it did not put them all in the same column. If there is a bank in the range, it works, but the "No Bank" is where I am running in to problems.
I want to identify which cells do not have a bank name with the "No Bank". The "No" is a filler for rows that the formula does not apply to (there are six rows between each line where the formula applies).
I have tried <>0,=0,<0 and ISBLANK. None of them work.
Any insight would be appreciated!