Spreadsheet: 874142d1720709442-help-with-filter-formula-or-similar-please-clive-test
Sheet: BAU IG

20240626 BAU IG: England Cash ask or PPC Email candidates/blog or Scotland Email MSP/blog (DM36332) | 0 | 0 | 97753 | 97022 | 29992.6033757615 | 239 | 114 |  |  | 0 | 0 | 97753 | 97022 | 29992.6033757615 | 239 | 114 |  |  | 0 | Scotland | 2669 | 2629 | 222 | 5 | 2
20240626 BAU IG: England Cash ask or PPC Email candidates/blog or Scotland Email MSP/blog (DM36332) | Likely Automated Open | 0 | 0 | 0 | 0 | 0 | 0 |  | 20240626 BAU IG: England Cash ask or PPC Email candidates/blog or Scotland Email MSP/blog (DM36332) | 0 | 0 | 31366 | 30884 | 2736 | 70 | 31 |  | 20240613 BAU IG: England General Election Manifesto release (DM36062) | 0 | Scotland | 287 | 282 | 23 | 1 | 0
20240626 BAU IG: England Cash ask or PPC Email candidates/blog or Scotland Email MSP/blog (DM36332) | 1 | 0 | 66387 | 66138 | 27227.7467173596 | 169 | 83 |  | 20240626 BAU IG: England Cash ask or PPC Email candidates/blog or Scotland Email MSP/blog (DM36332) | 0 | Primary Country Label | 0 | 0 | 0 | 0 | 0 |  | 20240601 BAU IG: Ethnography Survey England Cash ask (DM35744) | 0 | Scotland | 249 | 243 | 14 | 0 | 0
20240626 BAU IG: England Cash ask or PPC Email candidates/blog or Scotland Email MSP/blog (DM36332) | 1 | Primary Country Label | 0 | 0 | 0 | 0 | 0 |  | 20240626 BAU IG: England Cash ask or PPC Email candidates/blog or Scotland Email MSP/blog (DM36332) | 0 | England | 20073 | 19748 | 1656 | 42 | 19 |  | 20240612 BAU IG: Scotland Email your candidates and [NAME] (DM35930) | 0 | Scotland | 2355 | 2328 | 316 | 10 | 3
20240626 BAU IG: England Cash ask or PPC Email candidates/blog or Scotland Email MSP/blog (DM36332) | 1 | England | 40842 | 40705 | 16453.9792201159 | 94 | 36 |  | 20240626 BAU IG: England Cash ask or PPC Email candidates/blog or Scotland Email MSP/blog (DM36332) | 0 | England and Scotland | 6514 | 6431 | 562 | 12 | 10
20240626 BAU IG: England Cash ask or PPC Email candidates/blog or Scotland Email MSP/blog (DM36332) | 1 | England and Scotland | 15624 | 15546 | 6660 | 44 | 30 |  | 20240626 BAU IG: England Cash ask or PPC Email candidates/blog or Scotland Email MSP/blog (DM36332) | 0 | Scotland | 2669 | 2629 | 222 | 5 | 2
20240626 BAU IG: England Cash ask or PPC Email candidates/blog or Scotland Email MSP/blog (DM36332) | 1 | Scotland | 6498 | 6482 | 2487 | 16 | 8 |  | 20240626 BAU IG: England Cash ask or PPC Email candidates/blog or Scotland Email MSP/blog (DM36332) | 0 | Unknown | 1928 | 1895 | 277 | 9 | 0 |  | 20240626 BAU IG: England Cash ask or PPC Email candidates/blog or Scotland Email MSP/blog (DM36332) |  |  | 28668 | 28226 | 2512 | 64 | 29
20240626 BAU IG: England Cash ask or PPC Email candidates/blog or Scotland Email MSP/blog (DM36332) | 1 | Unknown | 3173 | 3156 | 1534 | 15 | 8 |  | 20240626 BAU IG: England Cash ask or PPC Email candidates/blog or Scotland Email MSP/blog (DM36332) | 0 | Invalid | 153 | 152 | 17 | 1 | 0
20240626 BAU IG: England Cash ask or PPC Email candidates/blog or Scotland Email MSP/blog (DM36332) | 1 | Invalid | 192 | 192 | 75 | 0 | 1 |  | 20240613 BAU IG: England General Election Manifesto release (DM36062) | 0 | 0 | 89617 | 88848 | 28618.8196348497 | 198 | 98 |  | [NAME] needed to produce the above for as many dates as needed, currently 4 but could be several more
20240626 BAU IG: England Cash ask or PPC Email candidates/blog or Scotland Email MSP/blog (DM36332) | 0 | 0 | 31366 | 30884 | 2736 | 70 | 31 |  | 20240613 BAU IG: England General Election Manifesto release (DM36062) | 0 | 0 | 29049 | 28536 | 2653 | 71 | 29
20240626 BAU IG: England Cash ask or PPC Email candidates/blog or Scotland Email MSP/blog (DM36332) | 0 | Primary Country Label | 0 | 0 | 0 | 0 | 0 |  | 20240613 BAU IG: England General Election Manifesto release (DM36062) | 0 | Primary Country Label | 0 | 0 | 0 | 0 | 0
20240626 BAU IG: England Cash ask or PPC Email candidates/blog or Scotland Email MSP/blog (DM36332) | 0 | England | 20073 | 19748 | 1656 | 42 | 19 |  | 20240613 BAU IG: England General Election Manifesto release (DM36062) | 0 | England | 20232 | 19862 | 1716 | 36 | 19
20240626 BAU IG: England Cash ask or PPC Email candidates/blog or Scotland Email MSP/blog (DM36332) | 0 | England and Scotland | 6514 | 6431 | 562 | 12 | 10 |  | 20240613 BAU IG: England General Election Manifesto release (DM36062) | 0 | England and Scotland | 6382 | 6288 | 563 | 16 | 6
20240626 BAU IG: England Cash ask or PPC Email candidates/blog or Scotland Email MSP/blog (DM36332) | 0 | Scotland | 2669 | 2629 | 222 | 5 | 2 |  | 20240613 BAU IG: England General Election Manifesto release (DM36062) | 0 | Unknown | 1965 | 1924 | 324 | 15 | 3
20240626 BAU IG: England Cash ask or PPC Email candidates/blog or Scotland Email MSP/blog (DM36332) | 0 | Unknown | 1928 | 1895 | 277 | 9 | 0 |  | 20240613 BAU IG: England General Election Manifesto release (DM36062) | 0 | Scotland | 287 | 282 | 23 | 1 | 0
20240626 BAU IG: England Cash ask or PPC Email candidates/blog or Scotland Email MSP/blog (DM36332) | 0 | Invalid | 153 | 152 | 17 | 1 | 0 |  | 20240613 BAU IG: England General Election Manifesto release (DM36062) | 0 | Invalid | 156 | 153 | 25 | 3 | 1
20240613 BAU IG: England General Election Manifesto release (DM36062) | 0 | 0 | 89617 | 88848 | 28618.8196348497 | 198 | 98 |  | 20240601 BAU IG: Ethnography Survey England Cash ask (DM35744) | 0 | 0 | 17818 | 17606 | 6211 | 67 | 26
20240613 BAU IG: England General Election Manifesto release (DM36062) | Likely Automated Open | 0 | 0 | 0 | 0 | 0 | 0 |  | 20240601 BAU IG: Ethnography Survey England Cash ask (DM35744) | 0 | 0 | 5453 | 5324 | 532 | 18 | 13
20240613 BAU IG: England General Election Manifesto release (DM36062) | 1 | 0 | 60568 | 60312 | 25848.5616162748 | 127 | 69 |  | 20240601 BAU IG: Ethnography Survey England Cash ask (DM35744) | 0 | Primary Country Label | 0 | 0 | 0 | 0 | 0
20240613 BAU IG: England General Election Manifesto release (DM36062) | 1 | Primary Country Label | 0 | 0 | 0 | 0 | 0 |  | 20240601 BAU IG: Ethnography Survey England Cash ask (DM35744) | 0 | England | 2306 | 2261 | 271 | 11 | 6
20240613 BAU IG: England General Election Manifesto release (DM36062) | 1 | England | 41058 | 40890 | 17063.485831567 | 74 | 39 |  | 20240601 BAU IG: Ethnography Survey England Cash ask (DM35744) | 0 | England and Scotland | 2202 | 2151 | 176 | 4 | 5
20240613 BAU IG: England General Election Manifesto release (DM36062) | 1 | England and Scotland | 15321 | 15249 | 6694 | 35 | 27 |  | 20240601 BAU IG: Ethnography Survey England Cash ask (DM35744) | 0 | Unknown | 612 | 587 | 62 | 3 | 1
20240613 BAU IG: England General Election Manifesto release (DM36062) | 1 | Unknown | 3144 | 3130 | 1549 | 16 | 3 |  | 20240601 BAU IG: Ethnography Survey England Cash ask (DM35744) | 0 | Scotland | 249 | 243 | 14 | 0 | 0
20240613 BAU IG: England General Election Manifesto release (DM36062) | 1 | Scotland | 797 | 795 | 345 | 1 | 0 |  | 20240601 BAU IG: Ethnography Survey England Cash ask (DM35744) | 0 | Invalid | 68 | 66 | 9 | 0 | 1
20240613 BAU IG: England General Election Manifesto release (DM36062) | 1 | Invalid | 193 | 193 | 87 | 1 | 0 |  | 20240612 BAU IG: Scotland Email your candidates and [NAME] (DM35930) | 0 | 0 | 8092 | 8045 | 2866 | 27 | 13
20240613 BAU IG: England General Election Manifesto release (DM36062) | 0 | 0 | 29049 | 28536 | 2653 | 71 | 29 |  | 20240612 BAU IG: Scotland Email your candidates and [NAME] (DM35930) | 0 | 0 | 2361 | 2334 | 318 | 10 | 3
20240613 BAU IG: England General Election Manifesto release (DM36062) | 0 | Primary Country Label | 0 | 0 | 0 | 0 | 0 |  | 20240612 BAU IG: Scotland Email your candidates and [NAME] (DM35930) | 0 | Primary Country Label | 0 | 0 | 0 | 0 | 0
20240613 BAU IG: England General Election Manifesto release (DM36062) | 0 | England | 20232 | 19862 | 1716 | 36 | 19 |  | 20240612 BAU IG: Scotland Email your candidates and [NAME] (DM35930) | 0 | Scotland | 2355 | 2328 | 316 | 10 | 3
20240613 BAU IG: England General Election Manifesto release (DM36062) | 0 | England and Scotland | 6382 | 6288 | 563 | 16 | 6 |  | 20240612 BAU IG: Scotland Email your candidates and [NAME] (DM35930) | 0 | Unknown | 2 | 2 | 1 | 0 | 0
20240613 BAU IG: England General Election Manifesto release (DM36062) | 0 | Unknown | 1965 | 1924 | 324 | 15 | 3 |  | 20240612 BAU IG: Scotland Email your candidates and [NAME] (DM35930) | 0 | Unspecified | 2 | 2 | 0 | 0 | 0
20240613 BAU IG: England General Election Manifesto release (DM36062) | 0 | Scotland | 287 | 282 | 23 | 1 | 0 |  | 20240612 BAU IG: Scotland Email your candidates and [NAME] (DM35930) | 0 | England | 1 | 1 | 0 | 0 | 0
20240613 BAU IG: England General Election Manifesto release (DM36062) | 0 | Invalid | 156 | 153 | 25 | 3 | 1 |  | 20240612 BAU IG: Scotland Email your candidates and [NAME] (DM35930) | 0 | England and Scotland | 1 | 1 | 1 | 0 | 0
20240601 BAU IG: Ethnography Survey England Cash ask (DM35744) | 0 | 0 | 17818 | 17606 | 6211 | 67 | 26
20240601 BAU IG: Ethnography Survey England Cash ask (DM35744) | Likely Automated Open | 0 | 0 | 0 | 0 | 0 | 0
20240601 BAU IG: Ethnography Survey England Cash ask (DM35744) | 1 | 0 | 12365 | 12282 | 5679 | 49 | 13
20240601 BAU IG: Ethnography Survey England Cash ask (DM35744) | 1 | Primary Country Label | 0 | 0 | 0 | 0 | 0
20240601 BAU IG: Ethnography Survey England Cash ask (DM35744) | 1 | England and Scotland | 5911 | 5872 | 2746 | 17 | 8
20240601 BAU IG: Ethnography Survey England Cash ask (DM35744) | 1 | England | 4173 | 4147 | 1839 | 20 | 4
20240601 BAU IG: Ethnography Survey England Cash ask (DM35744) | 1 | Unknown | 1447 | 1434 | 732 | 10 | 1
20240601 BAU IG: Ethnography Survey England Cash ask (DM35744) | 1 | Scotland | 700 | 697 | 296 | 1 | 0
20240601 BAU IG: Ethnography Survey England Cash ask (DM35744) | 1 | Invalid | 102 | 100 | 49 | 0 | 0
20240601 BAU IG: Ethnography Survey England Cash ask (DM35744) | 0 | 0 | 5453 | 5324 | 532 | 18 | 13
20240601 BAU IG: Ethnography Survey England Cash ask (DM35744) | 0 | Primary Country Label | 0 | 0 | 0 | 0 | 0
20240601 BAU IG: Ethnography Survey England Cash ask (DM35744) | 0 | England | 2306 | 2261 | 271 | 11 | 6
20240601 BAU IG: Ethnography Survey England Cash ask (DM35744) | 0 | England and Scotland | 2202 | 2151 | 176 | 4 | 5
20240601 BAU IG: Ethnography Survey England Cash ask (DM35744) | 0 | Unknown | 612 | 587 | 62 | 3 | 1
20240601 BAU IG: Ethnography Survey England Cash ask (DM35744) | 0 | Scotland | 249 | 243 | 14 | 0 | 0
20240601 BAU IG: Ethnography Survey England Cash ask (DM35744) | 0 | Invalid | 68 | 66 | 9 | 0 | 1
20240612 BAU IG: Scotland Email your candidates and [NAME] (DM35930) | 0 | 0 | 8092 | 8045 | 2866 | 27 | 13
20240612 BAU IG: Scotland Email your candidates and [NAME] (DM35930) | Likely Automated Open | 0 | 0 | 0 | 0 | 0 | 0
20240612 BAU IG: Scotland Email your candidates and [NAME] (DM35930) | 1 | 0 | 5731 | 5711 | 2548 | 17 | 10
20240612 BAU IG: Scotland Email your candidates and [NAME] (DM35930) | 1 | Primary Country Label | 0 | 0 | 0 | 0 | 0
20240612 BAU IG: Scotland Email your candidates and [NAME] (DM35930) | 1 | Scotland | 5723 | 5703 | 2543 | 17 | 10
20240612 BAU IG: Scotland Email your candidates and [NAME] (DM35930) | 1 | Unspecified | 3 | 3 | 1 | 0 | 0
20240612 BAU IG: Scotland Email your candidates and [NAME] (DM35930) | 1 | England and Scotland | 2 | 2 | 2 | 0 | 0
20240612 BAU IG: Scotland Email your candidates and [NAME] (DM35930) | 1 | Unknown | 2 | 2 | 1 | 0 | 0
20240612 BAU IG: Scotland Email your candidates and [NAME] (DM35930) | 1 | England | 1 | 1 | 1 | 0 | 0
20240612 BAU IG: Scotland Email your candidates and [NAME] (DM35930) | 0 | 0 | 2361 | 2334 | 318 | 10 | 3
20240612 BAU IG: Scotland Email your candidates and [NAME] (DM35930) | 0 | Primary Country Label | 0 | 0 | 0 | 0 | 0
20240612 BAU IG: Scotland Email your candidates and [NAME] (DM35930) | 0 | Scotland | 2355 | 2328 | 316 | 10 | 3
20240612 BAU IG: Scotland Email your candidates and [NAME] (DM35930) | 0 | Unknown | 2 | 2 | 1 | 0 | 0
20240612 BAU IG: Scotland Email your candidates and [NAME] (DM35930) | 0 | Unspecified | 2 | 2 | 0 | 0 | 0
20240612 BAU IG: Scotland Email your candidates and [NAME] (DM35930) | 0 | England | 1 | 1 | 0 | 0 | 0
20240612 BAU IG: Scotland Email your candidates and [NAME] (DM35930) | 0 | England and Scotland | 1 | 1 | 1 | 0 | 0