Hi,
You can use the following array formula (Ctrl+Shift+Enter)
=if(or(exact(A3,$B$3:$B$80)),"",A3)
Regards,
Ashish Mathur
"orbojeff" wrote:
I have 2 Columns A & B
Column B contains all of the data in Column A and then some.
I need a function that will show all of the extra items in Column B.
|