Hi All.
I need a great help.
I have 4 columns say A B C D.
I need to compare together if each values in column A and Column B present in Column C and Column D array.
Example:-
A B C D
1 A 1 A
23 B 3 C
3 C dfg sdfg
4 D df dffs
5 E dsf fsdf
So on comparison v get only (1,A) and (3,C)
pls do get me the formula so that I can replicate for others.
Thanks
Bookmarks