Changelog
Track the latest updates, new tutorials, and improvements to SheetHelper.
August 2026
New Tutorials
- XLOOKUP Not Working in Excel - Troubleshooting guide for
#N/A,#VALUE!,#SPILL!, wrong results, copied formulas, data type mismatches, and blocked dynamic-array results
July 2026
New Tutorials
- Excel FILTER vs VLOOKUP - Decision guide for choosing between one-value lookups and dynamic matching-row reports, including multiple matches, multiple criteria, compatibility, and common formula mistakes
- IF with AND OR in Excel - Multi-condition IF guide for AND logic, OR logic, combined AND/OR rules, row labels, numeric thresholds, and common formula mistakes
- SUMIF vs SUMIFS in Excel - Decision guide for choosing between single-condition and multi-condition totals, including criteria order, date ranges, repeated records, list matching, and common formula mistakes
- COUNTIF vs COUNTIFS in Excel - Decision guide for choosing between single-condition and multi-condition counts, including criteria pairs, date ranges, duplicate checks, list comparisons, and common formula mistakes
- How to Find Duplicates in Excel - Review-first guide for highlighting duplicate values, flagging repeated rows with COUNTIF and COUNTIFS, checking multi-column duplicates, and deciding when to remove duplicates safely
- How to Compare Two Columns in Excel - Practical comparison guide for finding matches, missing values, row-by-row differences, duplicate checks, and related data with COUNTIF, XLOOKUP, FILTER, and Conditional Formatting
- VLOOKUP with Multiple Criteria in Excel - Helper-column and formula-based lookup guide for combining two or more criteria, avoiding duplicate lookup keys, using CHOOSE, and choosing XLOOKUP or INDEX MATCH alternatives
- How to Use VLOOKUP Across Sheets in Excel - Practical guide to writing VLOOKUP formulas between worksheets, including quoted sheet names, locked lookup ranges, Excel Tables, #N/A fixes, and when XLOOKUP is cleaner
- How to Fix VLOOKUP #N/A in Excel - Focused troubleshooting guide for exact match failures, hidden spaces, numbers stored as text, lookup range mistakes, and IFNA fallback messages
- Excel Pivot Tables for Beginners — Step-by-step PivotTable guide for preparing source data, creating summaries, using rows, columns, values, and filters, grouping dates, refreshing reports, and avoiding common mistakes
- Excel FILTER Function Tutorial — Dynamic array guide covering single and multiple criteria, empty results, selected columns, sorted outputs, unique lists, and common FILTER errors
- Excel SUMIF and SUMIFS Tutorial — Practical guide to conditional totals with one or multiple criteria, including text, numbers, dates, blanks, and common troubleshooting patterns
- Excel Dynamic Array Formulas — Complete guide to spilled ranges, version compatibility, FILTER, SORT, UNIQUE, SEQUENCE, TEXTSPLIT, and common dynamic array errors
- Excel XLOOKUP Tutorial — Step-by-step guide to exact matches, left lookups, multiple returned columns, missing-value handling, and common XLOOKUP fixes
- VLOOKUP vs XLOOKUP vs INDEX MATCH — Decision guide comparing lookup formulas by compatibility, flexibility, syntax, and maintainability
Site Features
- Added working category filters for the posts index, including Excel Basics, Formulas & Functions, Data Cleaning, Data Analysis, and PivotTables
- Updated homepage, header, and footer guide links to point to real content categories
Improvements
- Normalized existing article categories so formula, data cleaning, data analysis, and PivotTable guides group consistently
- Improved related-article matching to use article frontmatter categories
February 2026
New Tutorials
- Excel Data Validation — Complete guide covering drop-down lists, dependent cascading lists, custom formula validation, and error alerts
Improvements
- Fixed an issue where some formula code blocks displayed incorrectly on the page
January 2026
New Tutorials
- Excel Data Validation — Learn how to create dropdown lists, restrict input ranges, and set up custom validation rules
- Excel Find and Replace — Advanced techniques for searching and replacing data across worksheets
- Excel Text Functions — Master text manipulation functions including LEFT, RIGHT, MID, CONCATENATE, and more
Improvements
- Updated Excel Text Function tutorial with detailed examples and step-by-step images
- Enhanced Excel SUM Function guide with new image references and clearer explanations
- Added monthly view trends chart to track popular content and site statistics
December 2025
New Tutorials
- Excel COUNT Function — Complete guide to COUNT, COUNTA, COUNTBLANK, COUNTIF, and COUNTIFS
- Excel IF Function — Step-by-step tutorial on conditional logic with nested IF examples
Site Features
- Added table of contents navigation for easier article browsing
- Added related articles section to help discover relevant guides
Improvements
- Updated Excel tutorial posts with English translations and animated GIFs
- Improved markdown rendering with DaisyUI styled horizontal rules
November 2025
New Tutorials
- Excel PivotTable Error Display — Analysis of how PivotTables handle and display error values
Site Features
- Added tags support to article metadata for better content organization
- Implemented cookie consent banner with Google Analytics integration
- Added page titles to all routes for better SEO
Improvements
- Updated privacy policy and cookie policy documentation
- Refined about page content
October 2025
Improvements
- Added cover images to all posts for a more visual browsing experience
- Improved table styling in markdown content
- Updated feedback section text for better clarity
September 2025
New Tutorials
- Excel Conditional Formatting — Complete guide to highlighting cells, data bars, color scales, and icon sets
- Excel Data Cleaning — Techniques for cleaning and transforming messy spreadsheet data
- Excel Formula Errors — Comprehensive guide to understanding and fixing common formula errors
Site Features
- Added post sorting functionality (newest, oldest, alphabetical, popular)
- Implemented monthly popular posts tracking and display
- Added dynamic recent articles section on homepage
- Added global SEO meta descriptions and keywords for better search visibility
- Implemented post view tracking and statistics
Improvements
- Added inline code block styling in markdown content
- Optimized article utilities and markdown processing modules
August 2025
Site Launch
- SheetHelper officially launched with initial Excel and Google Sheets tutorials
- Core features: article system, responsive design, dark mode support
- Initial tutorials covering VLOOKUP, cell references, sorting, autofill, and more