Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Filtering numbers????
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 |
#2
|
|||
|
|||
Hi
You could make the test =RIGHT(A1,2)="91" or "95" Note, you will have to enclose your test numbers in quotes, as the Right() function will return text values. Alternatively =--RIGHT(A1,2)=95 where the double unary minus will coerce the text value into a numeric. Regards Roger Govier 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 |
#3
|
|||
|
|||
Try filtering on a helper col ..
Assuming numbers in col A, from A2 down Put in B2, copied down: =RIGHT(A2,2)+0 Then do the filter on col B according to your criteria -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "kewlrunnings" wrote in message ... 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 |
#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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |