Hi,
I have one problem, want to compare two column and extract the data in 3rd column but the problem with my formula is that blank space are created how to remove it from in between.
Data:
Col - A
xxx01
xxx02
xxx02
xxx05
xxx04
xxx02
Col - B
xxx01
xxx02
xxx03
xxx05
Output
xxx01
xxx02
xxx05
Result Desired
xxx01
xxx02
xxx05
My formula is :
=IF(ISERROR(MATCH(L6,$H$5:$H$24,0)),"",L6)