Forum Discussion

tej1000's avatar
tej1000
Copper Contributor
Nov 23, 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 example  123 matches with 321 & so on
excel
  • JoeUser2004's avatar
    JoeUser2004
    Bronze Contributor
    Nov 23, 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

       

Resources