FormulaDesk

Spreadsheet formula tools · Updated May 13, 2026

Build the spreadsheet formula before you read the guide.

Generate XLOOKUP, SUMIFS, and QUERY formulas, then open tested examples, error fixes, and platform notes when you need the details.

89 formula guides 10 task hubs 0 signup walls 

      

        
        Open formula library
      

    

  

  

    Diagnose an errorStart with #N/A, #VALUE!, #REF!, #SPILL!, or a wrong answer.
    Fix XLOOKUPCheck missing matches, hidden spaces, range sizes, and version support.
    Sum by monthBuild monthly reports with two date criteria and copyable formulas.
    Filter with QUERYUse and, or, dates, and text conditions in Google Sheets reports.
    Make a pivot summaryTurn raw rows into grouped totals without overbuilding formulas.
  

  
  
  

    

      
Why this is a tool site

      
FormulaDesk starts with a working formula builder, then supports the answer with syntax, examples, mistakes, and platform notes. The goal is to solve the spreadsheet task first and let the guide explain the why.

    

    

      Copyable formulas
      Worked sample data
      Error diagnosis
      Excel and Sheets notes
    

  

  

    

      
Built for search intent

      
Every page answers one spreadsheet job

      
People rarely search for spreadsheet theory. They search because a report is broken, a lookup failed, or a manager needs a number now. FormulaDesk keeps each page focused on a single job: formula, example, mistake, fix, and next step.

    

    

      

        Fast answer first
        Quick answer blocks and copy buttons help visitors solve the task before they scroll.
      

      

        Crawlable structure
        Static URLs, canonical tags, sitemap, breadcrumbs, FAQ schema, and internal hubs are generated at build time.
      

      

        Editorial standard
        Each guide separates syntax, examples, compatibility notes, common mistakes, and related formulas.
      

    

  

  

    
Start with common spreadsheet problems

    
  

    
          
            Remove Duplicates with a Formula
            
Remove duplicate rows or values dynamically with UNIQUE in Excel or Google Sheets.

          
          
            Merge Two Columns in Excel or Google Sheets
            
Combine first name and last name, city and state, or other columns with a delimiter.

          
          
            Google Sheets QUERY Limit
            
Limit the number of rows returned by a Google Sheets QUERY formula.

          
          
            Find Duplicates with a Formula
            
Use COUNTIF or COUNTIFS to identify duplicate spreadsheet rows or values.

          
          
            Keep Leading Zeroes in Excel or Google Sheets
            
Preserve leading zeroes in ZIP codes, IDs, SKU codes, and imported text values.

          
          
            Percent Change Formula
            
Calculate percentage increase or decrease between an old value and a new value.

          
  

  

  

    

      
Problem clusters

      
Jump straight to the task

      
These clusters are built around how people actually search: something is broken, a report needs a number, or messy data needs to be cleaned before formulas work.

    

    

      
      
      
    

  

  

    
Browse every formula category

    
  

    
          
            Lookup & Reference
            
Find matching values, return related records, and replace old lookup habits with clearer formulas.

          
          
            Aggregation & Counting
            
Sum, count, average, and group spreadsheet data with criteria that match real reports.

          
          
            Google Sheets QUERY
            
Use Google Sheets QUERY clauses for select, where, group by, order by, labels, and pivots.

          
          
            Dynamic Arrays
            
Filter, sort, stack, and transform ranges with modern spreadsheet formulas.

          
          
            Text Cleanup
            
Clean names, IDs, emails, imported data, extra spaces, and inconsistent text.

          
          
            Date & Time
            
Calculate workdays, date gaps, due dates, month ends, and spreadsheet-friendly date values.

          
          
            Logic & Error Fixes
            
Fix common spreadsheet errors and write formulas that fail gracefully.

          
          
            Pivot Tables
            
Build useful pivot tables, refresh reports, group values, and troubleshoot odd totals.

          
          
            Formatting
            
Use conditional formatting, number formats, date formats, and visual rules that make sheets easier to read.

          
          
            Comparisons
            
Choose the right formula by comparing similar functions, tradeoffs, and platform differences.