| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to filter by the first digit of list
Hi,
I have the following 2 columns ID Text 1000 abc 1001 def 1002 €¦€¦ 1003 1004 2000 2001 2002 3000 3001 What I want to do is filtering the list by using for example the first 3 digit For example, I want to filter by using 1000 and its sequence numbers 1001, 1002€¦.. How to do that |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Want to sort a list of numbers by last two digit... | Excel Discussion (Misc queries) | |||
| filter: how to print filter list options in dropdown box | Excel Discussion (Misc queries) | |||
| change a list of 2 digit years to 4 digit years? | Excel Worksheet Functions | |||
| sumif based on last digit of account list | Excel Worksheet Functions | |||
| Need to convert list of 5 digit zip codes to ranges where possible | Excel Worksheet Functions | |||
Threaded Mode
