Unique Function

%3CLINGO-SUB%20id%3D%22lingo-sub-2291952%22%20slang%3D%22en-US%22%3EUnique%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2291952%22%20slang%3D%22en-US%22%3E%3CP%3EFor%20Unique%20List%20of%20Items%20from%202%20Different%20Sheets.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20done%20by%20using%20Unique%20Function%20for%20One%20sheet%20into%20helper%20column%20and%20the%20same%20way%20for%20the%20Second%20sheet%20Post%20I%20have%20again%20use%20Unique%20function%20for%20Helper%20column%201%20and%202%20but%20I%20got%20an%20error%20of%20%23%20Value.%20kindly%20help%20how%20we%20can%20use%20the%20Unique%20function%20for%20bringing%20unique%20items%20from%202%20different%20sheets%20or%20columns.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2291952%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2292274%22%20slang%3D%22en-US%22%3ERe%3A%20Unique%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2292274%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1036894%22%20target%3D%22_blank%22%3E%40JCHHEDA%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DUNIQUE(FILTERXML(%22%3CY%3E%3CZ%3E%22%26amp%3BSUBSTITUTE(TEXTJOIN(%22%3B%22%2CTRUE%2CA1%3AA8%2CSheet2!B1%3AB7)%2C%22%3B%22%2C%22%3C%2FZ%3E%3CZ%3E%22)%26amp%3B%22%3C%2FZ%3E%3C%2FY%3E%22%2C%22%2F%2Fz%22))%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2316326%22%20slang%3D%22en-US%22%3ERe%3A%20Unique%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2316326%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1639%22%20target%3D%22_blank%22%3E%40Detlef%20Lewin%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

For Unique List of Items from 2 Different Sheets.

 

I have done by using Unique Function for One sheet into helper column and the same way for the Second sheet Post I have again use Unique function for Helper column 1 and 2 but I got an error of # Value. kindly help how we can use the Unique function for bringing unique items from 2 different sheets or columns.

2 Replies

@JCHHEDA 

=UNIQUE(FILTERXML("<y><z>"&SUBSTITUTE(TEXTJOIN(";",TRUE,A1:A8,Sheet2!B1:B7),";","</z><z>")&"</z></y>","//z"))

@Detlef Lewin 

Thank you.