View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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