Results 1 to 6 of 6

How to filter data for more than one variable

Threaded View

  1. #1
    Registered User
    Join Date
    06-18-2015
    Location
    London
    MS-Off Ver
    2010
    Posts
    76

    How to filter data for more than one variable

    Hi everybody,

    My issue is filter excel data in term of two variables, I would be highly appreciated for taking a look at my attachment and let me know how to filter simultaneously data for "E-value" and "Identity" columns (variables) so that just data (row) with "E-value" equal or less than 0.05 and "Identity" equal or greater than 50 is appeared. Thanks for your help and time
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to filter a pivot whilst looping through filter criteria in a variable list.
    By Alistairm88 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-29-2015, 04:25 AM
  2. Variable Filter
    By tconnell1965 in forum Excel General
    Replies: 4
    Last Post: 07-07-2014, 11:46 AM
  3. [SOLVED] How to do Unique Filter from a variable
    By sathyasun in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-07-2014, 07:22 AM
  4. Using a macro to operate a filter on variable data
    By Timmy Pope in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-03-2014, 01:28 PM
  5. Replies: 1
    Last Post: 10-27-2012, 02:54 AM

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