Good Morning,
I am needing some help as I am trying extract data from one column that is not in another. I have two named ranges called Passport and another called spreadsheet - these have an equal number of rows. I am trying to extract the unique data from the Passport column when compared to Spreadsheet. to do this I have set up another named range called "In Passport not in spreadsheet" This range is of the same length as Passport .
To extract the data I am using the following array in the "In Passport not in spreadsheet" column
{=IF(ISERROR(MATCH(Passport,Spreadsheet,0)),Passport,"")}
Unfortunately I don't get any return and I know there are a few unique entries.
Any suggestions will be greatly appreciated.
Thanks
Salar
I am needing some help as I am trying extract data from one column that is not in another. I have two named ranges called Passport and another called spreadsheet - these have an equal number of rows. I am trying to extract the unique data from the Passport column when compared to Spreadsheet. to do this I have set up another named range called "In Passport not in spreadsheet" This range is of the same length as Passport .
To extract the data I am using the following array in the "In Passport not in spreadsheet" column
{=IF(ISERROR(MATCH(Passport,Spreadsheet,0)),Passport,"")}
Unfortunately I don't get any return and I know there are a few unique entries.
Any suggestions will be greatly appreciated.
Thanks
Salar