LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11
Default Auto filter custom filter

Hi,

I have applied an autofilter to my data. I want to do a custom filter from
there.

My data is as follows:
100
110
120
200
210
220
300
....
900
910
920

The 100, 200, etc levels are the total categories and i need to do a custom
filter based on if the number from the list is a "hundred" number. E.g. 100,
200, 300 ... , 900 I.e. the middle digit is only 0, or the whole number is a
round 100, 200, 300, etc level number...

Thanks in advance,
stevefromnaki
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom Auto Filter Dave Excel Discussion (Misc queries) 1 October 1st 09 02:19 PM
Custom auto filter (Dates) Rum Excel Worksheet Functions 2 July 6th 09 08:56 PM
Auto filter by (ALL) custom from other sheet. nader Excel Worksheet Functions 0 July 15th 08 06:13 AM
Does anyone know how to tweak Custom Auto Filter box? [email protected] New Users to Excel 4 July 5th 07 03:48 PM
Auto-Filter-Custom Problem JMay Excel Discussion (Misc queries) 2 March 21st 07 03:51 PM


All times are GMT +1. The time now is 01:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"