Formula Library — Every Formula, Validated
Browse ready-to-use formula templates for Excel, Google Sheets, SQL, and regex. Each formula includes a step-by-step breakdown, edge-case warnings, and real-world examples.
Browse hundreds of AI-generated formulas for Excel, Google Sheets, SQL, and regex. Every formula is validated against edge cases.
VLOOKUP With Multiple Criteria
Standard VLOOKUP only matches one column. Here's how to match on two or more criteria using INDEX-MATCH arrays.
INDEX MATCH Formula
INDEX-MATCH is the most powerful lookup formula in Excel. It's faster, more flexible, and more reliable than VLOOKUP.
XLOOKUP With Multiple Criteria
XLOOKUP simplifies multi-criteria lookups in Excel 365. No array formulas, no helper columns — just clean syntax.
VLOOKUP vs XLOOKUP
XLOOKUP is the modern replacement for VLOOKUP. Here's exactly when to use each — and why XLOOKUP wins in most cases.
SUMIFS With Multiple Conditions
SUMIFS lets you sum a range based on 2, 3, or more criteria. It's the workhorse formula for financial analysis and reporting.
COUNTIFS With Multiple Conditions
Count rows that match two or more criteria simultaneously. Essential for dashboards, KPI tracking, and data validation.
SUMPRODUCT for Conditional Calculations
SUMPRODUCT is the Swiss Army knife of Excel formulas. It handles weighted averages, complex conditions, and calculations SUMIFS can't.
Nested IF With Multiple Conditions
Nested IFs get messy fast. Here's how to write them cleanly — and when to use IFS or SWITCH instead.
IFERROR Formula
Stop ugly error messages from appearing in your spreadsheets. IFERROR catches any error and returns a clean fallback value.
Split Text With Formulas
Extract first names, last names, domains, or any delimited data using formulas instead of the Text to Columns wizard.
Dynamic Named Ranges With OFFSET
Stop updating range references manually. Dynamic named ranges grow and shrink automatically as your data changes.
Conditional Formatting With Formulas
Built-in conditional formatting rules are limited. Custom formulas let you highlight based on any logic you can write.
Calculate Date Differences
Find the exact number of days, months, or years between two dates. Including business days that skip weekends and holidays.
Percentage Change Formula
Calculate growth rates, month-over-month changes, and YoY comparisons. With proper handling for zero and negative baselines.
Remove Duplicates With Formulas
Extract a clean list of unique values without modifying your original data. UNIQUE for Excel 365, COUNTIF tricks for older versions.
Pivot Table Calculated Fields
Add custom calculations like profit margins, unit economics, and derived metrics directly inside your Pivot Table.
QUERY Function Basics
QUERY brings SQL-like power to Google Sheets. Filter, sort, group, and aggregate data with a single formula.
ARRAYFORMULA Basics
Write the formula once in the header row. It automatically applies to every row below. No dragging, no copying.
IMPORTRANGE With QUERY
Pull specific data from another Google Sheets file and filter it — all in one formula. The most powerful cross-sheet technique.
FILTER Function in Google Sheets
FILTER returns rows from a range that meet your conditions. Simpler than QUERY for straightforward filtering.
JOIN Three Tables
Most real queries need data from 3+ tables. Here's the clean pattern for multi-table JOINs that actually performs well.
SQL Window Functions
Window functions let you calculate across rows without grouping. Rankings, running totals, and row comparisons — all in one query.
GROUP BY With HAVING
WHERE filters rows before grouping. HAVING filters groups after aggregation. Know when to use each.
Extract Email Addresses
A battle-tested regex pattern for finding email addresses in unstructured text. Handles common formats and edge cases.
Extract Numbers From Text
Pull numbers out of messy text data — prices, measurements, IDs, or any numeric value embedded in strings.
Weighted Average Formula
Regular AVERAGE treats all values equally. Weighted average accounts for importance — grades, portfolio weights, survey responses.
Data Validation Dropdown Lists
Dropdown lists prevent bad data entry and make spreadsheets more user-friendly. Here's how to create them — static and dynamic.
Moving Average Formula
Smooth out noisy data with moving averages. Essential for sales trends, stock analysis, and KPI dashboards.
INDIRECT Function
INDIRECT converts text strings into cell references. Use it to dynamically reference sheets, create flexible formulas, and build cascading dropdowns.
Concatenate Text in Excel
Combine first name + last name, build addresses, or merge any text. Three methods compared: &, CONCAT, and TEXTJOIN.
LET Function
Stop repeating the same calculation 3 times in one formula. LET defines variables you can reuse — making formulas shorter, faster, and readable.
LAMBDA Function
LAMBDA lets you create your own reusable functions in Excel — without writing a single line of VBA. Define it once, use it everywhere.
FILTER Function (Excel)
FILTER extracts rows that match your criteria and spills the results automatically. No helper columns, no manual filtering.
SORT Function (Excel)
SORT and SORTBY create live-sorted copies of your data. Change the source, the sorted output updates automatically.
UNIQUE Function (Excel)
UNIQUE returns a dynamic list of distinct values from a range. No more Remove Duplicates button or helper columns.
SEQUENCE Function
SEQUENCE creates dynamic arrays of numbers. Build date ranges, row numbers, time slots, and matrix scaffolding without typing.
SUBSTITUTE Function
SUBSTITUTE replaces text within a cell using a formula. Clean messy data, standardize formats, and fix text issues automatically.
OFFSET Function
OFFSET creates references that move and resize based on parameters. Essential for auto-expanding ranges, rolling calculations, and dynamic charts.
CHOOSE Function
CHOOSE picks a value from a list based on an index number. It's a cleaner alternative to nested IF statements for fixed options.
GOOGLEFINANCE Function
Pull real-time stock prices, historical data, and financial metrics directly into your spreadsheet. Build portfolio trackers and watchlists.
CTE (Common Table Expression)
CTEs (WITH clause) break complex queries into named steps. Replace nested subqueries with clean, readable, maintainable SQL.
CASE WHEN Statement
CASE WHEN is SQL's IF-THEN-ELSE. Categorize data, create conditional aggregations, and build pivot-like outputs.
COALESCE Function
COALESCE returns the first non-NULL value from a list. Essential for default values, NULL-safe calculations, and clean query output.
SQL Subqueries
Subqueries let you use the result of one query inside another. Essential for filtering, comparisons, and derived tables.
IP Address Regex
Match and validate IPv4 addresses in text. From quick-and-dirty patterns to strict 0-255 range validation.
URL Extraction Regex
Find and extract URLs from unstructured text. Match full URLs, domains, or specific URL components with tested patterns.
Password Validation Regex
Enforce password strength rules with regex. Minimum length, character requirements, and common patterns for registration forms.
TRIM & CLEAN Functions
Data from imports, copies, and web scraping often has invisible junk characters and extra spaces. TRIM and CLEAN fix them.
TEXTJOIN Function
TEXTJOIN combines text from a range with any delimiter you choose. Replaces chained CONCATENATE or ampersand (&) formulas.
LEFT, RIGHT, MID Functions
Pull characters from the start, end, or middle of text. Essential for parsing product codes, IDs, and fixed-format data.
IF with AND/OR
Use AND and OR inside IF to test multiple conditions cleanly. Handle complex business rules without deeply nested formulas.
NPV and IRR Functions
NPV and IRR are the core functions for evaluating investments, comparing projects, and making capital budgeting decisions.
Sum Values with Criteria
The SUMIF function allows you to sum values in one column based on criteria in another column, simplifying data analysis.
Count Text Values in Excel
Counting cells that contain specific words or partial text can be crucial for data analysis. This formula makes it easy!
Count Dates with Conditions
Counting data based on date ranges and conditions can be complex, but this formula simplifies the process effectively.
Average If Conditional
Struggling to find averages based on conditions? This guide shows you how to average values in one column based on non-blank criteria in another.
Handle VLOOKUP Errors Gracefully
VLOOKUP can often lead to errors when no match is found. Using IFERROR allows you to display a user-friendly message instead.
IF with Multiple Conditions
Managing multiple conditions in Excel can be challenging, but with the IF function, you can easily return different values based on your criteria.
Nested IF Statements for Grading
Assigning grades based on scores can be complex, but nested IF statements simplify this process in Excel.
XLOOKUP with Fallback Message
Discover how to effectively use XLOOKUP to retrieve values while providing a custom message for missing data, enhancing your Excel skills.
Reverse Lookup with XLOOKUP
Need to find values to the left of a lookup column? Use XLOOKUP for efficient reverse lookups in your Excel sheets.
Calculate Date Difference
Understanding the time span between two dates can be crucial for various tasks. The DATEDIF function simplifies this process.
Count Business Days Between Dates
Counting business days between two dates can be tricky, especially with holidays. Use the NETWORKDAYS function to simplify this task.
Add Months to Date
Need to adjust a date by three months while keeping the same day? This formula will help you do just that.
Last Day of Month Formula
Use the EOMONTH function to easily determine the last day of the current month or a future month by specifying the number of months to add.
Extract Characters from Text
Need to pull specific characters from a text string? This guide shows you how to extract the first three characters and characters five to eight using Excel formulas.
Format Numbers and Dates
Formatting numbers and dates in Excel can enhance data presentation. This guide shows you how to display numbers as currency and format dates effectively.
Clean Text and Remove Spaces
Extra spaces and non-printable characters can clutter your data. This formula helps you clean it up effectively.
Join First and Last Name
Combining first and last names into a single cell can streamline your data management. Use this formula to achieve that effortlessly.
Extract Unique Values
Struggling with duplicate entries in your data? Use the UNIQUE function to easily extract a list of unique values.
Filter Active Rows
Filtering data by specific criteria can streamline your analysis. Use dynamic arrays in Excel 365 to easily return only active rows.
Sort Lists Alphabetically
Sorting data in Excel can help you organize information effectively. Discover how to sort lists alphabetically or based on another column's order.
Generate Sequential Numbers
Creating a sequence of numbers or dates in Excel can simplify data entry and organization. This guide shows you how to do it easily.
Sum Product with Criteria
Discover a powerful method to calculate sums of products based on specific conditions without the complexity of array formulas.
Dynamic Range with OFFSET
Struggling with static ranges? Discover how to use OFFSET and COUNTA to create a dynamic range that adjusts as you add data.
Dynamic Cell Reference
Changing a cell value can dynamically alter your references to different sheets or ranges, streamlining your data management.
Choose Function for Lookup
The CHOOSE function allows you to return different values based on a specified index number, making it perfect for lookup tables.
Calculate Percentile Rank
Understanding where a score stands in a list can be crucial. This guide shows you how to calculate the rank and percentile of a value in Excel.
Calculate Loan Payments
Understanding your loan payments is crucial for financial planning. This formula helps you calculate the monthly payment based on loan amount, interest rate, and term.
NPV and IRR Calculation
Understanding the profitability of investments is crucial; this guide shows you how to calculate NPV and IRR using Excel formulas.
Count Non-Empty and Blank Cells
Counting cells accurately is crucial for data analysis. This guide shows you how to count non-empty, numeric, and blank cells in Excel.
Find 2nd and 3rd Largest Values
Struggling to extract specific values from your data? This guide shows you how to find the second and third largest values and the smallest non-zero value in Excel.
Check Cell Type with IF
Understanding cell content is crucial for data analysis. This guide shows you how to use IF with ISNUMBER, ISTEXT, and ISBLANK.
Find Value Position in List
Discover how to locate a value's position in a list and use it to retrieve data from a different column effortlessly.
Week Number and Day Name
Understanding the week number and day name for a date can help in scheduling and planning. This formula provides both in one go.
Add Business Days to Date
Need to find a future date while skipping weekends and holidays? This formula will help you calculate business days easily.
Find and Extract Text
Struggling to locate specific text within a cell? This guide will help you find and extract it seamlessly.
Replace Text in Excel
Easily replace all instances of a word and modify text at specific positions in your Excel sheets.
Text Case Conversion in Excel
Struggling with text formatting? Discover how to easily convert text to title case, uppercase, or lowercase using Excel formulas.
Round, Ceiling, and Floor
Master the techniques to round numbers effectively with Excel's powerful functions for precise calculations.
Calculate Remainder in Excel
The MOD function allows you to easily calculate the remainder of a division, helping you identify even and odd numbers or group records effectively.
Transpose Data Easily
Struggling to switch rows and columns in Excel? This guide shows you how to transpose data effortlessly without the hassle of copy-pasting.
Crosstab Summary with SUMIFS
Transform your sales data into a crosstab summary by leveraging the power of SUMIFS, eliminating the need for PivotTables.
Year Fraction Calculation
Understanding the fraction of a year between two dates is crucial in finance, and this formula simplifies that process using a 360-day calendar.
Filter Rows with QUERY
Struggling to filter data in Google Sheets? The QUERY function allows you to easily filter rows based on specific criteria, just like SQL.
Group By with QUERY
Grouping data by category and summing values is crucial for analysis. The QUERY function simplifies this process, similar to SQL's GROUP BY.
Sort and Limit QUERY Results
Sorting and limiting your data can help you focus on the most important information. This guide shows you how to achieve that using the QUERY function.
Using ARRAYFORMULA in Google Sheets
Tired of copying formulas down every row? ARRAYFORMULA automates this process, saving you time and effort.
Import and Filter Data
Easily pull data from different sheets and apply filters to focus on relevant information, streamlining your data analysis.
Validate Email Format
Ensuring that email addresses are correctly formatted is crucial for data integrity. Use REGEXMATCH to easily validate email formats in your spreadsheets.
Extract Digits from Text
Struggling to isolate numbers from a text string? Use REGEXEXTRACT to effortlessly pull out all digits from your data.
Split Full Name into First and Last
Struggling to separate names in your spreadsheet? This guide shows you how to efficiently split full names into first and last names using a simple formula.
Unique Sorted Values
Struggling with duplicates in your data? This formula will help you extract a clean, sorted list of unique values effortlessly.
Count Unique Values
Struggling to find the number of distinct entries in your data? This formula will help you count unique values effortlessly.
Create Sparkline Charts
Visualizing data trends can be challenging, but using the SPARKLINE function allows you to create compact charts directly within a cell.
Live Stock Prices in Google Sheets
Easily access live stock prices and historical market data directly in your Google Sheets with the GOOGLEFINANCE function.
Import HTML Tables and Lists
Struggling to get data from a webpage into your spreadsheet? The IMPORTHTML function makes it easy to pull in tables or lists directly.
Using XLOOKUP in Google Sheets
Struggling to find values in your data? XLOOKUP provides a powerful solution with fallback options for missing results.
Using LAMBDA for Custom Functions
Unlock the power of custom functions in Google Sheets by using LAMBDA to streamline your calculations and data processing.
Flatten Columns into List
Struggling to combine data from multiple columns? The FLATTEN function simplifies this by creating a single list from your selected range.
Convert Table to Column/Row
Transforming data from a 2D table into a single dimension can streamline your analysis. This formula helps you achieve that effortlessly.
Using CTEs for Clarity
CTEs allow you to break down complex SQL queries into named steps, enhancing readability and maintainability.
Using Subqueries in WHERE Clause
Discover how to efficiently filter your customer data by leveraging subqueries in the WHERE clause to identify high-value orders.
Categorize Revenue Tiers
Using SQL's CASE WHEN statement allows you to easily categorize revenue into defined tiers, enhancing data analysis and reporting.
Group Sales by Region
Grouping sales data by region allows for better analysis, and using HAVING helps filter results to meet specific criteria.
Row Number by Group
Using ROW_NUMBER() with PARTITION BY allows for effective ranking within groups, such as customers by date.
Rank Employees by Salary
Discover how to rank employees within their departments based on salary, while properly managing ties using RANK and DENSE_RANK functions.
Calculate Row Differences
The SQL LAG function allows you to access data from the previous row, making it easy to calculate differences in a time series.
Aggregate Sales by Month
Aggregating sales data by month can provide valuable insights. Use DATE_TRUNC to simplify timestamp data for monthly analysis.
Concatenate Column Values
String aggregation in SQL allows you to combine multiple row values into a single string. This guide will show you how to group and concatenate effectively.
Pivot Rows to Columns
Transform your SQL data by pivoting rows into columns using SUM and CASE WHEN, simplifying your data analysis.
Self Join on Employees
Using a self JOIN allows you to compare rows within the same table, making it easy to find employees in the same department.
Using EXISTS in SQL
Using EXISTS can enhance performance when querying for customers with at least one order. This method is often more efficient than using IN.
Recursive CTE for Hierarchies
Recursive Common Table Expressions (CTEs) allow you to efficiently traverse hierarchical data structures like organizational charts to retrieve all descendants of a specified node.
Extract JSON Field
Extracting specific fields from JSON columns can streamline data retrieval in SQL databases like PostgreSQL and MySQL. This guide will help you master the extraction process.
SQL Upsert Operations
Upsert operations allow you to insert a new row or update an existing one seamlessly, ensuring data integrity and efficiency.
Email Address Validation
Ensuring that email addresses are correctly formatted is crucial for data integrity. This regex pattern helps you validate email formats reliably.
US Phone Number Regex
Matching US phone numbers can be tricky due to various formats. This regex pattern simplifies the process by capturing multiple formats.
Extract URLs from Text
Extracting URLs from text can be challenging, but with the right regex pattern, you can easily find and list them all.
Match Date Formats
Matching dates can be tricky due to various formats. This regex pattern helps you capture MM/DD/YYYY, YYYY-MM-DD, and DD Month YYYY formats seamlessly.
Validate IPv4 Address
Validating an IPv4 address can be tricky, but using regex makes it straightforward by ensuring each octet is within the correct range.
Match US ZIP Codes
Understanding ZIP code formats is essential for data validation. This regex pattern helps you accurately identify both standard and extended ZIP codes.
Extract Names and Domain
Named capture groups simplify extracting specific data from strings, making it easier to retrieve first names, last names, and domains.
Understanding Regex Lookahead
Regex lookahead assertions allow you to match a word only when it is followed or not followed by a specific pattern, enhancing your text processing capabilities.
Match Whole Words with Regex
Using word boundary anchors in regex allows you to match complete words, ensuring no partial matches occur. This is essential for accurate text processing.
Using Backreferences in Regex
Backreferences allow you to refer to previously matched groups, making it easier to validate repeated patterns or matching tags.
Multiline Regex Patterns
Matching patterns that span multiple lines can be tricky, but using the right anchors can simplify the process significantly.
Extract HTML Content Non-Greedy
Using non-greedy matching in regex can help you accurately extract content between HTML tags without capturing too much data.
Calculate Percentage in Excel
Understanding how to calculate percentages can simplify your data analysis. This guide covers total percentages, changes, and increases.
Calculate Percentage Change
Understanding percentage change is crucial for analyzing data trends. This guide shows you how to calculate it easily in Excel.
Cumulative Running Total
A running total helps you keep track of cumulative sums in your data. This guide will show you how to set it up easily in Excel.
Year Over Year Growth
Understanding revenue growth is crucial for businesses, and this formula helps you calculate it accurately, even in tricky situations.
Check Cell for Text
Struggling to check if a cell contains certain text? Use the IF function combined with SEARCH to easily return desired values.
Extract Numbers from Text
Struggling to isolate numbers from a text string? This formula will help you extract only the numeric digits efficiently.
Highlight Duplicate Rows
Identifying duplicate entries in your data can streamline your analysis. Use this formula to easily flag duplicates in your list.
Check Date Within Range
Need to verify if a date lies within a specific range? This guide shows you how to use the IF function effectively.
VLOOKUP for Multiple Columns
Struggling to extract data from multiple columns? Discover how to efficiently use VLOOKUP or XLOOKUP for this task.
Index Match with Multiple Criteria
Combining multiple criteria in a lookup can be challenging, but using INDEX MATCH simplifies the process significantly.
Weighted Average Calculation
Weighted averages allow you to account for varying levels of importance in your data. Use the SUMPRODUCT function to easily compute this in Excel.
Reusable Custom Functions in Excel
Unlock the power of custom functions in Excel with LAMBDA, allowing for reusable and efficient calculations tailored to your needs.
Using the LET Function
The LET function allows you to name intermediate calculations, making your formulas cleaner and more efficient.
Using the AGGREGATE Function
The AGGREGATE function allows you to perform calculations while ignoring hidden rows and error values, making data analysis more efficient.
Break-Even Point Calculation
Understanding your break-even point is crucial for business success. This formula helps you determine when your revenues will cover your costs.
Calculate CAGR in Excel
Understanding CAGR is essential for evaluating investment growth over time. This guide will help you calculate it easily using Excel.
Standard Deviation in Excel
Understanding standard deviation is crucial for data analysis, and knowing when to use STDEV.S versus STDEV.P can enhance your insights.
Z-Score Normalization
Z-score normalization transforms your data to a standard scale, making it easier to compare values across different datasets.
Calculate Moving Averages
Moving averages help smooth out data fluctuations. This guide shows you how to calculate a rolling average using Excel formulas.
Days Until Deadline
Need to track deadlines? This formula helps you calculate the days remaining until a deadline, displaying 0 if the date has passed.
Concatenate with Separator
Easily combine values from different cells into one, using a specified separator while ignoring any empty cells.
Max and Min with Conditions
Discover how to efficiently find maximum or minimum values that meet specific criteria in your data sets using Excel functions.
Rank Values Without Ties
Tired of tied ranks in your data? Discover how to rank values uniquely from highest to lowest using a simple formula.
Dynamic Chart Data Range
Automatically update your chart as new data is added by using the OFFSET function or named ranges for flexibility and efficiency.
Convert Text to Date
Dates stored as text can cause issues in Excel. This guide shows you how to convert them into proper date values effortlessly.
Calculate Sales Commission
Understanding how to calculate tiered commissions can help sales teams maximize their earnings based on performance thresholds.
VLOOKUP for Tiered Pricing
Finding the right rate in tiered pricing can be challenging; VLOOKUP with approximate match simplifies this process.
Sum Values by Month
Struggling to get monthly totals from scattered dates? This formula will help you sum values by month effortlessly.
Dynamic Sheet Reference
Using the INDIRECT function, you can easily reference different worksheets by changing a cell value, making your formulas more flexible.
Fuzzy Match Lookup
Struggling with mismatched data? Use fuzzy matching techniques in Excel to accurately compare and match lists with slight variations.
Calculate Age from Birthdate
Finding a person's age from their birthdate can be easily done using the TODAY() function in Excel. This guide will show you how.
First and Last Day of Month
Easily determine the first and last days of any month from a given date using simple Excel formulas.
Count Words in Cell
Counting words in a cell can be tricky, but with a straightforward formula, you can easily determine the word count.
Extract Email Domain
Struggling to get the domain from email addresses? This formula will help you extract everything after the '@' symbol effortlessly.
Two-Way Lookup in Excel
Struggling to find values at the intersection of rows and columns? This guide will show you how to use Excel's powerful lookup functions.
Common Excel Formula Errors
Excel users often encounter formula errors that can disrupt their work. This guide helps you identify and resolve these issues effectively.
Dynamic Dropdown List
Struggling with static dropdown lists? Discover how to make your dropdowns dynamic so they update automatically with your data.
Compare Two Lists in Excel
Comparing two lists can be challenging, but with the right formula, you can easily identify unique and common items.
Salary Grade Assignment Formula
Assigning pay grades helps in standardizing employee compensation based on their salary. This formula simplifies the process of categorizing salaries into defined ranges.
Inventory Reorder Alert Formula
Ensure you never run out of stock by using a visual alert formula to flag items below their reorder points.
Profit Margin Calculation
Understanding profit margins is crucial for evaluating business performance. This guide will help you calculate gross profit margin, net profit margin, and markup percentage using simple Excel formulas.
Loan Amortization Schedule
Managing loan payments can be complex, but with an amortization schedule, you can easily track principal, interest, and remaining balances.
Last Occurrence Lookup
Struggling to find the last match of a value in a column? This formula will help you pinpoint the most recent occurrence efficiently.
Conditional Formatting in Excel
Conditional formatting allows you to visually highlight important data by changing cell colors based on specific criteria, enhancing data analysis.
Linear Forecasting in Excel
Need to forecast future data points? The FORECAST.LINEAR function can help you extend a linear trend from your historical data.
Count Unique Values by Category
Counting unique values within categories can enhance your data analysis. Use COUNTIFS or SUMPRODUCT to achieve this efficiently.
Check for Numbers in Text
Finding out if a text string includes numeric digits can be crucial for data validation. This formula helps you determine that easily.
Query Select with Where
The QUERY function allows you to perform SQL-like operations in Google Sheets, making data manipulation easier and more intuitive.
Group and Pivot Data
Transform your data analysis by using QUERY to group totals by category and pivot to display them in a more insightful format.
Import and Filter Data
Easily combine data from different sheets while applying filters to streamline your analysis and reporting.
Apply IF with ARRAYFORMULA
Tired of dragging formulas down a column? Discover how to apply an IF formula to an entire column at once using ARRAYFORMULA for faster calculations.
SUMIF with ARRAYFORMULA
This guide shows you how to apply SUMIF across multiple rows simultaneously, ensuring your calculations adjust as data changes.
Extract Domain from URLs
Struggling to isolate domains from a list of URLs or email addresses? Use REGEXEXTRACT to simplify your data extraction process.
Clean Non-Numeric Characters
Struggling with unwanted symbols in your data? Use REGEXREPLACE to easily clean your text cells and retain only numeric values.
Split Text to Columns
Struggling with text in a single cell? Use the SPLIT function to separate it into multiple columns effortlessly.
Sum Across Sheets
Easily aggregate data from different tabs in Google Sheets using IMPORTRANGE and QUERY functions to streamline your reporting.
Conditional Sum by Date
Summing values based on specific date ranges can be challenging, but this formula simplifies the process for current month, last 30 days, or specific quarters.
Using XLOOKUP in Sheets
XLOOKUP simplifies data retrieval in Google Sheets, making it easier to replace the older VLOOKUP function with enhanced capabilities.
Live Stock Prices in Sheets
Easily track stock prices and financial metrics directly in your Google Sheets with the GOOGLEFINANCE function, streamlining your investment analysis.
Create Sparkline Charts
Sparkline charts provide a quick visual representation of data trends directly within a cell. This guide shows you how to customize them effectively.
Using Named Ranges
Named ranges simplify your formulas, making them easier to read and maintain, especially in large spreadsheets.
Sort Unique Values
Struggling with duplicate values? This guide shows you how to dynamically sort and list unique entries from a column in Google Sheets.
Count Cells with Specific Text
Struggling to count occurrences of a word or phrase in your data? Use the COUNTIF function with wildcards to easily achieve this.
Handle IMPORTRANGE Errors
When using IMPORTRANGE, loading errors can disrupt your workflow. Wrapping it in IFERROR allows you to show a custom message while data loads.
Automatic Language Translation
Struggling with language barriers in your data? Use the GOOGLETRANSLATE function to convert text from one language to another effortlessly.
Using Checkboxes in Formulas
Checkboxes in Google Sheets can simplify task management by allowing you to count, sum, or trigger actions based on TRUE/FALSE values.
XLOOKUP Exact Match
Struggling to find exact matches in your data? XLOOKUP simplifies this process and allows for custom messages when values aren't found.
XLOOKUP with Wildcards
Discover how to perform partial text matching using XLOOKUP with wildcard characters, streamlining your data searches.
XLOOKUP vs VLOOKUP Comparison
XLOOKUP offers enhanced functionality over VLOOKUP, making it easier to retrieve data. Here, we show you how to convert VLOOKUP formulas to XLOOKUP.
Find Last Match with XLOOKUP
Discover how to efficiently retrieve the most recent entry of a value in a dataset using XLOOKUP's reverse search feature.
XLOOKUP Across Rows
Struggling to find values across rows? XLOOKUP can help you search horizontally and return the desired results seamlessly.
Understanding SQL Joins
SQL joins allow you to combine rows from two or more tables based on a related column. Understanding each type of join helps in retrieving the right data.
Using LIKE and ILIKE in SQL
Discover how to effectively filter your SQL queries for partial text matches with LIKE and ILIKE for case-insensitivity.
Count Unique Values in SQL
Counting unique values in a column is essential for data analysis. Use COUNT(DISTINCT column_name) to easily achieve this.
Handling NULL Values in SQL
NULL values can complicate SQL queries, but using IS NULL, IS NOT NULL, COALESCE, and NULLIF can help manage them effectively.
Update Rows with JOIN
Updating specific rows in a table can be tricky, especially when you need to reference another table. This guide shows you how to do it effectively.
Insert Select SQL Statement
Inserting data from one table to another can streamline data management and enhance efficiency. This guide explains how to use the INSERT INTO ... SELECT statement.
Calculate Running Total
Running totals help analyze cumulative data over time, and SQL provides a powerful way to compute them using window functions.
Percentage of Total Calculation
Understanding how to express each row's value as a percentage of the total can simplify data analysis. This guide shows you how to achieve this using window functions.
7-Day Rolling Average
Rolling averages help smooth out data trends over time. This guide shows you how to compute a 7-day moving average using SQL.
Deduplicate Rows in SQL
Duplicate rows can clutter your data and lead to inaccurate analysis. This guide shows you how to effectively remove them using SQL.
Conditional Aggregation in SQL
Conditional aggregation allows you to compute sums based on specific criteria, enabling detailed insights from your data in a single query.
SQL String Functions Overview
Text manipulation is crucial for data accuracy; this guide covers essential SQL functions to clean and format your strings effectively.
Working with Dates in SQL
Understanding date functions in SQL is crucial for effective data analysis, allowing you to extract, calculate, and manipulate date values seamlessly.
First and Last in Group
Discover how to efficiently extract the first and last records for each group in your SQL data, enhancing your data analysis capabilities.
Count Unique Values in Excel
Counting unique values in a column can be tricky, but this formula will help you exclude duplicates and blanks effortlessly.
Last Value in Column
If you're dealing with a column that keeps getting new data, this formula helps you quickly find the last non-empty entry.
VLOOKUP with ARRAYFORMULA
Automatically apply VLOOKUP to an entire column so that results update as new rows are added, saving you time and effort.
Can't find what you need?
Describe any formula in plain English and Formula Genius will generate it, explain it, and validate it — instantly.