+ Reply to Thread
Results 1 to 3 of 3

How to filter multi column

  1. #1
    Registered User
    Join Date
    07-19-2016
    Location
    vanteria
    MS-Off Ver
    13
    Posts
    1

    How to filter multi column

    How can I to filter multi column
    Ex: I want to filter "4" and dislay all row 1 and row 2 instead of dislay result from 1 colum. Please help me, thanks !

    a 1 2 3 4 5
    b 2 3 4 5 6
    c 5 6 7 8 9

  2. #2
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: How to filter multi column

    You must use a helper column
    Assuming your data in A2:F4 and Row 1 has labels
    You can use a helper column G2:G4 with the following array formula enter with CTRL+SHIFT+ENTER
    =AND(A2:F2=4)
    Select A1:G4 goto Data->Filter->Apply filters

  3. #3
    Registered User
    Join Date
    03-05-2013
    Location
    Cleveland, Ohio
    MS-Off Ver
    Excel 365
    Posts
    19

    Re: How to filter multi column

    Starting in column G, row 2 (as Jose pointed out about having the header row on row one), type this formula: =COUNTIF(B2:F2,"4")

    If that "4" is going to change, designate a cell where you can change that number. Example: Cell H1 would have "4" in there. Then, change the formula from "4" to $H$1.
    Example: =COUNTIF(B2:F2,$H$1) - Remember, the dollars signs lock the cell location to H1 when you copy the formula to another cell.

    Every time you change the number in cell H1, the COUNTIF formula will now reflect the new number. You can then filter on column G.

+ 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. Replies: 1
    Last Post: 04-18-2016, 11:48 AM
  2. VBA Multi-Column Filter, Copy and Paste on Separate Sheet
    By AMJ in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-22-2014, 06:33 AM
  3. Pivot Table: OR condition filter on Multi Date/Sum Filter
    By ddalt10 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-09-2013, 12:49 PM
  4. 1 column into multi-columns and multi-rows
    By affj in forum Excel General
    Replies: 7
    Last Post: 07-17-2013, 09:34 AM
  5. [SOLVED] Data Manipulation: How to dynamically filter and sort a multi-column data set
    By deturnbull in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 04-12-2013, 05:35 AM
  6. Replies: 19
    Last Post: 10-05-2012, 01:03 PM
  7. Multi-Column Listboxes correspond to multi textboxes
    By Crebsington in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-12-2012, 01:38 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