I have a column of data. I want to find all the values that do not equal any values from an array, one by one.
I tried defining a named value which was an array like this
={"value1","value2","value3","value4","value5"}
..and so on.
Which excel functions can I use to find values that are not contained in the array.
And why is the function not iterating through the array? It's only testing the first index.
I tried this: {=NOT(X8=NamedValue)}
And =MATCH(NamedValue, X3,0)
Both only test the first value in the array.
You should use Excel's MATCH()
function for this purpose. Supply 0
to the match_type
parameter. More information can be found on this link.
Examples of usage:
Pass hard-coded list of values to the formula:
=MATCH("dfs", {"erw","sad","dfs"}, 0)
Pass cell range to the formula:
=MATCH("dfs", C1:C15, 0)
この記事はインターネットから収集されたものであり、転載の際にはソースを示してください。
侵害の場合は、連絡してください[email protected]
コメントを追加