+ Reply to Thread
Results 1 to 3 of 3

Filtering Large Data

  1. #1
    Forum Contributor
    Join Date
    06-23-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    127

    Filtering Large Data

    Hi Guys

    I have a large data file that I need to filter, theres column ROW LABELS, 2010 , 2011 and 2012. I need to filter row labels that has Value in 2010, 2011 and 2012 column. Attached is the sample spreadsheet, highlighted the desired outcome.


    Many thanks!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: Filtering Large Data

    Hi pphg,

    Try Advanced Filter.

    Assuming data is in A1:D25, Insert 3 blank rows above the heading, so the header should be in A4:D4 & data will be A5:D28 to down.

    Leave A1 blank, then in A2

    =AND(N(B5)<>0,N(C5)<>0,N(D5)<>0)

    Go to data >> Filter > Advanced

    In Advanced Filter,

    List Range: $A$4:$D$28
    Criteria Range: $A$1:$A$2

    Click OK.

    If you only want filter >0 values change <>0 to appropriate.

    Hope this helps
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

  3. #3
    Forum Expert icestationzbra's Avatar
    Join Date
    01-07-2004
    MS-Off Ver
    2007, 2010
    Posts
    1,421

    Re: Filtering Large Data

    if you are not averse to using helper columns, create one along column E with the label 'Helper', enter the formula '=count($b2:$d2)=3' in cell E2, drag the formula down. then, proceed to filter column E for the value TRUE.
    - i.s.z -
    CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
    Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
    All good ideas are courtesy resources from this forum as well as others around the web.
    - e.o.m -

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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