View Single Post
  #5   Report Post  
Ashish Mathur
 
Posts: n/a
Default

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.