Autofilter question

  • Thread starter Thread starter Richard Ratner
  • Start date Start date
R

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.
 
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 D1:D2 as the criteria range (leave D1
blank). This will show rows where the number in either column ends in 1.
Bob Umlas
Excel MVP
 
Back
Top