Hello, I am trying to create a 4d lottery data in excel spread sheet from our website. I will receive a set of 23 luck number. i have to match with multiple user betting number and find out the luck number matches with user bet. The problem is i can identify the straight number (eg 1st prize is 1234 and a user pick 1234 i can match it easily) But instead of 1234 if they wrote 4321 it comes under permutation (24,12,6,4,1) how can match with the luck number. plz guide me.