Hi,
I am new to excel, i need to find the row values in a column A which are not present in a list of values in column B
For example
Column A ColumnB Column C
1 1 TRUE
2 2 TRUE
3 3 TRUE
4 5 FALSE
5 TRUE
6 FALSE
3 TRUE
4 FALSE
2 TRUE
1 TRUE
I want the result as true/false in column c or any other suitable way
thanks in advance
regards
NA
Bookmarks