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?
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?
file attached as sample
Cell I1 enter "# of Kids"
Cell I2
Formula: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
Thanks davesexcel, let me check.
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.
Everyone who confuses correlation and causation ends up dead.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks