ExcelBanter - how do i get the intersection of two arrays in excel?

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - how do i get the intersection of two arrays in excel? (https://www.excelbanter.com/new-users-excel/56665-how-do-i-get-intersection-two-arrays-excel.html)

Bibhu

how do i get the intersection of two arrays in excel?

Niek Otten

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
...

All times are GMT +1. The time now is 05:10 PM.