DirtyXanchez
Programmer
Hi.
I have been asked to create a system to lookup in a database for numbers as they are known.
The numbers in the cell would look like "11 33 44 66 88" or "1 23 42 56 77"
The search would consist of numbers typed in one at a time in a random order.
The trick is, i need to know, when only one number is missing to get a match.
i.e. 22, 66, 88, 33 would tell me that i only miss 11 to have a hit in "11 33 44 66 88"
Unfortunately i am kind of a newbie, so i don't have the right ninja skills yet..
Therefore i ask for your expertise.
I have been asked to create a system to lookup in a database for numbers as they are known.
The numbers in the cell would look like "11 33 44 66 88" or "1 23 42 56 77"
The search would consist of numbers typed in one at a time in a random order.
The trick is, i need to know, when only one number is missing to get a match.
i.e. 22, 66, 88, 33 would tell me that i only miss 11 to have a hit in "11 33 44 66 88"
Unfortunately i am kind of a newbie, so i don't have the right ninja skills yet..
Therefore i ask for your expertise.
