+ Reply to Thread
Results 1 to 5 of 5

Filter and remove in the list of google sheet

  1. #1
    Registered User
    Join Date
    10-09-2020
    Location
    Tanzania
    MS-Off Ver
    MS professional 2013
    Posts
    5

    Filter and remove in the list of google sheet

    Ihave a list of parents and students. Parents are listed with their student, some have 3 kind some 2 and some 1 kid. How do I filter and remove the parents with only one child in the list?

  2. #2
    Registered User
    Join Date
    10-09-2020
    Location
    Tanzania
    MS-Off Ver
    MS professional 2013
    Posts
    5

    Re: Filter and remove in the list of google sheet

    file attached as sample
    Attached Files Attached Files

  3. #3
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,598

    Re: Filter and remove in the list of google sheet

    Cell I1 enter "# of Kids"

    Cell I2
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Drag the formula down.

    Select I1 and goto data=>filter
    Unselect 1

    2020-10-11_9-50-01.jpg

  4. #4
    Registered User
    Join Date
    10-09-2020
    Location
    Tanzania
    MS-Off Ver
    MS professional 2013
    Posts
    5

    Re: Filter and remove in the list of google sheet

    Thanks davesexcel, let me check.

  5. #5
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    UK
    MS-Off Ver
    2016 primarily
    Posts
    4,988

    Re: Filter and remove in the list of google sheet

    For Sheets, you could also just use a FILTER formula like:

    =filter(A2:G27,countifs(D2:D27,D2:D27,E2:E27,E2:E27)>1)

    I assumed you'd need to match on parent first and last name.
    Rory
    I drink, and I know things

+ 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. Filter and remove in the list
    By mgido in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-09-2020, 06:58 AM
  2. Google Sheets (FILTER + ARRAY) Function translated to my EXCEL Sheet
    By dmcmaste in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-31-2020, 01:35 PM
  3. Create Filter automatic filter of list in other sheet
    By martijnrikkert in forum Excel General
    Replies: 4
    Last Post: 12-30-2018, 07:33 PM
  4. Replies: 1
    Last Post: 11-21-2017, 01:55 PM
  5. Auto filter on another sheet is remove.
    By GEMINI528 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-08-2013, 12:48 PM
  6. Replies: 3
    Last Post: 02-03-2010, 01:32 PM
  7. Replies: 4
    Last Post: 02-15-2006, 06:50 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