1 | Google Sheets Tips Newsletter Archive | ||||
|---|---|---|---|---|---|
2 | |||||
3 | Sign up π | https://www.benlcollins.com/google-sheets-tips/ | π | ||
4 | Weekly newsletter every Monday at 11am | ||||
5 | |||||
6 | Tip Number | Date | Subject | Description | Link |
7 | 1 | 30-Apr-2018 | Monday Tip: Keyboard Shortcuts in Google Sheets | 5 keyboard shortcuts | https://mailchi.mp/benlcollins/monday-tip-keyboard-shortcuts-in-google-sheets |
8 | 2 | 7-May-2018 | Monday Tip: Notifications in Google Sheets | Get notifications when a spreadsheet changes | https://mailchi.mp/benlcollins/monday-tip-keyboard-shortcuts-in-google-sheets-1560017 |
9 | 3 | 14-May-2018 | Monday Tip: Datetime tip in Google Sheets | Quickly split datetime with formulas | https://mailchi.mp/benlcollins/monday-tip-keyboard-shortcuts-in-google-sheets-1560021 |
10 | 4 | 21-May-2018 | Monday Tip: Super cool (and clever) way to combine text and numbers in a cell | Add label to number with custom formatting | https://mailchi.mp/benlcollins/monday-tip-keyboard-shortcuts-in-google-sheets-1560077 |
11 | 5 | 11-Jun-2018 | Monday Tip: Replace numerical IF functions with MIN or MAX | Replace numerical IF formulas with MIN or MAX functions | https://mailchi.mp/benlcollins/monday-tip-keyboard-shortcuts-in-google-sheets-1560093 |
12 | 6 | 18-Jun-2018 | Monday Tip: Quick ways to copy data down a column | Quick ways to fill a whole column (double click, highlight > Cmd + Enter or Cmd + D, quicker than Copy-paste or drag-down) | https://mailchi.mp/benlcollins/monday-tip-keyboard-shortcuts-in-google-sheets-1560097 |
13 | 7 | 25-Jun-2018 | Monday Tip: Multiply an entire column with a single π₯ MMULT formula π₯ | MMULT with constant value to quickly multiply column of numbers | https://mailchi.mp/benlcollins/monday-tip-keyboard-shortcuts-in-google-sheets-1560101 |
14 | 8 | 2-Jul-2018 | Monday Tip: The OFFSET function! | OFFSET function to move data up columns | https://mailchi.mp/benlcollins/monday-tip-keyboard-shortcuts-in-google-sheets-1560105 |
15 | 9 | 9-Jul-2018 | Monday G Sheets Tip: Better data entry β | Control data entry with data validation e.g. email address with custom formula =search("@",F9)>0 | https://mailchi.mp/benlcollins/monday-tip-keyboard-shortcuts-in-google-sheets-1560109 |
16 | 10 | 16-Jul-2018 | Monday G Sheets Tip: CHAR-grilled anyone? | Top 10(?) CHAR formulas e.g. to get arrows e.g. ="Cohort "&char(8594)&char(10)&" Months after cohort start "&char(8595) | https://mailchi.mp/benlcollins/monday-tip-keyboard-shortcuts-in-google-sheets-1560113 |
17 | 11 | 23-Jul-2018 | Monday Tip + I learned this the hard way, you donβt have toβ¦ | Group rows and columns | https://mailchi.mp/benlcollins/monday-tip-i-learned-this-the-hard-way-you-dont-have-to |
18 | 12 | 30-Jul-2018 | [Case Study] Joshβs journey from political campaign director to data analyst | F4 for relative/absolute and for repeat last command | https://mailchi.mp/benlcollins/i-learned-this-the-hard-way-you-dont-have-to-1560149 |
19 | 13 | 20-Aug-2018 | Monday Tip: Tag people in comments in Google Sheets | Alert in comments | https://mailchi.mp/benlcollins/alert-in-comments |
20 | 14 | 27-Aug-2018 | Monday Tip: Conditional Formatting across entire row | How to apply conditional formatting to whole row (also write quick blog post) | https://mailchi.mp/benlcollins/alert-in-comments-1560245 |
21 | 15 | 3-Sep-2018 | π Monday Tip: Trick to round numbers to the nearest ten, hundred, etc. | How to round to nearest ten, hundred, thousand | https://mailchi.mp/benlcollins/round-to-ten |
22 | 16 | 10-Sep-2018 | π Monday Tip: Speed up your data entry | Quick data entry by highlighting range in advance | https://mailchi.mp/benlcollins/data-entry-confined-range |
23 | 17 | 17-Sep-2018 | π Monday Tip: Generate random letters with the CODE function | Generate random letters with CODE function | https://mailchi.mp/benlcollins/generate-random-letters-code-function |
24 | 18 | 24-Sep-2018 | π Monday Tip: Create heatmaps with your data | Create heatmaps using conditional formatting | https://mailchi.mp/benlcollins/create-heatmap-with-conditional-formatting |
25 | 19 | 1-Oct-2018 | π Monday Tip: A Pivot Table tip and resources | Pivot Table Copy trick and resources | https://mailchi.mp/benlcollins/pivot-table-tip-and-resources |
26 | 20 | 8-Oct-2018 | π Monday Tip: Rename Pivot Table column headings | Rename Pivot Table headings | https://mailchi.mp/benlcollins/rename-pivot-table-headings |
27 | 21 | 15-Oct-2018 | π Monday Tip: Hyperlink to different parts of your Sheet | Hyperlink to other parts of your Sheet | https://mailchi.mp/benlcollins/hyperlinks-in-sheets |
28 | 22 | 22-Oct-2018 | π Monday Tip: Repeat number groups with the ROW & MOD functions | Create repeating number groups with ROW and MOD | https://mailchi.mp/benlcollins/number-groups-row-mod |
29 | 23 | 29-Oct-2018 | π π» Monday Tip: Create Google Sheets instantly | Instantly create a new Google Sheet | https://mailchi.mp/benlcollins/create-sheets-instantly |
30 | 24 | 5-Nov-2018 | πͺ Monday Tip: Advanced Formula Workout Challenge | Advanced formula walk through | https://mailchi.mp/benlcollins/advanced-formula-workout |
31 | 25 | 12-Nov-2018 | π Monday Tip: Neat trick with freeze panes & that surprise from last week... | Quickly freeze rows by dragging down top row | https://mailchi.mp/benlcollins/freeze-panes-blastoff-surprise |
32 | 26 | 19-Nov-2018 | β Monday Tip: Protect individual sheets | Protect individual sheets with Google Sheet | https://mailchi.mp/benlcollins/protect-individual-sheet |
33 | 27 | 26-Nov-2018 | Monday Tip: Super handy shortcut | Quick create Sheets in folder with Shift + S | https://mailchi.mp/benlcollins/shift-s-open-new-sheet |
34 | 28 | 3-Dec-2018 | π Monday Tip: Automate your Sheets with Macros | Introducing Macros | https://us11.campaign-archive.com/?u=5f850f1ff83cc35ed1ca00348&id=0004cdcffc |
35 | 29 | 10-Dec-2018 | π Monday Tip: 5 million cells... | Introducing 5 million cell limit | https://us11.campaign-archive.com/?u=5f850f1ff83cc35ed1ca00348&id=b7d4d15d32 |
36 | 30 | 17-Dec-2018 | Monday Google Sheets Tip: Collaboration & Filters | Filter views | https://mailchi.mp/benlcollins/filter-views |
37 | 31 | 24-Dec-2018 | Monday Google Sheets Tip: Happy Holidays! | Christmas tree with the CHAR function | https://mailchi.mp/benlcollins/christmas-tree-char |
38 | 32 | 31-Dec-2018 | Monday Google Sheets Tip: 2018 draws to a close | % of year remaining | https://mailchi.mp/benlcollins/end-of-2018 |
39 | 33 | 7-Jan-2019 | Google Sheets Tip: Format Individual Data Points In Charts | Format individual data points in Google Sheets Charts | https://mailchi.mp/benlcollins/format-individual-chart-points |
40 | 34 | 14-Jan-2019 | Google Sheets Tip: Quickly summarize your data | Quick Aggregation Tool, when you highlight data | https://mailchi.mp/benlcollins/quickly-summarize-your-data |
41 | 35 | 21-Jan-2019 | Google Sheets Tip: How To Remove Duplicates | UNIQUE formula to dedup | https://mailchi.mp/benlcollins/how-to-remove-duplicates |
42 | 36 | 28-Jan-2019 | Google Sheets Tip: Numbers Starting With Zero | Enter numbers that start with zero | https://mailchi.mp/benlcollins/numbers-starting-with-zero |
43 | 37 | 4-Feb-2019 | Google Sheets Tip: Vlookup Formula Challenge | Vlookup multiple criteria formula challenge | https://mailchi.mp/benlcollins/nested-tables-vlookup |
44 | 38 | 11-Feb-2019 | Google Sheets Tip: Text Trickery π | Text rotation | https://mailchi.mp/benlcollins/text-rotation |
45 | 39 | 18-Feb-2019 | Google Sheets Tip: Text Trickery Part II π | Text rotation part II | https://mailchi.mp/benlcollins/text-rotation-part-ii |
46 | 40 | 25-Feb-2019 | Google Sheets Tip: Hello, how are you? | Detect language + Google Translate | https://mailchi.mp/benlcollins/google-translate-function |
47 | 41 | 4-Mar-2019 | Google Sheets Tip: ROW/COLUMN functions & Formula Challenge Solution | Multiple images solution | https://mailchi.mp/benlcollins/repeated-image-formula |
48 | 42 | 11-Mar-2019 | Google Sheets Tip: The Endless Possibilities of Custom Functions | Clearbit API example + Apps Script Course | https://mailchi.mp/benlcollins/custom-functions |
49 | 43 | 25-Mar-2019 | Google Sheets Tip: A Change of Plans... | Change of Plans + Subtotal | https://mailchi.mp/benlcollins/change-of-plans-subtotal |
50 | 44 | 1-Apr-2019 | Google Sheets Tip: Year In Progress Sparkline | Sparklines | https://mailchi.mp/benlcollins/sparkline-year-progress |
51 | 45 | 8-Apr-2019 | Google Sheets Tip: Find The Most Frequent Word π | Find the most frequent word | https://mailchi.mp/benlcollins/mode-with-text |
52 | 46 | 15-Apr-2019 | Google Sheets Tip: Sneak peek at new stuff coming to Google Sheets | Next Recap | https://mailchi.mp/benlcollins/next-recap |
53 | 47 | 22-Apr-2019 | Google Sheets Tip: Macro to show/hide tabs | Focus + Unfocus example + Apps Script Course | https://mailchi.mp/benlcollins/focus-unfocus |
54 | 48 | 29-Apr-2019 | Google Sheets Tip: Night mode anyone? π | Change background colors with Apps Script | https://mailchi.mp/benlcollins/night-mode-automation-launch |
55 | 49 | 6-May-2019 | Google Sheets Tip: Create new tabs instantly | Shift + F11 to create new tabs in Google Sheets | https://mailchi.mp/benlcollins/shift-f11 |
56 | 50 | 13-May-2019 | Google Sheets Tip: Images In Cells | Images in cells | https://mailchi.mp/benlcollins/image-in-cells |
57 | 51 | 20-May-2019 | Google Sheets Tip: Remove Duplicates Finally! | New data features - Remove duplicates | https://mailchi.mp/benlcollins/remove-duplicates |
58 | 52 | 27-May-2019 | Google Sheets Tip: Show formulas | Show all formulas at once, with Ctrl + ` | https://mailchi.mp/benlcollins/show-formulas |
59 | 53 | 3-Jun-2019 | Google Sheets Tip: Formula Challenge Solutions | Formula Challenge Results | https://mailchi.mp/benlcollins/formula-challenge-solution |
60 | 54 | 10-Jun-2019 | Google Sheets Tip: Colorful Sheets! π | Use color in Google Sheets | https://mailchi.mp/benlcollins/add-colors |
61 | 55 | 17-Jun-2019 | Google Sheets Tip: More Colorful Sheets! π | Use of the MID formula and more colors in Sheets | https://mailchi.mp/benlcollins/mid-formula-colors |
62 | 56 | 24-Jun-2019 | Google Sheets Tip: Quick Entry & Exit With Formulas | F2 and Shift + Enter and Escape shortcuts | https://mailchi.mp/benlcollins/formula-entry-exit-shortcuts |
63 | 57 | 1-Jul-2019 | Google Sheets Tip: Discover New Formulas Today | Discover a new formula today | https://mailchi.mp/benlcollins/discover-new-function |
64 | 58 | 8-Jul-2019 | Google Sheets Tip: Make Conditional Formatting Permanent | Apply conditional formatting permanently | https://mailchi.mp/benlcollins/make-conditional-formatting-permanent |
65 | 59 | 15-Jul-2019 | Google Sheets Tip: Custom Number Formatting & Coming soon... | Custom Number Formatting | https://mailchi.mp/benlcollins/custom-number-formatting |
66 | 60 | 22-Jul-2019 | Google Sheets Tip: Moon Landing 50th Anniversary! | Moon landing anniversary | https://mailchi.mp/benlcollins/moon-landing |
67 | 61 | 29-Jul-2019 | Google Sheets Tip: In Cell Date Picker | Data Validation Date Picker | https://mailchi.mp/benlcollins/in-cell-date-picker |
68 | 62 | 5-Aug-2019 | Google Sheets Tip: Add Star Rating System βββ | Add Star Ratings | https://mailchi.mp/benlcollins/star-rating |
69 | 63 | 12-Aug-2019 | Google Sheets Tip: Create QR Codes With Formulas | Create QR codes in Sheets | https://mailchi.mp/benlcollins/qr-codes |
70 | 64 | 19-Aug-2019 | Google Sheets Tip: Apps Script Button & 10 Year Anniversary | Apps Script 10 Year anniversary | https://mailchi.mp/benlcollins/apps-script-button |
71 | 65 | 26-Aug-2019 | Google Sheets Tip: QA Checklists | QA Checklist | https://mailchi.mp/benlcollins/qa-checklists |
72 | 66 | 2-Sep-2019 | Google Sheets Tip: Do you use the Parser family of functions? | Parser family of functions | https://mailchi.mp/benlcollins/parser-functions |
73 | 67 | 9-Sep-2019 | Google Sheets Tip: Manage Apps Script projects from the Dashboard | Apps Script Dashboard | https://mailchi.mp/benlcollins/apps-script-dashboard |
74 | 68 | 16-Sep-2019 | Google Sheets Tip: Brilliant Apps Script keyboard shortcuts π― | Apps Script shortcuts | https://mailchi.mp/benlcollins/apps-script-shortcuts |
75 | 69 | 23-Sep-2019 | Google Sheets Tip: Video sidebar with Apps Script | Embed videos in sidebar | https://mailchi.mp/benlcollins/video-sidebar |
76 | 70 | 30-Sep-2019 | Google Sheets Tip 70: Extract Hyperlink URLs with a formula | Extract url from hyperlink formula | https://mailchi.mp/benlcollins/extract-hyperlinks |
77 | 71 | 7-Oct-2019 | Google Sheets Tip 71: Annotate Line Charts π | Mark Today on a Line Graph | https://mailchi.mp/benlcollins/annotate-line-charts |
78 | 72 | 14-Oct-2019 | Google Sheets Tip 72: One spicy function πΆοΈ | SEQUENCE function | https://mailchi.mp/benlcollins/sequence-function |
79 | 73 | 21-Oct-2019 | Google Sheets Tip 73: Date trick that's so easy to miss... | Double click date to bring up date picker | https://mailchi.mp/benlcollins/date-double-click |
80 | 74 | 28-Oct-2019 | Google Sheets Tip 74: A book, a challenge and the RANK function π | Find position of a value with RANK function | https://mailchi.mp/benlcollins/rank-function |
81 | 75 | 4-Nov-2019 | Google Sheets Tip 75: A FACT to blow your mind β£ | 75 Tips Anniversary - special email about the Card sorting Factorial (the lesson I never included in the data analysis course) | https://mailchi.mp/benlcollins/google-sheets-tip-75-fact |
82 | 76 | 11-Nov-2019 | Google Sheets Tip 76: Control who can edit tabs | Setting tab level permissions | https://mailchi.mp/benlcollins/tab-permissions |
83 | 77 | 18-Nov-2019 | Google Sheets Tip 77: Custom Formulas Data Validation | Custom Formulas in Data Validation | https://mailchi.mp/benlcollins/google-sheets-tip-77-custom-formula-data-validation |
84 | 78 | 25-Nov-2019 | Google Sheets Tip 78: Line Chart Trick π | Chart with vertical line marker for today | https://mailchi.mp/benlcollins/google-sheets-tip-78-line-chart-trick |
85 | 79 | 2-Dec-2019 | Google Sheets Tip: Find Every Formula | Find all formulas with conditional formatting | https://mailchi.mp/benlcollins/google-sheets-tip-79-find-formulas |
86 | 80 | 9-Dec-2019 | Google Sheets Tip: Simple Formula Clock | Now, Today, Text functions combine to make simple clock | https://mailchi.mp/benlcollins/google-sheets-tip-80-simple-formula-clock |
87 | 81 | 16-Dec-2019 | Google Sheets Tip: Hyperlinked Image | Hyperlinked image | https://mailchi.mp/benlcollins/hyperlinked-image |
88 | 82 | 30-Dec-2019 | Google Sheets Tip: Dates Are Really Just Numbers | Dates are just numbers | https://mailchi.mp/benlcollins/dates-in-spreadsheets |
89 | 83 | 6-Jan-2020 | Google Sheets Tip: Working With Excel Files | Working with Excel files in Sheets directly | https://mailchi.mp/benlcollins/excel-in-sheets |
90 | 84 | 13-Jan-2020 | Google Shees Tip: Colored Checkboxes | Colored checkboxes | https://mailchi.mp/benlcollins/colored-checkboxes |
91 | 85 | 20-Jan-2020 | Google Sheets Tip: A Formula Challenge! | Transpose & Formula Challenge #3: Alphabetical sort | https://mailchi.mp/benlcollins/transpose-and-formula-challenge-3 |
92 | 86 | 27-Jan-2020 | Google Sheets Tip: Transpose Formula Challenge Solution! | Formula Challenge 3 Solution | https://mailchi.mp/benlcollins/formula-challenge-3-solution |
93 | 87 | 3-Feb-2020 | Google Sheets Tip: Create Data With Randarray | Create data with RANDARRAY function | https://mailchi.mp/benlcollins/randarray |
94 | 88 | 10-Feb-2020 | Google Sheets Tip: SWITCH function | Switch function | https://mailchi.mp/benlcollins/switch-function |
95 | 89 | 17-Feb-2020 | Google Sheets Tip: Upgrade Your Apps Script! | V8 runtime | https://mailchi.mp/benlcollins/v8-runtime |
96 | 90 | 24-Feb-2020 | Google Sheets Tip: Rolling Average Formula | Rolling average calculation | https://mailchi.mp/benlcollins/rolling-average |
97 | 91 | 2-Mar-2020 | Google Sheets Tip: Conditional Sparklines π | Conditional sparklines | https://mailchi.mp/benlcollins/conditional-sparklines |
98 | 92 | 9-Mar-2020 | Google Sheets Tip: Trace Precedents With F2 | F2 pressed twice takes you to the range | https://mailchi.mp/benlcollins/trace-precedents |
99 | 93 | 16-Mar-2020 | Google Sheets Tip: Group Columns Trick | Group rows and columns - right click to customize | https://mailchi.mp/benlcollins/group-columns-side-panel |
100 | 94 | 23-Mar-2020 | Google Sheets Tip: Organize Tabs | Tab separators | https://mailchi.mp/benlcollins/organize-tabs |
101 | 95 | 30-Mar-2020 | Google Sheets Tip: Pivot Date Trick π | Pivot Group Rule for Dates | https://mailchi.mp/benlcollins/pivot-date-group |
102 | 96 | 6-Apr-2020 | Google Sheets Tip: Pivot Custom Text Groups π | Custom Grouping by highlighted values | https://mailchi.mp/benlcollins/pivot-text-group |
103 | 97 | 13-Apr-2020 | Google Sheets Tip: Pivot Table Bins, huh? | Pivot Group Rule for Values | https://mailchi.mp/benlcollins/pivot-value-group |
104 | 98 | 20-Apr-2020 | Google Sheets Tip: Bullet Charts | Bullet charts | https://mailchi.mp/benlcollins/bullet-chart |
105 | 99 | 27-Apr-2020 | Google Sheets Tip: Find Last Non-Blank Row | Last Non Blank Row | https://mailchi.mp/benlcollins/last-non-blank-row |
106 | 100 | 4-May-2020 | 100 Google Sheets Tips Ebook π & Hyperlink Next Blank Row | Monday Tips 100! Hyperlink to next blank cell | https://mailchi.mp/benlcollins/hyperlink-next-blank-row |
107 | 101 | 11-May-2020 | Google Sheets Tip: Conditional Conditional Formatting | Conditional conditional formatting | https://mailchi.mp/benlcollins/conditional-conditional-formatting |
108 | 102 | 18-May-2020 | Google Sheets Tip: Tab Tricks | Tab tricks (move, hide, create, duplicate, shortcuts, double-click to rename, color separators, copy to | https://mailchi.mp/benlcollins/tab-tricks |
109 | 103 | 25-May-2020 | Google Sheets Tip: Remove Line Breaks | Remove line breaks with regex | https://mailchi.mp/benlcollins/remove-line-breaks |
110 | 104 | 1-Jun-2020 | Google Sheets Tip: Multi-hyperlinks In A Single Cell | Multiple hyperlinks in single cell | https://mailchi.mp/benlcollins/multiple-hyperlinks |
111 | 105 | 8-Jun-2020 | Google Sheets Tip: Auto Generate ID Column | Auto ID numbering | https://mailchi.mp/benlcollins/auto-generate-id-column |
112 | 106 | 15-Jun-2020 | A Google Sheets Tip hiding in plain sight | Template Gallery | https://mailchi.mp/benlcollins/template-gallery |
113 | 107 | 22-Jun-2020 | Google Sheets Tip: Show/Hide solutions and hints in workbooks | New Course Launch + IF/checkboxes | https://mailchi.mp/benlcollins/if-with-checkbox |
114 | 108 | 29-Jun-2020 | GSheets Tip: Randomize Ranges & A Formula Challenge | Randomize range & formula challenge #4 | https://mailchi.mp/benlcollins/randomize-ranges-and-formula-challenge |
115 | 109 | 6-Jul-2020 | GSheets Tip: The Future, SORT and the Challenge Solution | Formula challenge #4 solution | https://mailchi.mp/benlcollins/sort-formula-challenge-4-solution |
116 | 110 | 13-Jul-2020 | Google Sheets Tip: Return Multiple Values With Vlookup | Return multiple column values with vlookup | https://mailchi.mp/benlcollins/vlookup-multiple-columns |
117 | 111 | 20-Jul-2020 | GSheets Tip: Find Formula Errors With Conditional Formatting | Catching Errors With Conditional Formatting | https://mailchi.mp/benlcollins/find-formula-errors-with-conditional-formatting |
118 | 112 | 27-Jul-2020 | GSheets Tip: How To Add Google Photos Into Your Sheets | How To Add Google Photos into your Sheets | https://mailchi.mp/benlcollins/gsheets-tip-how-to-add-google-photos-to-your-sheets |
119 | 113 | 3-Aug-2020 | GSheets Tip: Hidden Currency Converter | Convert currencies with functions | https://mailchi.mp/benlcollins/currency-converter |
120 | 114 | 10-Aug-2020 | GSheets Tip: Indicator Arrows in Pivot Tables πΌ | Indicator lights in pivot tables | https://mailchi.mp/benlcollins/gsheets-tip-indicator-arrows-in-pivot-tables |
121 | 115 | 17-Aug-2020 | GSheets Tip: Importrange Formula Know-How | ImportRange knowledge | https://mailchi.mp/benlcollins/gsheets-tip-importrange-permissions |
122 | 116 | 24-Aug-2020 | GSheets Tip: Share Sensitive Sheets Safely | Create a copy to remove version history before sharing | https://mailchi.mp/benlcollins/gsheets-tip-share-copy |
123 | 117 | 31-Aug-2020 | GSheets Tip: Format Numbers Like An Accountant | Custom Number Formatting - add color and brackets to negative numbers | https://mailchi.mp/benlcollins/gsheets-tip-accounting-number-format |
124 | 118 | 7-Sep-2020 | GSheets Tip: Must-Know Fact About The QUERY Function | A, B, C vs. Col1, Col2, Col3 in Query | https://mailchi.mp/benlcollins/gsheets-tip-must-know-fact-about-query-function |
125 | 119 | 14-Sep-2020 | GSheets Tip: Track G Suite Updates With This Formula | G Suite Updates with IMPORTFEED | https://mailchi.mp/benlcollins/gsheets-tip-track-g-suite-updates |
126 | 120 | 21-Sep-2020 | GSheets Tip: Dinosaurs, Time and Large Numbers π² | Thought experiment with dinosaurs and large numbers! Something different ;) | https://mailchi.mp/benlcollins/gsheets-tip-dinosaurs-time-and-large-numbers |
127 | 121 | 28-Sep-2020 | GSheets Tip: Countdown function | Count down reverse number format | https://mailchi.mp/benlcollins/gsheets-tip-countdown-function |
128 | 122 | 5-Oct-2020 | GSheets Tip: Subscripts with formulas | Subscript values e.g chemical formulas | https://mailchi.mp/benlcollins/gsheets-tip-subscripts-with-formulas |
129 | 123 | 12-Oct-2020 | GSheets Tip: Wildcards In Formulas π | Wildcards in formulas | https://mailchi.mp/benlcollins/gsheets-tip-wildcards-in-formulas |
130 | 124 | 19-Oct-2020 | GSheets Tip: Select/Deselect all Checkboxes at once β | Select all checkboxes at once with space bar | https://mailchi.mp/benlcollins/gsheets-tip-select-all-checkboxes |
131 | 125 | 26-Oct-2020 | GSheets Tip: Custom Checkbox Values & Teacher Template Example | Checkbox with custom values | https://mailchi.mp/benlcollins/gsheets-tip-custom-checkbox-values |
132 | 126 | 2-Nov-2020 | GSheets Tip: Remove the header row from QUERY results | Wrap QUERY with INDEX function to remove header | https://mailchi.mp/benlcollins/gsheets-tip-remove-query-header-row |
133 | 127 | 9-Nov-2020 | GSheets Tip: How To Draw A Slope Chart | How to draw a slope chart | https://mailchi.mp/benlcollins/gsheets-tip-slope-chart |
134 | 128 | 16-Nov-2020 | GSheets Tip: Draw A Chart With The Sequence Formula | How to draw a grid chart | https://mailchi.mp/benlcollins/gsheets-tip-grid-chart |
135 | 129 | 23-Nov-2020 | GSheets Tip: Show Project Completion Status | Sparkline status bar | https://mailchi.mp/benlcollins/gsheets-tip-sparkline-status-bar |
136 | 130 | 30-Nov-2020 | GSheets Tip: Have you ever heard of GESTEP? | GESTEP function | https://mailchi.mp/benlcollins/gsheets-tip-gestep-function |
137 | 131 | 7-Dec-2020 | GSheets Tip: Apps Script just got a facelift! | New Apps Script IDE | https://mailchi.mp/benlcollins/gsheets-tip-new-apps-script-ide |
138 | 132 | 14-Dec-2020 | GSheets Tip: How To Select Randomly From A List | RANDBETWEEN and INDEX to select an item from a list | https://mailchi.mp/benlcollins/gsheets-tip-select-randomly-from-list |
139 | 133 | 21-Dec-2020 | GSheets Tip: TEXTJOIN and Formula Challenge #5 | Formula Challenge #5: Unique numbers | https://mailchi.mp/benlcollins/gsheets-tip-textjoin-and-formula-challenge-5 |
140 | 134 | 4-Jan-2021 | GSheets Tip: FLATTEN function?? Plus, Challenge #5 solution | Formula Challenge #5 Solution & Flatten function | https://mailchi.mp/benlcollins/gsheets-tip-flatten-and-formula-challenge-5-solution |
141 | 135 | 11-Jan-2021 | GSheets Tip: Two Number Formats in One Column | Double Format for column with % and number rule: [<1]0.0%;#,##0 | https://mailchi.mp/benlcollins/gsheets-tip-double-number-format |
142 | 136 | 18-Jan-2021 | GSheets Tip: Walk The First Row | Tell the story of one row + micro IP | https://mailchi.mp/benlcollins/gsheets-tip-walk-the-first-row |
143 | 137 | 25-Jan-2021 | GSheets Tip: How to format your header row | The right way to format your header rows | https://mailchi.mp/benlcollins/gsheets-tip-header-row |
144 | 138 | 1-Feb-2021 | GSheets Tip: Cakes and Column Stats | Explore your data with column stats | https://mailchi.mp/benlcollins/gsheets-tip-column-stats |
145 | 139 | 8-Feb-2021 | GSheets Tip: Why automate? | Why you should learn automation | https://mailchi.mp/benlcollins/gsheets-tip-why-automate |
146 | 140 | 15-Feb-2021 | GSheets Tip: To script or not to script... | When to use apps script or not? | https://mailchi.mp/benlcollins/gsheets-tip-to-script-or-not-to-script |
147 | 141 | 22-Feb-2021 | GSheets Tip: Toast To The Rescue π | Toast | https://mailchi.mp/benlcollins/gsheets-tip-toast |
148 | 142 | 1-Mar-2021 | GSheets Tip: Let's build a Sheet Sizer tool together! π§ | Automation launch & Sheet Sizer | https://mailchi.mp/benlcollins/gsheets-tip-sheet-sizer-1 |
149 | 143 | 8-Mar-2021 | GSheets Tip: An Elegant Formula | Sequence + Date Array Formula | https://mailchi.mp/benlcollins/gsheets-tip-monthly-sequence |
150 | 144 | 15-Mar-2021 | GSheets Tip: The Beginner's Mindset | The Beginner's Mindset | https://mailchi.mp/benlcollins/gsheets-tip-beginners-mindset |
151 | 145 | 22-Mar-2021 | GSheets Tip: Extract the n-th word | Extract nth word from sentence | https://mailchi.mp/benlcollins/gsheets-tip-word-games-with-split |
152 | 146 | 29-Mar-2021 | GSheets Tip: The Taco Chart! | Bar chart with REPT Function | https://mailchi.mp/benlcollins/gsheets-tip-rept-function-taco-chart |
153 | 147 | 5-Apr-2021 | GSheets Tip: 6 Creative Ways To Use Borders | Different border examples in Sheets & pro sheets enrollment in PS | https://mailchi.mp/benlcollins/gsheets-tip-borders |
154 | 148 | 12-Apr-2021 | GSheets Tip: Google's hidden logo library | Get company logos using Google's hidden API | https://mailchi.mp/benlcollins/gsheets-tip-google-logo-library |
155 | 149 | 19-Apr-2021 | GSheets Tip: Are they equal? | Test if values are equal with equality operator, exact function and array formula | https://mailchi.mp/benlcollins/gsheets-tip-equal |
156 | 150 | 26-Apr-2021 | GSheets Tip: π©π©π©π©π©π©β¬β¬β¬β¬ | Progress bar charts with REPT and SPARKLINE | https://mailchi.mp/benlcollins/gsheets-tip-progress-chart |
157 | 151 | 3-May-2021 | GSheets Tip: Home, sheet home π | Set a Google Sheet as your Chrome home page | https://mailchi.mp/benlcollins/gsheets-tip-home-sheet |
158 | 152 | 10-May-2021 | GSheets Tip: Array Formula to get row numbers | Row numbers of non-blank cells | https://mailchi.mp/benlcollins/gsheets-tip-row-numbers-non-blank |
159 | 153 | 17-May-2021 | GSheets Tip: Filter Function | Filter function to find row numbers of non-blank cells | https://mailchi.mp/benlcollins/gsheets-tip-filter-function |
160 | 154 | 24-May-2021 | GSheets Tip: Flatten Function | FLATTEN function | https://mailchi.mp/benlcollins/gsheets-tip-flatten-function |
161 | 155 | 31-May-2021 | GSheets Tip: Find the last value in a row | Find last value in a row | https://mailchi.mp/benlcollins/gsheets-tip-find-the-last-value-in-a-row |
162 | 156 | 7-Jun-2021 | GSheets Tip: CHOOSE your own adventure | Choose function | https://mailchi.mp/benlcollins/gsheets-tip-choose-function |
163 | 157 | 14-Jun-2021 | GSheets Tip: Random List Picker Formula | Select Random element from list | https://mailchi.mp/benlcollins/gsheets-tip-random-list-picker-formula |
164 | 158 | 21-Jun-2021 | GSheets Tip: Turbocharge your checkboxes β | Uncheck with Apps Script | https://mailchi.mp/benlcollins/gsheets-tip-turbocharge-checkboxes |
165 | 159 | 28-Jun-2021 | GSheets Tip: Better Data Management with the Range Name Box | Range Name Box | https://mailchi.mp/benlcollins/gsheets-tip-range-name-box |
166 | 160 | 5-Jul-2021 | GSheets Tip: Generate A Year Of Dates | Year Sequence Formula | https://mailchi.mp/benlcollins/gsheets-tip-generate-dates-automatically |
167 | 161 | 12-Jul-2021 | GSheets Tip: REGEX, not as hard as it looks... | REGEX formulas introduction, extract numbers example | https://mailchi.mp/benlcollins/gsheets-tip-regex-introduction |
168 | 162 | 19-Jul-2021 | GSheets Tip: Extract numbers from text | REGEX part 2: extract number with thousand separators, decimals etc. | https://mailchi.mp/benlcollins/gsheets-tip-regex-extract-numbers |
169 | 163 | 26-Jul-2021 | GSheets Tip: Oops, I made a mistake... | REGEX part 2 fix: fix the mistake with the repetition character | https://mailchi.mp/benlcollins/gsheets-tip-regex-extract-numbers-fix |
170 | 164 | 2-Aug-2021 | GSheets Tip: Match telephone numbers π | REGEX part 3: Extract phone number from string | https://mailchi.mp/benlcollins/gsheets-tip-regex-match-telephone-numbers |
171 | 165 | 9-Aug-2021 | GSheets Tip: Clever formula to switch name order | REGEX part 4: Identify transactional string | https://mailchi.mp/benlcollins/gsheets-tip-regex-name-swaperoo |
172 | 166 | 16-Aug-2021 | GSheets Tip: Go Big | Maximise space | https://mailchi.mp/benlcollins/gsheets-tip-go-big |
173 | 167 | 23-Aug-2021 | GSheets Tip: Add Row Numbers Dynamically | Adding Row Numbers Dynamically | https://mailchi.mp/benlcollins/gsheets-tip-add-row-numbers-dynamically |
174 | 168 | 30-Aug-2021 | GSheets Tip: How to create a slopegraph in Sheets | Slopegraph tutorial | https://mailchi.mp/benlcollins/gsheets-tip-slopegraph |
175 | 169 | 6-Sep-2021 | GSheets Tip: Yet another reason to use named ranges... | Named Range in IMPORTRANGE | https://mailchi.mp/benlcollins/gsheets-tip-named-ranges-importrange |
176 | 170 | 13-Sep-2021 | GSheets Tip: The REGEX cookbook | Launch REGEX cookbook | https://mailchi.mp/benlcollins/gsheets-tip-floating-bars |
177 | 171 | 20-Sep-2021 | GSheets Tip: The Right Formula And Radial Bar Charts | Use the right formula for the job | https://mailchi.mp/benlcollins/gsheets-tip-use-the-right-formula |
178 | 172 | 27-Sep-2021 | GSheets Tip: Formula To Turn Column Numbers To Letters | Going from column number to column letter | https://mailchi.mp/benlcollins/gsheets-tip-convert-column-number-to-letter |
179 | 173 | 4-Oct-2021 | New look GSheets Tip: Column Letters to Numbers | Convert column letter to number | https://mailchi.mp/benlcollins/gsheets-tip-convert-column-letter-to-number |
180 | 174 | 11-Oct-2021 | Sheets Tip #174: 10 free days this month! | Networkdays | https://mailchi.mp/benlcollins/gsheets-tip-networkdays |
181 | 175 | 18-Oct-2021 | Sheets Tip #175: QUERY function filtering trick... | QUERY where clause "starts with" | https://mailchi.mp/benlcollins/gsheets-tip-query-starts-with |
182 | 176 | 25-Oct-2021 | Sheets Tip 176: Apostrophes in the QUERY function | QUERY and apostrophes | https://mailchi.mp/benlcollins/gsheets-tip-query-apostrophes |
183 | 177 | 1-Nov-2021 | Sheets Tip 177: AI assisted data cleaning ποΈ | Cleanup suggestions | https://mailchi.mp/benlcollins/gsheets-tip-177-cleanup-suggestions |
184 | 178 | 8-Nov-2021 | Sheets Tip 178: Make Formulas More Readable | Make your formulas more readable by resizing and adding new lines | https://mailchi.mp/benlcollins/gsheets-tip-178-readable-formulas |
185 | 179 | 15-Nov-2021 | Sheets Tip 179: Advanced VLOOKUP for multi-column lookups | Multi-Column Lookup | https://mailchi.mp/benlcollins/gsheets-tip-179-vlookup-multi-column-lookup |
186 | 180 | 22-Nov-2021 | Sheets Tip 180: Lists Of Grouped Numbers With SEQUENCE | Lists of grouped numbers with sequence | https://mailchi.mp/benlcollins/gsheets-tip-180-grouped-numbers-sequence |
187 | 181 | 29-Nov-2021 | Sheets Tip 181: Shortcuts You Should Use | Shortcuts for working with ranges | https://mailchi.mp/benlcollins/gsheets-tip-181-range-shortcuts |
188 | 182 | 6-Dec-2021 | Sheets Tip 182: SUMPRODUCT, a powerful but enigmatic function | Something with sumproduct | https://mailchi.mp/benlcollins/gsheets-tip-182-sumproduct |
189 | 183 | 13-Dec-2021 | Sheets Tip 183: Weighted average with SUMPRODUCT βοΈ | Follow up to sumproduct: weigted avearge example | https://mailchi.mp/benlcollins/gsheets-tip-183-sumproduct-weighted-average |
190 | 184 | 20-Dec-2021 | Sheets Tip 184: CHICKEN and EGG finally solved! π£ | Chicken and egg sort | https://mailchi.mp/benlcollins/gsheets-tip-184-chicken-egg-sort |
191 | 185 | 3-Jan-2022 | Sheets Tip 185: 2 Quick Ways To Create New Sheets | Two quick ways to create a new Sheet | https://mailchi.mp/benlcollins/gsheets-tip-185-new-sheets |
192 | 186 | 10-Jan-2022 | Sheets Tip 186: A Creative Use Case For Slicers | Creative way to use a slicer for sections of a sheet | https://mailchi.mp/benlcollins/gsheets-tip-186-creative-slicers |
193 | 187 | 17-Jan-2022 | Sheets Tip 186: The Finder Tool π | The finder tool | https://mailchi.mp/benlcollins/gsheets-tip-187-finder-tool |
194 | 188 | 24-Jan-2022 | Sheets Tip 188: Going dotty... | Dot Plot | https://mailchi.mp/benlcollins/gsheets-tip-188-dot-plot |
195 | 189 | 31-Jan-2022 | Sheets Tip 189: How To Reference Cells in QUERY SELECT π | How to select other cells from inside the QUERY function | https://mailchi.mp/benlcollins/gsheets-tip-189-query-external-cells |
196 | 190 | 7-Feb-2022 | Sheets Tip 190: Publish To Web & Formula Studio | Publish to web and formula studio | https://mailchi.mp/benlcollins/gsheets-tip-190-publish-to-web |
197 | 191 | 14-Feb-2022 | Sheets Tip 191: Add an auto-incrementing row ID πΆ | Auto-incrementing row ID column | https://mailchi.mp/benlcollins/gsheets-tip-191-auto-incrementing-id |
198 | 192 | 21-Feb-2022 | Sheets Tip 192: SEQUENCE Data | Generate dummy data with sequence | https://benlcollins.ck.page/posts/sheets-tip-192-sequence-data |
199 | 193 | 28-Feb-2022 | Sheets Tip 193: Conditional counts with COUNTIF | COUNTIF with wildcards | https://benlcollins.ck.page/posts/sheets-tip-193-conditional-counts-with-countif |
200 | 194 | 7-Mar-2022 | Sheets Tip 194: Formula Challenge #6 π₯ | MID and Formula challenge 6: randomize letters | https://benlcollins.ck.page/posts/sheets-tip-194-formula-challenge-6 |
201 | 195 | 14-Mar-2022 | Sheets Tip 195: SEQUENCE and Formula Challenge 6 solution | Formula challenge 6 solution | https://benlcollins.ck.page/posts/sheets-tip-195-pi-sequence-and-formula-challenge-6-solution |
202 | 196 | 21-Mar-2022 | Sheets Tip 196: Wow, so many views | Sheets Activity Dashboard | https://benlcollins.ck.page/posts/sheets-tip-196-wow-so-many-views |
203 | 197 | 28-Mar-2022 | Sheets Tip 197: Highlight Top 10 | Highlight top 5 or top 10 | https://benlcollins.ck.page/posts/sheets-tip-197-highlight-top-5 |
204 | 198 | 4-Apr-2022 | Sheets Tip 198: Two Methods To Trim Whitespace | Trim whitespace | https://benlcollins.ck.page/posts/sheets-tip-198-two-methods-to-trim-whitespace |
205 | 199 | 11-Apr-2022 | Sheets Tip 199: IMPORTRANGE Backlink To Source Formula | ImportRange backlinks | https://benlcollins.ck.page/posts/sheets-tip-199-importrange-backlink-to-source-sheet |
206 | 200 | 18-Apr-2022 | 200 spreadsheet espressos! π | 200 milestone and audience survey | https://benlcollins.ck.page/posts/200-spreadsheet-espressos |
207 | 201 | 25-Apr-2022 | Sheets Tip 201: Copy Visible Cells Only | Copy only visible cell | https://benlcollins.ck.page/posts/sheets-tip-201-copy-visible-cells-only |
208 | 202 | 2-May-2022 | Sheets Tip 202: Meet within a Sheet | Meet and Sheet | https://benlcollins.ck.page/posts/sheets-tip-202-meet-within-a-sheet |
209 | 203 | 9-May-2022 | Sheets Tip 203: How To Use Arrays To Return Multiple Columns In VLOOKUP | How to create arrays | https://benlcollins.ck.page/posts/sheets-tip-203-how-to-use-arrays-to-return-multiple-columns-in-vlookup |
210 | 204 | 16-May-2022 | Sheets Tip 204: How To Use Dates In The QUERY Function | Dates with the QUERY function and QUERY function launch | https://benlcollins.ck.page/posts/sheets-tip-204-how-to-use-dates-in-the-query-function |
211 | 205 | 23-May-2022 | Sheets Tip #205: The hidden powers of custom numbers formats... π | Custom number formats | https://benlcollins.ck.page/posts/sheets-tip-205-the-hidden-powers-of-custom-numbers-formats |
212 | 206 | 30-May-2022 | Sheets Tip 206: Create barcodes in Sheets βββββββββββββββ | Barcodes in Sheets | https://benlcollins.ck.page/posts/sheets-tip-206-create-barcodes-in-sheets |
213 | 207 | 6-Jun-2022 | Sheets Tip 207: Get unique values from grouped lists | Get unique values from grouped lists | https://benlcollins.ck.page/posts/sheets-tip-207-get-unique-values-from-grouped-lists |
214 | 208 | 13-Jun-2022 | Sheets Tip 208: Google Finance 5 secrets & An equation to change your worldview | 5 Secrets of the Google Finance Function | https://benlcollins.ck.page/posts/sheets-tip-208-google-finance-5-secrets-an-equation-to-change-your-worldview |
215 | 209 | 20-Jun-2022 | Sheets Tip 209: New lines with the magic CHAR function | Add line breaks to strings with CHAR(10) | https://benlcollins.ck.page/posts/sheets-tip-209-new-lines-with-the-magic-char-function |
216 | 210 | 27-Jun-2022 | Sheets Tip 210: Day first or month first? Fixing mixed date columns | Fixing Dates in mixed column of US and UK types | https://benlcollins.ck.page/posts/sheets-tip-210-day-first-or-month-first-fixing-mixed-date-columns |
217 | 211 | 5-Jul-2022 | Sheets Tip 211: Spreadsheet Competition & How To Open All Links At Once | Open all links at once | https://benlcollins.ck.page/posts/sheets-tip-211-spreadsheet-competition-how-to-open-all-links-at-once |
218 | 212 | 11-Jul-2022 | Sheets Tip 212: Single Formula Year Calendar! π | Calendar with SEQUENCE function | https://benlcollins.ck.page/posts/sheets-tip-212-single-formula-year-calendar |
219 | 213 | 18-Jul-2022 | Sheets Tip 213: Improvements to the single formula calendar | Calendar with SEQUENCE function - Part II | https://benlcollins.ck.page/posts/sheets-tip-213-improvements-to-the-single-formula-calendar |
220 | 214 | 25-Jul-2022 | Sheets Tip 214: Changing Sheets Ownership π | Change owner of a Google Sheet | https://benlcollins.ck.page/posts/sheets-tip-214-changing-sheets-ownership |
221 | 215 | 1-Aug-2022 | Sheets 215: Understanding Spreadsheet Errors | Understanding spreadsheet errors | https://benlcollins.ck.page/posts/sheets-215-understanding-spreadsheet-errors |
222 | 216 | 8-Aug-2022 | Sheets Tip 216: Dashboard Ideas! | Dashboard Ideas | https://benlcollins.ck.page/posts/sheets-tip-216-dashboard-ideas |
223 | 217 | 15-Aug-2022 | Sheets Tip 217: Three Tips For Better Navigation π§ | Go To Navigation (F2 inside formulas, copying range into reference bar, hidden Go To) | https://benlcollins.ck.page/posts/sheets-tip-217-three-tips-for-better-navigation |
224 | 218 | 22-Aug-2022 | Sheets Tip 218: Amazing In-Cell Sparkline Progress Charts | Sparkline Progress Bar Charts | https://benlcollins.ck.page/posts/sheets-tip-218-amazing-in-cell-sparkline-progress-charts |
225 | 219 | 29-Aug-2022 | Sheets Tip 219: The new Named Functions are a game changer | Named functions | https://benlcollins.ck.page/posts/sheets-tip-219-the-new-named-functions-are-a-game-changer |
226 | 220 | 6-Sep-2022 | Sheets Tip 220: The new MAP function! πΊοΈ | The MAP function | https://benlcollins.ck.page/posts/sheets-tip-220-the-new-map-function |
227 | 221 | 12-Sep-2022 | Sheets Tip 221: Pivot like a pro! | Pivot table 3 tips | https://benlcollins.ck.page/posts/sheets-tip-221-pivot-like-a-pro |
228 | 222 | 19-Sep-2022 | Sheets Tip 222: Formulas to build lists like 1 of 10, 2 of 10, etc. | 1 of 10 sequences | https://benlcollins.ck.page/posts/sheets-tip-222-formulas-to-build-lists-like-1-of-10-2-of-10-etc |
229 | 223 | 26-Sep-2022 | Sheets Tip 223: Sort by length formula | Sort by length | https://benlcollins.ck.page/posts/sheets-tip-223-sort-by-length-formula |
230 | 224 | 3-Oct-2022 | Sheets Tip 224: I do this with every new dataset... | Steps I take with every new table | https://benlcollins.ck.page/posts/sheets-tip-224-i-do-this-with-every-new-dataset |
231 | 225 | 10-Oct-2022 | Sheets Tip 225: Stack two tables dynamically | Stack two tables with the {...} array literals | https://benlcollins.ck.page/posts/sheets-tip-225-stack-two-tables-dynamically |
232 | 226 | 17-Oct-2022 | Sheets Tip 226: New Announcements From The Google Conference π§ | Google Cloud Next Recap | https://benlcollins.ck.page/posts/sheets-tip-226-new-announcements-from-the-google-conference-1 |
233 | 227 | 24-Oct-2022 | Sheets Tip 227: Yet more ways to stack tables... | Stack two tables with QUERY function alternative | https://ckarchive.com/b/68ueh8hkw3dp6 |
234 | 228 | 31-Oct-2022 | Sheets Tip 228: Mega running total SCAN formulas & halloween functions π | Scan function | https://benlcollins.ck.page/posts/sheets-tip-228-mega-running-total-scan-formulas-halloween-functions |
235 | 229 | 7-Nov-2022 | Sheets Tip 229: My most heavily used shortcut | Copy and Paste Special | https://benlcollins.ck.page/posts/sheets-tip-229-my-most-frequently-used-shortcut |
236 | 230 | 14-Nov-2022 | Sheets Tip 230: How to add indicator arrows to data | Indicator Arrows, mention Black Friday sale coming up | https://benlcollins.ck.page/posts/sheets-tip-230-how-to-add-indicator-arrows-to-data |
237 | 231 | 21-Nov-2022 | Sheets Tip 231: Never again miss a change to your Sheet | Black Friday week | https://benlcollins.ck.page/posts/sheets-tip-231-never-again-miss-a-change-to-your-sheet |
238 | 232 | 5-Dec-2022 | Sheets Tip 232: New Timeline (Gantt) Charts in Sheets | New timeline charts | https://benlcollins.ck.page/posts/sheets-tip-232-new-chart-in-sheets-timeline-view-aka-gantt-charts |
239 | 233 | 12-Dec-2022 | Sheets Tip 233: How to categorize data with IFS | How to categorize with IFS | https://benlcollins.ck.page/posts/sheets-tip-233-how-to-categorize-data-with-ifs |
240 | 234 | 19-Dec-2022 | Sheets Tip 234: Freeze rows with Grabby Hand | Freeze rows with grabby hand | https://benlcollins.ck.page/posts/sheets-tip-234-freeze-rows-with-grabby-hand |
241 | 235 | 3-Jan-2023 | Sheets Tip 235: Secret Date Trick and a Happy New Year! π | Date picker | https://benlcollins.ck.page/posts/sheets-tip-235-secret-date-trick-and-a-happy-new-year |
242 | 236 | 9-Jan-2023 | Sheets Tip 236: New Drop-Down Chips! | New drop down menus + update blog post | https://benlcollins.ck.page/posts/sheets-tip-236-new-drop-down-chips |
243 | 237 | 16-Jan-2023 | Sheets Tip 237: Mini Bullet Charts With The Sparkline Function | Bullet Chart (sort-of) with Sparklines | https://benlcollins.ck.page/posts/sheets-tip-237-mini-bullet-charts-with-the-sparkline-function |
244 | 238 | 23-Jan-2023 | Sheets Tip 238: Help your colleagues and clients with a Front Sheet | Front Sheet concept | https://benlcollins.ck.page/posts/sheets-tip-238-help-your-colleagues-and-clients-with-a-front-sheet |
245 | 239 | 30-Jan-2023 | Sheets Tip 239: Google Search Formulas in Sheets & Book Recs π | Google Search functions and book recs | https://benlcollins.ck.page/posts/sheets-tip-239-google-search-formulas-in-sheets-book-recs |
246 | 240 | 6-Feb-2023 | Sheets Tip 240: Simplify with Named Functions | Named Functions | https://benlcollins.ck.page/posts/sheets-tip-240-simplify-with-named-functions |
247 | 241 | 13-Feb-2023 | Sheets Tip 241: A Chart Makeover π | Chart makeover | https://benlcollins.ck.page/posts/sheets-tip-241-a-chart-makeover |
248 | 242 | 20-Feb-2023 | Sheets Tip 242: Before And After Table Makeover | Table makeover with smart chips | https://benlcollins.ck.page/posts/sheets-tip-242-before-and-after-table-makeover |
249 | 243 | 27-Feb-2023 | Sheets Tip 243: Repeating Sequences And Formula Challenge 7 | Repeating sequence and formula challenge 7 | https://benlcollins.ck.page/posts/sheets-tip-243-repeating-sequences-and-formula-challenge-7 |
250 | 244 | 6-Mar-2023 | Sheets Tip 244: CHOOSE from a smorgasbord of formulas! (Challenge #7 solutions) | CHOOSE and formula challenge 7 solutions | https://benlcollins.ck.page/posts/sheets-tip-244-choose-from-a-smorgasbord-of-formulas-challenge-7-solutions |
251 | 245 | 13-Mar-2023 | Sheets Tip 245: Sheets Facelift! π | New material design look for Sheets. Plus, share this link: https://www.levels.fyi/blog/scaling-to-millions-with-google-sheets.html | https://benlcollins.ck.page/posts/sheets-tip-245-sheets-facelift |
252 | 246 | 20-Mar-2023 | Sheets Tip 246: Automatic Sheet Copying | Something from the Tab manager app & apps script course tease | https://benlcollins.ck.page/posts/sheets-tip-246-automatic-sheet-copying |
253 | 247 | 27-Mar-2023 | Sheets Tip 247: Amazing what you can do with 5 lines of code... | Apps Script course launch week | https://benlcollins.ck.page/posts/sheets-tip-247-amazing-what-you-can-do-with-5-lines-of-code |
254 | 248 | 3-Apr-2023 | Sheets tip 248: Oooh, I like these new date shortcuts... | New date shortcuts | https://benlcollins.ck.page/posts/sheets-tip-248-oooh-i-like-these-new-date-shortcuts |
255 | 249 | 10-Apr-2023 | Sheets tip 249: New Smart Chips in Google Sheets | New smart chips | https://benlcollins.ck.page/posts/sheets-tip-249-new-smart-chips-in-google-sheets |
256 | 250 | 17-Apr-2023 | Sheets tip 250: Round Robin scoring grid formula (MAKEARRAY) | MAKEARRAY to generate a round robin scoring grid | https://benlcollins.ck.page/posts/sheets-tip-250-round-robin-scoring-grid-formula-makearray |
257 | 251 | 24-Apr-2023 | Sheets tip 251: Use heatmaps to show trends in your data | Heat maps | https://benlcollins.ck.page/posts/sheets-tip-251-use-heatmaps-to-show-trends-in-your-data |
258 | 252 | 1-May-2023 | Sheets Tip #252: Don't sleep on the super useful Filter Views feature | Filter views | https://benlcollins.ck.page/posts/sheets-tip-252-don-t-sleep-on-the-super-useful-filter-views-feature |
259 | 253 | 8-May-2023 | Sheets Tip 253: Combine tables easily with VSTACK | VSTACK formula | https://benlcollins.ck.page/posts/sheets-tip-253-combine-tables-easily-with-vstack |
260 | 254 | 15-May-2023 | Sheets Tip 254: Different ways to multiply a column. How many do you know? | 3 ways to multiply a column: Array, BYROW, MMULT + Google I/O announcements | https://benlcollins.ck.page/posts/sheets-tip-254-different-ways-to-multiply-a-column-how-many-do-you-know |
261 | 255 | 22-May-2023 | Sheets Tip 255: Running totals and the SCAN function π | Running totals and SCAN function | https://benlcollins.ck.page/posts/sheets-tip-255-running-totals-and-the-scan-function |
262 | |||||
263 | |||||
264 | |||||
265 | |||||
266 | |||||
267 | |||||
268 | |||||
269 | |||||
270 | |||||
271 | |||||
272 | |||||
273 | |||||
274 | |||||
275 | |||||
276 | |||||
277 | |||||
278 | |||||
279 | |||||
280 | |||||
281 | |||||
282 | |||||
283 | |||||
284 | |||||
285 | |||||
286 | |||||
287 | |||||
288 | |||||
289 | |||||
290 | |||||
291 | |||||
292 | |||||
293 | |||||
294 | |||||
295 | |||||
296 | |||||
297 | |||||
298 | |||||
299 | |||||
300 | |||||
301 | |||||
302 | |||||
303 | |||||
304 | |||||
305 | |||||
306 | |||||
307 | |||||
308 | |||||
309 | |||||
310 | |||||
311 | |||||
312 | |||||
313 | |||||
314 | |||||
315 | |||||
316 | |||||
317 | |||||
318 | |||||
319 | |||||
320 | |||||
321 | |||||
322 | |||||
323 | |||||
324 | |||||
325 | |||||
326 | |||||
327 | |||||
328 | |||||
329 | |||||
330 | |||||
331 | |||||
332 | |||||
333 | |||||
334 | |||||
335 | |||||
336 | |||||
337 | |||||
338 | |||||
339 | |||||
340 | |||||
341 | |||||
342 | |||||
343 | |||||
344 | |||||
345 | |||||
346 | |||||
347 | |||||
348 | |||||
349 | |||||
350 | |||||
351 | |||||
352 | |||||
353 | |||||
354 | |||||
355 | |||||
356 | |||||
357 | |||||
358 | |||||
359 | |||||
360 | |||||
361 | |||||
362 | |||||
363 | |||||
364 | |||||
365 | |||||
366 | |||||
367 | |||||
368 | |||||
369 | |||||
370 | |||||
371 | |||||
372 | |||||
373 | |||||
374 | |||||
375 | |||||
376 | |||||
377 | |||||
378 | |||||
379 | |||||
380 | |||||
381 | |||||
382 | |||||
383 | |||||
384 | |||||
385 | |||||
386 | |||||
387 | |||||
388 | |||||
389 | |||||
390 | |||||
391 | |||||
392 | |||||
393 | |||||
394 | |||||
395 | |||||
396 | |||||
397 | |||||
398 | |||||
399 | |||||
400 | |||||
401 | |||||
402 | |||||
403 | |||||
404 | |||||
405 | |||||
406 | |||||
407 | |||||
408 | |||||
409 | |||||
410 | |||||
411 | |||||
412 | |||||
413 | |||||
414 | |||||
415 | |||||
416 | |||||
417 | |||||
418 | |||||
419 | |||||
420 | |||||
421 | |||||
422 | |||||
423 | |||||
424 | |||||
425 | |||||
426 | |||||
427 | |||||
428 | |||||
429 | |||||
430 | |||||
431 | |||||
432 | |||||
433 | |||||
434 | |||||
435 | |||||
436 | |||||
437 | |||||
438 | |||||
439 | |||||
440 | |||||
441 | |||||
442 | |||||
443 | |||||
444 | |||||
445 | |||||
446 | |||||
447 | |||||
448 | |||||
449 | |||||
450 | |||||
451 | |||||
452 | |||||
453 | |||||
454 | |||||
455 | |||||
456 | |||||
457 | |||||
458 | |||||
459 | |||||
460 | |||||
461 | |||||
462 | |||||
463 | |||||
464 | |||||
465 | |||||
466 | |||||
467 | |||||
468 | |||||
469 | |||||
470 | |||||
471 | |||||
472 | |||||
473 | |||||
474 | |||||
475 | |||||
476 | |||||
477 | |||||
478 | |||||
479 | |||||
480 | |||||
481 | |||||
482 | |||||
483 | |||||
484 | |||||
485 | |||||
486 | |||||
487 | |||||
488 | |||||
489 | |||||
490 | |||||
491 | |||||
492 | |||||
493 | |||||
494 | |||||
495 | |||||
496 | |||||
497 | |||||
498 | |||||
499 | |||||
500 | |||||
501 | |||||
502 | |||||
503 | |||||
504 | |||||
505 | |||||
506 | |||||
507 | |||||
508 | |||||
509 | |||||
510 | |||||
511 | |||||
512 | |||||
513 | |||||
514 | |||||
515 | |||||
516 | |||||
517 | |||||
518 | |||||
519 | |||||
520 | |||||
521 | |||||
522 | |||||
523 | |||||
524 | |||||
525 | |||||
526 | |||||
527 | |||||
528 | |||||
529 | |||||
530 | |||||
531 | |||||
532 | |||||
533 | |||||
534 | |||||
535 | |||||
536 | |||||
537 | |||||
538 | |||||
539 | |||||
540 | |||||
541 | |||||
542 | |||||
543 | |||||
544 | |||||
545 | |||||
546 | |||||
547 | |||||
548 | |||||
549 | |||||
550 | |||||
551 | |||||
552 | |||||
553 | |||||
554 | |||||
555 | |||||
556 | |||||
557 | |||||
558 | |||||
559 | |||||
560 | |||||
561 | |||||
562 | |||||
563 | |||||
564 | |||||
565 | |||||
566 | |||||
567 | |||||
568 | |||||
569 | |||||
570 | |||||
571 | |||||
572 | |||||
573 | |||||
574 | |||||
575 | |||||
576 | |||||
577 | |||||
578 | |||||
579 | |||||
580 | |||||
581 | |||||
582 | |||||
583 | |||||
584 | |||||
585 | |||||
586 | |||||
587 | |||||
588 | |||||
589 | |||||
590 | |||||
591 | |||||
592 | |||||
593 | |||||
594 | |||||
595 | |||||
596 | |||||
597 | |||||
598 | |||||
599 | |||||
600 | |||||
601 | |||||
602 | |||||
603 | |||||
604 | |||||
605 | |||||
606 | |||||
607 | |||||
608 | |||||
609 | |||||
610 | |||||
611 | |||||
612 | |||||
613 | |||||
614 | |||||
615 | |||||
616 | |||||
617 | |||||
618 | |||||
619 | |||||
620 | |||||
621 | |||||
622 | |||||
623 | |||||
624 | |||||
625 | |||||
626 | |||||
627 | |||||
628 | |||||
629 | |||||
630 | |||||
631 | |||||
632 | |||||
633 | |||||
634 | |||||
635 | |||||
636 | |||||
637 | |||||
638 | |||||
639 | |||||
640 | |||||
641 | |||||
642 | |||||
643 | |||||
644 | |||||
645 | |||||
646 | |||||
647 | |||||
648 | |||||
649 | |||||
650 | |||||
651 | |||||
652 | |||||
653 | |||||
654 | |||||
655 | |||||
656 | |||||
657 | |||||
658 | |||||
659 | |||||
660 | |||||
661 | |||||
662 | |||||
663 | |||||
664 | |||||
665 | |||||
666 | |||||
667 | |||||
668 | |||||
669 | |||||
670 | |||||
671 | |||||
672 | |||||
673 | |||||
674 | |||||
675 | |||||
676 | |||||
677 | |||||
678 | |||||
679 | |||||
680 | |||||
681 | |||||
682 | |||||
683 | |||||
684 | |||||
685 | |||||
686 | |||||
687 | |||||
688 | |||||
689 | |||||
690 | |||||
691 | |||||
692 | |||||
693 | |||||
694 | |||||
695 | |||||
696 | |||||
697 | |||||
698 | |||||
699 | |||||
700 | |||||
701 | |||||
702 | |||||
703 | |||||
704 | |||||
705 | |||||
706 | |||||
707 | |||||
708 | |||||
709 | |||||
710 | |||||
711 | |||||
712 | |||||
713 | |||||
714 | |||||
715 | |||||
716 | |||||
717 | |||||
718 | |||||
719 | |||||
720 | |||||
721 | |||||
722 | |||||
723 | |||||
724 | |||||
725 | |||||
726 | |||||
727 | |||||
728 | |||||
729 | |||||
730 | |||||
731 | |||||
732 | |||||
733 | |||||
734 | |||||
735 | |||||
736 | |||||
737 | |||||
738 | |||||
739 | |||||
740 | |||||
741 | |||||
742 | |||||
743 | |||||
744 | |||||
745 | |||||
746 | |||||