Tuesday, February 20, 2018

yogi_From MASTER Sheet Create Sheet For Each SubCategory by TYPE

Google Spreadsheet   Post  #2378

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Feb-20-2018

question by: Eliza J
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/2mjCBsjKMfQ;context-place=mydiscussions

Have Categories Sorted Into Subsheet, EXCLUDE based on 1 field

Hi all - 

I have set up this spreadsheet to sort into the Subsheets based on "TYPE" from the master list. I would like a 2nd level of sorting, which would tell it to EXCLUDE any field from the MASTER that has "NO" Listed under "PREFERRED". 

For Instance, only TYPE: "PHOTOGRAPHER" + PREFERRED: "YES" Would sort into the "PHOTOGRAPHER" Subsheet. 

Thank you!