If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Identify text nums in scrambled fashion
All nums are text nums
In A1:A3 would be 3 "winning" 4-digit text numbers, eg: 0044 1234 4233 In C1 down will be input 4 digit text nums such as: 0440 4120 2343 3324 etc If the text nums in C1 down happen to contain the same 4 digits as in any of the 3 winners in A1:A3, then to indicate an "x" in adjacent col D (otherwise just leave it blank) For the sample data, the results in col D would be: 0440 - x 4120 2343 - x 3324 - x I'm game for any formula, udf or vba solution which can do the above Insights welcomed. Thanks |
Thread Tools | |
Display Modes | |
|
|