Thread: filtering for numbers ending in 000
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
  
Posts: 896
Default filtering for numbers ending in 000
try:

=IF(RIGHT(A1,3)="000","full thousand","")

and apply autofilter on "full thousand"
Reply With QuoteReply With Quote