Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do you turn on the count nums when filtering in excel? | Excel Discussion (Misc queries) | |||
Combining words and nums. | Excel Worksheet Functions | |||
killing empty spaces in unusall fashion .. | New Users to Excel | |||
Have column of nums, need qty of each? | Excel Worksheet Functions | |||
When I import a csv file text that contained a + gets scrambled | Excel Discussion (Misc queries) |