Forum Discussion

tej1000's avatar
tej1000
Copper Contributor
Nov 22, 2022

function in excel

Is there any function like match ?  For eg if the input is 123 , it should compare with 123 or 231 or321 irrespective of the order of the digits  & it should give  a positive result.   here in this...
excel
JoeUser2004's avatar
JoeUser2004
Bronze Contributor
Nov 22, 2022

tej1000 

 

=AND(ISNUMBER(SEARCH({1,2,3},A1)))

 

is TRUE only if A1 contains 1 and 2 and 3 in any order.

  • tej1000's avatar
    tej1000
    Copper Contributor
    Nov 23, 2022

    JoeUser2004 

     

    Thanks a lot Joe.

     

    but my Data is Large and it should compare 2 columns 

     

    INPUT		COMPARE 	EXPECTED RESULTS
				
123		231		MATCH
456		886		MATCH
869		550		MATCH
505		306		
712		331		
423		356		
705		381		
759		406		
814		431		
868		456