I have this formula (which works) to highlight only those entries that match a string entered into a search box. I need to exclude those rows where column A has a value (starting at row A5) in any row. The current formula is this:
我有这个公式(有效)只突出显示那些匹配输入搜索框的字符串的条目。我需要在任何行中排除列A具有值(从第A5行开始)的那些行。目前的公式是这样的:
=IF(ISBLANK(Search_box),0,SEARCH(Search_box,$B4))
And it works well but highlights ALL rows where the search string is valid, whether or not there is anything in column A. I want to exclude those rows where there is a value in any row in column A.
它运行良好,但突出显示搜索字符串有效的所有行,无论列A中是否有任何内容。我想排除那些列A中任何行中有值的行。
Thank you in advance. Kevin
先谢谢你。凯文
1 个解决方案
#1
0
Include another if statement that tests whether there is something in Column A (and print 0 otherwise). For example, it would be something like:
包含另一个if语句,用于测试A列中是否存在某些内容(否则打印0)。例如,它将是这样的:
=IF(ISBLANK(Search_box),0,IF(NOT(ISBLANK($A4)),0,SEARCH(Search_box,$B4)))
#1
0
Include another if statement that tests whether there is something in Column A (and print 0 otherwise). For example, it would be something like:
包含另一个if语句,用于测试A列中是否存在某些内容(否则打印0)。例如,它将是这样的:
=IF(ISBLANK(Search_box),0,IF(NOT(ISBLANK($A4)),0,SEARCH(Search_box,$B4)))