Home |
Search |
Today's Posts |
#4
![]() |
|||
|
|||
![]()
On Wed, 12 Oct 2005 02:07:03 -0700, kewlrunnings
wrote: I have a column filled with 6 digit numbers and wanted to only show numbers that ended in equal to or greater than 91 and less than or equal to 95 (ie. *91, *95). I used the asterix and question mark symbol to represent any series of numbers before the last 2 numbers, but it didnt work. Is there away around this???? Thank you in advance You could use the Advanced Filter. Data/Advanced Filter If your data starts in A5, you could set up your criterion range to look like: Minimum Maximum =MOD(A5,100)=91 =MOD(A5,100)<=95 --ron |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2002 - Filtering numbers | Excel Discussion (Misc queries) | |||
column filtering to match identical numbers | Excel Discussion (Misc queries) | |||
Checking Winning Numbers in the Lottery. | Excel Discussion (Misc queries) | |||
Match Last Occurrence of two numbers and Return Date | Excel Worksheet Functions | |||
extracting numbers with no more than 8-digits using advanced filtering | Excel Worksheet Functions |