Thread: how do i get the intersection of two arrays in excel?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Niek Otten
 
Posts: n/a
Default how do i get the intersection of two arrays in excel?
The intersection operator is the space character
So "Array1 Array2" will give you the intersection, or #NULL if there isn't
any

--
Kind regards,

Niek Otten

"Bibhu" wrote in message
...



Reply With QuoteReply With Quote