| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to filter by the first digit of list
Jon -
If you are using AutoFilter, you can use the the Custom option. If your ID field is text, use the 'Starts With' and the numbers you want to start with (e.g. 100). If your ID field is numeric, then use 'Greater Than Or Equal To' and 1000, then click the AND button, and use 'Less Than' and 2000. -- Daryl S "Jon" wrote: 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 |
| Reply |
| 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 | |||
Hybrid Mode
