Re: Custom Filter for ending numbers

Tech-Archive recommends: Speed Up your PC by fixing your registry

You still haven't told us exactly what =RIGHT(A2,4) shows when
=ISNumber(-Right(A2,4)) is returning false in the cases where you expect
TRUE, so we can't help you.
I would still suspect that you have either spaces or other non-printing
characters after your data.
--
David Biddulph

"Brian17" <Brian17@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6344191A-5678-42E0-A145-52AC5DB1E6DE@xxxxxxxxxxxxxxxx
Yes no spaces in data in a column. With the =right formula we see a
mixture
of numbers and letters. I know I can use that one to find the last 4
characters and then sort the list to get all the numbers together and all
the
letters together, but we are looking for a filter to do this in 1 or 2
steps,
if possible.

Any further thoughts on either a custom or advanced filter?
Thanks!
-Brian

"David Biddulph" wrote:

Have you checked that you don't have spaces after your letters and
numbers?
What do you see with the formula =RIGHT(A2,4) ?
--
David Biddulph

"Brian17" <Brian17@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0A829746-0150-40D7-AEAE-399DDC1EFC9F@xxxxxxxxxxxxxxxx
Thanks for the reply Dave, I tried both formulas listed below and they
didn't
seem to return the correct results. I used the same list from my
original
post and in some of the entries where I have the mix of letters and
numbers
it returns a FALSE.

Any thoughts?

-Brian
*************
"Dave Peterson" wrote:

I'd use a helper column that would evaluate to true or false.

If I only cared about the rightmost character, I'd use a formula like:

=ISNumber(-Right(A2,1))

Then drag down and filter by that helper column.

===
If you really wanted to check the last 4 characters to see if they
were
numeric:
=ISNumber(-Right(A2,4))

Brian17 wrote:

Hi, I have a quesiton about filtering. I have a column that contains
entries
such as:
aa1100
bb2200
cc4455
cfd9088
fdaniels
fdr8888
jjones
jsmith
kwilliams

How can I filter the list so I see only the entries that do not
contain
numbers? I've tried to figure this out using the "ends with" custom
filter
option, but can't get it to look for ending in 4 digits. The data
will
always
end in 4 digits. Any thoughts on filtering it or using a function?

Thanks!
-Brian

--

Dave Peterson






.

Relevant Pages

  • Re: How to do this (listbox control)
    ... so I can display the contents of a std::map (or in VB ... I want to use a users selection in one combobox, to 'filter' the ... characters - all other entries will be removed. ...
    (microsoft.public.vb.general.discussion)
  • Re: Custom Filter for ending numbers
    ... of numbers and letters. ... Any further thoughts on either a custom or advanced filter? ... post and in some of the entries where I have the mix of letters and ... If you really wanted to check the last 4 characters to see if they were ...
    (microsoft.public.excel.misc)
  • Fundamental Communications
    ... Aside from using a filter that looks for the word "WATCH" in a title ... in text formats, using digital numbers for characters, base 64, hex, ... If the other end treatment can tolerate spaces and separators, good, ... these conveniences in posting snips of coded statements, ...
    (sci.crypt)
  • RE: textbox for gradual filtering
    ... Dim strFilterVal As String ... I have placed an unbound textbox in the form header ... which I hope to use to type in a couple of characters and have the form ... The problem is that after a single keystroke in the textbox the filter ...
    (microsoft.public.access.formscoding)
  • Re: Custom Filter for ending numbers
    ... Have you checked that you don't have spaces after your letters and numbers? ... post and in some of the entries where I have the mix of letters and ... Then drag down and filter by that helper column. ... but can't get it to look for ending in 4 digits. ...
    (microsoft.public.excel.misc)