Spreadsheet: 295044d1391577962-automatically-fitering-values-through-based-on-a-criteria-database-and-constituent-tabs
Sheet: Consol

 |  | Province | Category | List A | List B | List C
 |  | Victoria | A | 0.367089517588567 | 0.2004199707822576 | 0.5642164971521103 |  |  | Category | List A | List B | List C
 |  | Victoria | B | 0.6866906612341263 | 0.9998021785803782 | 0.07577003464536625 |  |  | A | 0.367089517588567 | 0.2004199707822576 | 0.5642164971521103
 |  | Victoria | C | 0.3586075039024669 | 0.8944862727421745 | 0.8546364670883694 |  |  | B | 0.6866906612341263 | 0.9998021785803782 | 0.07577003464536625
 |  | Victoria | D | 0.9618628787092993 | 0.40216863136179 | 0.1209537209759846 |  |  | C | 0.3586075039024669 | 0.8944862727421745 | 0.8546364670883694
 |  | Victoria | E | 0.8937803475639466 | 0.4487979585836039 | 0.9517168393507838 |  |  | D | 0.9618628787092993 | 0.40216863136179 | 0.1209537209759846
 |  | Victoria | F | 0.295242874192561 | 0.3820738826591505 | 0.8318062084577288 |  |  | E | 0.8937803475639466 | 0.4487979585836039 | 0.9517168393507838
 |  | NSW | A | 0.8451013965258007 | 0.4232240621275081 | 0.02194651506100243 |  |  | F | 0.295242874192561 | 0.3820738826591505 | 0.8318062084577288
 |  | NSW | B | 0.1173042878678868 | 0.6465767962754666 | 0.5645157664299879
 |  | NSW | C | 0.4963556320036083 | 0.5007580101696384 | 0.3530085434334198
 |  | NSW | D | 0.5288290663519298 | 0.4495786342779263 | 0.8550160712642259
 |  | NSW | E | 0.5298993254044969 | 0.5498010938624269 | 0.6092992868129393
 |  | NSW | F | 0.5784435286374845 | 0.6294835667158095 | 0.5514572090898321
 |  | NSW | G | 0.5435321913698196 | 0.5019708120547799 | 0.3936818627735323
 |  | NSW | H | 0.03695074451148106 | 0.8983198386127563 | 0.1670678800299645
 |  | NSW | I | 0.08673871967482638 | 0.2595955610229939 | 0.4300324232709879
 |  | Queensland | A | 0.9379289480935706 | 0.1125942215516547 | 0.6032566724812469
 |  | Queensland | B | 0.02148405584523749 | 0.2760137571184543 | 0.03078485918895058
 |  | Queensland | C | 0.3861707542190098 | 0.9290454108076764 | 0.9321961338523034
 |  | Queensland | D | 0.9587887863945899 | 0.7152017101653185 | 0.9334198380408496
 |  | Queensland | E | 0.6277384786537556 | 0.0788613678351262 | 0.478123875852604
 |  | Queensland | F | 0.881949669949599 | 0.5210575432743497 | 0.9808378096680758
 |  | Queensland | G | 0.2522017790907644 | 0.699365122310915 | 0.56547231736903
 |  | Queensland | H | 0.4996123686366943 | 0.117396508287864 | 0.3499768761402722
 |  | Queensland | I | 0.6771986600536704 | 0.1155271409927671 | 0.9367063027562584
 |  | Queensland | J | 0.8394135763577782 | 0.8460076582097226 | 0.1855530156749109
 |  | Western Australia | A | 0.9652309262272774 | 0.9764873011559423 | 0.2693878570870623
 |  | Western Australia | B | 0.4557463510200312 | 0.9060247679953203 | 0.2479915436376141
 |  | Western Australia | C | 0.04636983154655183 | 0.6668197771401254 | 0.3644536989833326
 |  | Western Australia | D | 0.5068684162450562 | 0.8188827169204412 | 0.3697733570271377
 |  | Western Australia | E | 0.9469727355472217 | 0.06892885519854086 | 0.1841106499770495
 |  | Western Australia | F | 0.0781880891027098 | 0.4299256749779383 | 0.04431724723845887
 |  | Western Australia | G | 0.3833870273858284 | 0.2686726728276849 | 0.3435017309997054
 |  | Western Australia | H | 0.7802916807457498 | 0.03913718635768038 | 0.92092173318412