Autofilter question

[Richard Ratner]

I have two columns of numbers. Is there any way to store
and filter them as text so I can, for instance, find only
those which end in "1"? Thanks. Please reply to email.

 

[Bob Umlas]

No need. Use advanced filter. If your data is in A1:B100 (for 1 being
titles), then enter this in D2:
=OR(MOD(A2,10)=1,MOD(B2,10)=1)
then using advanced filter, set D12 as the criteria range (leave D1
blank). This will show rows where the number in either column ends in 1.
Bob Umlas
Excel MVP