+ Reply to Thread
Results 1 to 3 of 3

define custom filter and filter between TO and FROM values

  1. #1
    Forum Contributor
    Join Date
    04-25-2014
    Location
    India
    MS-Off Ver
    Excel pro plus 2021
    Posts
    186

    define custom filter and filter between TO and FROM values

    hello friends ,
    this one little difficult to search and experiment for me .
    so finally posting it for your help .

    i have 3 sheets .
    1 ) filter-order : which defines filter order .....
    2 ) filter : this sheet defines TO and FROM to be filter .....
    3 ) data : data to be filter , by taking instructions from filter data .....


    sample excel i have attach , please check ,
    in sheet "custom-order" there are 3 column in which filter order is given .
    in sheet " filter" i want to filter all values coming in between AAA+ AND CCC+ ( values define in "CUSTOM.ORDER SHEET")
    then all values coming in between VERY GOOD AND GOOD( values define in "CUSTOM.ORDER SHEET") , and finally all values coming in between 50 and 25( values define in "CUSTOM.ORDER SHEET")
    .....but all this filter to be done in "DATA" sheet .

    expected result i have filtered in data sheet..

    if we change values in TO and FROM in filter sheet , it should filter according to that in data sheet.
    Attached Files Attached Files
    Last edited by raj soni; 03-03-2015 at 02:18 PM.

  2. #2
    Forum Contributor
    Join Date
    04-25-2014
    Location
    India
    MS-Off Ver
    Excel pro plus 2021
    Posts
    186

    Re: define custom filter and filter between TO and FROM values

    any one , any help is much appreciated

  3. #3
    Forum Contributor
    Join Date
    04-25-2014
    Location
    India
    MS-Off Ver
    Excel pro plus 2021
    Posts
    186

    Re: define custom filter and filter between TO and FROM values

    still no one ?
    please guys ....
    any other alternative for this ?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Use A Custom List of Values To Filter Pivot Table
    By dollylectric in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-29-2013, 01:05 PM
  2. Pivot filter based on Custom values not working
    By vsm in forum Excel General
    Replies: 2
    Last Post: 10-27-2011, 04:57 AM
  3. Custom values in filter of pivot?
    By T4FF in forum Excel General
    Replies: 4
    Last Post: 07-20-2010, 11:35 AM
  4. Custom filter to select a value and values divisible by that number.
    By jad70 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-14-2009, 05:21 PM
  5. [SOLVED] How do I define "contains' as the default custom filter?
    By J Engineer in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-14-2005, 07:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1