Nature of my job is i have to manually entry every result (23nos) and user betting number (numbers varies according to user buying capacity).
sometimes the user digit would be more than 500-1000 numbers. but the result is always 23 nos. All i want is a formula which can match the user cell with a winning 23 nos to identify is there any winning strike including permutation ( i don't need a separate column to show whose number had strike. if just the color matches are enough).
so the formula should identify the straight number as well as permutation. Kindly look into the attach file. any new ideas or modification are welcome. hope experts in excel can help me out.
Bookmarks