Name | Date modified | File size |
|
|---|---|---|---|
2 Methods - Get content of last populated cell Shared | Apr 28, 2020 | — | |
A brain-friendly bar graph design Shared | Dec 20, 2019 | — | |
All DATE functions explained Shared | Jan 13, 2020 | — | |
An area the size of Wales Shared | Dec 21, 2025 | 35 KB | |
ARRAYFORMULA ARRAYS VLOOKUP Nested dynamic lookup tables Shared | Sep 30, 2019 | — | |
ARRAYFORMULA LOOKUP return last value in range Shared | Feb 17, 2021 | — | |
ARRAYFORMULA ROW INDIRECT to create dynamic named ranges Shared | May 20, 2020 | — | |
AVERAGEIF usage compared to INDEX MATCH Shared | May 20, 2020 | — | |
CHAR CODE SUBSTITUTE Scrub errant starting characters Shared | Sep 11, 2019 | — | |
CHAR(10) line break concatenation and extraction tricks Shared | Sep 11, 2019 | — | |
Citymapper Mobility Index Shared | Sep 6, 2021 | 73 KB | |
Conditional format custom formula this week v next week colours Shared | Sep 11, 2019 | — | |
Conditional format custom formula to highlight rank in data range Shared | Sep 11, 2019 | — | |
Copy of Fuel duty charges Shared | Mar 31 | 1 KB | |
Count or don't count "" Shared | Nov 26, 2022 | 1 KB | |
COUNTA INDEX LEN RPT SPLIT SUBSTITUTE extract post code from full address Shared | Sep 11, 2019 | — | |
COUNTIF REGEXMATCH check to contain specific words Shared | Sep 11, 2019 | — | |
COVID-19 Dashboard Shared | Mar 26, 2023 | 220 KB | |
COVID-19 UK Vaccinations Shared | Mar 26, 2023 | 54 KB | |
Create Encoded Todoist URLs Shared | Jun 14 | 4 KB | |
Current Time Auto Update Shared | Feb 18, 2021 | — | |
Daily windows for year with one formula Shared | Mar 18, 2020 | — | |
DATE week commencing start end Shared | Jul 27, 2022 | 2 KB | |
Don't include last value when summing range Shared | Feb 18, 2021 | — | |
Double SPLIT single cell entry Shared | Aug 5, 2022 | 1 KB | |
Dynamic Calendar Creation Shared | Jul 28, 2023 | 13 KB | |
Dynamic Month Shared | 7:32 PM | 13 KB | |
Ealing Beer Festival 2019 - Dashboard Slicers Shared | Mar 11, 2020 | — | |
Eng v Wal results analysis Shared | Jan 23 | 16 KB | |
Establish ISO Year Shared | Aug 7, 2023 | 9 KB | |
Examples of how to use Curly Brace {} Arrays Shared | Sep 12, 2019 | — | |
Extract data from PDF tables using Tabula Shared | Dec 31, 2019 | 3 KB | |
FILTER based on another range Shared | Nov 20, 2023 | 1 KB | |
FILTER last instances of an entry in a series Shared | Sep 20, 2022 | 3 KB | |
FILTER QUERY ARRAY IMPORTXML Bookworm.fm score import and analysis Shared | Aug 7 | 35 KB | |
First Bus London routes Shared | Dec 21, 2025 | 9 KB | |
FLATTEN to find unique across range Shared | Jan 10, 2021 | — | |
FLATTEN TRANSPOSE QUERY manipulate columns Shared | Jul 16, 2022 | 4 KB | |
GBP to USD 13 weeks Shared | Aug 8 | 3 KB | |
General Election 2019 MPs standing down Shared | Jan 19, 2025 | 13 KB | |
Geo chart visualisation of max elevation by country Shared | Sep 12, 2019 | — | |
Go Live Date Template Generator Shared | Apr 29, 2025 | 17 KB | |
Go Live Date Template Generator All Days Shared | Apr 28, 2025 | 16 KB | |
GOOGLE FORM ARRAYFORMULA OFFSET car mileage with auto calculations Shared | Sep 12, 2019 | — | |
GOOGLE FORM ARRAYFORMULA VLOOKUP QUERY Widget Order calculations Shared | Jun 5, 2020 | — | |
GROUP SUBTOTAL Simple usage as per Excel Shared | Oct 14, 2019 | — | |
IF AND ISTEXT COUNTA check all components of postal address are present Shared | Sep 12, 2019 | — | |
IFTTT as data connector Shared | Jul 27, 2022 | 88 KB | |
IMAGE - Hosting different image sizes direct from web Shared | Sep 12, 2019 | 1 KB | |
Import US state flags from constructed URLs Shared | Apr 24, 2024 | 8 KB |