Forum Discussion

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

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

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