Search similar entries

Closed
arpit.rastogi Posts 1 Registration date Wednesday February 11, 2015 Status Member Last seen February 11, 2015 - Feb 11, 2015 at 04:16 AM
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 - Feb 17, 2015 at 11:50 AM
Hi,

I need to know, how to search similar entries in list of numeric entries.

eg:
Suppose I have numeric entries of 6 digits each having numbers among 1,2,3&4
Like: 123432, 213232, 321232, 413232...

In the list of numbers we will have many random numbers having 5 out 6 digits same and also in same sequence.
Like: 123123, 223123, 323123, 423123 (last 5 digits common in sequence)or
113123, 123123, 133123, 143123 (2nd digit uncommon rest common in sequence)
123121, 123122, 123123, 123124 (first 5 digits common in sequence)


Need to find such entries.
Please help

1 reply

TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
Feb 17, 2015 at 11:50 AM
Hi Arpit.rastogi,

Try applying Filter (found under the Data tab), then click on the filter icon and use *23123, 1*3123 or 12312* for the three examples you provided.

Let us know if we can help you further.

Best regards,
Trowa
0