# Are you stuck on Excel or Google Sheets?

Check out our self-help content, created by our top Experts!

#### AND

#### AVERAGE

- Average Growth Rate
- Moving Average
- Ignore Zeros
- How To
- Average top 3 scores
- Weighted average
- Average response time per month
- Average and ignore errors
- Average number
- Average last 5 values in columns

#### AVERAGEIF

#### CELL REFERENCE

#### COLUMNS

#### CONDITIONAL FORMATTING

- How to Use
- Row
- IF
- Greater Than
- Copy
- Color
- Apply Conditional Formatting to Blank Cells
- Based on
- Text
- Copy Text
- Formula
- Google Sheets
- How to Use
- SUMIFS in Google Sheets
- Remove file extension from filename
- Highlight top values
- Lookup entire row
- Highlight values between
- Highlight multiples of specific value
- Highlight dates in the next N days
- Highlight cells that equal
- Highlight 3 smallest values with criteria
- Highlight every other row
- Highlight dates that are weekends
- Highlight rows with blank cells
- Highlight row and column intersection exact match
- Highlight cells that begin with
- Highlight cells that end with
- Conditional formatting highlight target percentage
- Shade alternating groups of n rows
- DECIMAL
- Select all precedents
- Select all dependents
- Undo last action
- Conditional formatting dates overlap
- Highlight dates between
- Highlight duplicate values
- Highlight duplicate columns
- Find duplicate values in two columns
- Conditional formatting based on another cell
- Highlight approximate match lookup conditional formatting
- Most frequently occurring text
- Normalize text
- Excel SUMPRODUCT Function

#### COUNT

- Function
- How to Count Non Blank or Non Empty Cells in Excel
- Blank/Empty
- Colored/Highlighted
- Google Sheets
- Duplicates
- Unique/Distinct Values
- count words in Excel
- Characters
- Text
- Summary count of non-blank categories
- Count cells that are blank
- Count cells not equal to a specified value
- Count cells that contain either a or b
- Count cells that contain specific text
- Count cells that do not contain
- Count cells that begin with
- Basic timesheet formula with breaks
- Count dates by day of week
- Count cells between dates
- Count cells greater than
- Count cells that are not blank
- Count cells that contain text
- Summary count with COUNTIF
- Count matches between two columns
- Count cells that contain errors
- Count cells not equal to many things
- Count sold and remaining
- Count cells over 100 characters
- Count cells that end with
- Count unique values in a range with COUNTIF
- Count rows that contain specific values
- Count items in list
- Count occurrences in entire workbook
- Count numbers by range with COUNTIFS
- Count cells between two numbers
- Count cells that contain odd numbers
- Count long numbers without COUNTIF
- Count cells that contain numbers
- Summary count with percentage breakdown
- Count if row meets multiple internal criteria
- Count cells that contain five characters
- Count visible rows only with criteria
- Count unique numeric values with criteria
- Count unique text values in a range
- Count cells that contain negative numbers
- Count cells that do not contain errors
- Running count of occurrence in list
- Two-way summary count with COUNTIFS
- Count cells equal to
- Count numbers third digit equals 3

#### COUNTA

#### COUNTIF

- Formula
- Between Two Values
- Multiple Criteria
- Non-Blank
- COUNTIF in Google Sheets
- Greater Than
- Countif Function / How to Use testing

#### COUNTIFS

#### CUMIPMT

#### DATA ENTRY

#### DATA VALIDATION

- How to allow numbers only
- How to allow uppercase text only
- How to allow weekday dates only
- Check for specific text
- How to allow text only
- How to allow dates from a certain year only
- How to only allow dates in the next 30 days
- How to only allow values that don't exceed a set sum
- Data validation must begin with
- Data validation unique values only
- Data validation must contain specific text
- Data validation date in next 30 days
- Data validation date in specific year
- Data validation exists in list
- Data validation allow numbers only
- Data validation must not contain
- Data validation allow weekday only
- Data validation allow text only

#### DATABASE

#### DATE AND TIME

- Get days between dates
- How to only allow values that don't exceed a set sum
- Dynamic date list
- Pad week numbers with zeros
- Sum race time splits
- DATE
- Next working day
- Next business day 6 months in future
- Get first Monday before any date
- Get first day of previous month
- Display the current date and time
- Year is a leap year
- Next anniversary date
- Next biweekly payday from date
- Convert date to text
- List holidays between two dates
- Working days left in month
- Get year from date
- Get workdays between dates
- If Monday, roll back to Friday
- Last updated date stamp
- Join date and text
- Get months between dates
- Get week number from date
- TIMEVALUE
- Get work hours between dates
- DAYS360
- Get month name from date
- Get same date next year
- Get same date next month
- Dynamic calendar grid
- Calculate expiration date
- Get first day of month
- Get days before a date
- Get days between dates ignoring years
- Get age from birthday
- Get nth day of week in month
- EDATE
- Get most recent day of week
- Display the current date
- Extract date from a date and time
- Sum time over 30 minutes
- Workdays per month
- DATEVALUE
- Add decimal hours to time
- Add days to date
- Get last day of month
- EOMONTH
- Get fiscal year from date
- Get days, months, and years between dates
- Count times in a specific range
- Convert Excel time to decimal minutes
- Convert Excel time to decimal hours
- Get day name from date
- MINUTE
- SECOND
- Get date from day number
- Extract time from a date and time
- Assign points based on late time
- Add workdays to date custom weekends
- NOW
- DATEDIF
- Convert text to date
- Get next day of week
- Add months to date
- Calculate number of hours between two times
- Get next day of week
- WORKDAY
- Get month from date
- Get day from date
- DAY
- Convert decimal seconds to Excel time
- Excel WEEKDAY Function
- TIME
- Custom weekday abbreviation
- YEAR
- Convert date to month and year
- Excel YEARFRAC Function
- Date is workday
- Basic overtime calculation formula
- Date is same month and year
- Days in month
- Create date range from two dates
- Count holidays between two dates
- Convert date to Julian format
- NETWORKDAYS.INTL
- Calculate years between dates
- Calculate days remaining
- Get last weekday in month
- Calculate date overlap in days
- Add workdays no weekends
- WEEKNUM
- How to calculate a retirement date
- Count day of week between dates
- Count dates in current month
- WORKDAY.INTL
- Get quarter from date
- Get percent of year complete
- Get project end date
- Get project midpoint
- Get project start date
- Date is same month

#### DATE SERIES

#### ENGINEERING

#### FINANCIAL

- Calculate interest for given period
- Calculate simple interest
- PPMT
- Calculate payment for a loan
- Calculate interest rate for loan
- CUMPRINC
- Calculate original loan amount
- Financial
- Annual compound interest schedule
- Microsoft Excel IRR function
- FV
- Calculate cumulative loan interest
- Calculate cumulative loan interest
- Calculate principal for given period
- NPV
- PV
- XIRR
- Calculate cumulative loan principal payments
- NPER
- RATE

#### FIND

#### GENERAL

#### GRID OPERATIONS

#### GROUPING

- Map text to numbers
- Group times into 3 hour buckets
- Group arbitrary text values
- Group numbers at uneven intervals
- Group numbers with VLOOKUP

#### IF

- How to
- IF AND
- Nested IF statements
- Blank / Not Blank
- IF OR
- IFERROR Function in Excel
- If this AND that OR that
- Tax rate calculation with fixed base
- Force negative numbers to zero
- If cell contains this or that
- Nested IF function example
- If else
- If this AND that OR that
- If cell is greater than
- If cell is x or y and z
- If cell is this OR that
- If this AND that
- If cell equals
- If a cell is not blank
- If cell contains

#### INDEX

#### INDEX MATCH

#### INFORMATION

#### INTERNET

- Remove trailing slash from url
- Create email address from name
- Get top level domain (TLD)
- Strip protocol and trailing slash from URL
- Get page from URL

#### LEN

#### LOGICAL

#### LOOKUP

- How to Find the First Match in a Range with a Wildcard
- Lookup and retrieve an entire column
- Get location of value in 2D array
- Max if criteria match
- Partial match against numbers with wildcard
- Self-contained VLOOKUP
- Sum range with INDEX
- Exact match lookup with SUMPRODUCT
- Get first non-blank value in a list
- Get first text value with HLOOKUP
- Two-way lookup with VLOOKUP
- VLOOKUP without #N/A error
- Calculate grades with VLOOKUP
- Position of first partial match
- Calculate grades with VLOOKUP
- Extract all partial matches
- Two-way lookup with INDEX and MATCH
- VLOOKUP with 2 lookup tables
- Lookup lowest value
- Basic INDEX MATCH approximate
- Basic INDEX MATCH exact
- Match next highest value
- Find missing values
- Break ties with helper column and COUNTIF
- Next largest match with the MATCH function
- Match first error
- Find the position of the max value in a list
- Join tables with INDEX and MATCH
- Lookup last file version
- Partial match with VLOOKUP
- Get information corresponding to max value
- Dynamic lookup table with INDIRECT
- VLOOKUP with numbers and text
- Get nth match
- Basic Tax Rate calculation with VLOOKUP
- Count missing values
- Approximate match with multiple criteria
- Find longest string in column
- INDEX and MATCH with multiple criteria

#### Lookup and reference

- LOOKUP
- OFFSET
- INDIRECT
- ROW
- COLUMNS
- How to use the Excel CHOOSE function
- HLOOKUP
- INDEX
- TRANSPOSE
- MATCH
- ADDRESS
- COLUMN
- ROWS
- Excel HYPERLINK Function

#### MATCH

#### MATH

- SUM
- SUMPRODUCT
- TAN
- GCD
- ABS
- Excel LOG Function
- SUMIFS
- EVEN
- SIGN
- RAND
- COS
- EXP
- SIN
- QUOTIENT
- LN
- SUMIF
- RANDBETWEEN
- ROMAN
- ROMAN
- ARABIC
- DECIMAL
- MOD
- POWER
- FLOOR
- LOG10
- SQRT
- MROUND
- ODD
- RADIANS
- SUBTOTAL

#### MIN AND MAX

- Smaller of two values
- Large with criteria
- Larger of two values
- Maximum value
- nth smallest value with criteria
- Max value ignore all errors
- Minimum value if
- Minimum if multiple criteria
- Maximum if multiple criteria
- nth smallest value
- nth largest value with criteria
- Minimum value
- nth largest value
- nth largest value with duplicates

#### Miscellaneous

- Value is within tolerance
- Validate input with check mark
- Value is between two numbers
- Course completion summary with criteria
- Course completion status summary
- Transpose table without zeros
- Sum text values like numbers
- Copy value from every nth row
- Sum every 3 cells
- Square root of number
- Split payment across months
- Sort text and numbers with formula
- Sort numbers ascending or descending
- Pad a number with zeros
- nth root of number
- Convert column number to letter
- Reverse a list or range
- Random sort formula
- Return array with INDEX function
- Range contains one of many substrings
- Range contains one of many values
- Basic text sort formula
- Student class enrollment with table
- Search entire worksheet for value
- Risk Matrix Example
- Range contains specific text
- Excel formula: One or the other not both
- How to Search Multiple Worksheets for Value
- Simple currency conversion
- Check register balance
- Build hyperlink with VLOOKUP
- Fixed value every N months
- Calculate a ratio from two numbers
- List most frequently occuring numbers
- Multiplication table formula
- Normalize size units to Gigabytes
- Abbreviate state names
- List contains duplicates
- Basic numeric sort formula
- Get value of last non-empty cell
- Hyperlink to first match
- Flip table rows to columns
- Conditional mode with criteria
- Get first entry by month and year
- Get pivot table subtotal grouped date
- Cube root of number
- Get date associated with last entry
- Get last entry by month and year
- Display sorted values with helper column
- Filter values in array formula
- Change negative numbers to positive
- Leave a comment in a formula
- Create array of numbers
- Most frequently occurring number
- Flag first duplicate in a list
- Get last entry by month and year
- Issue response time calculation

#### MOD

#### NAMES

- Join first and last name
- Get last name from name
- Get first name from name
- Put names into proper case
- Get first name from name with comma
- Get middle name from full name

#### OTHER

#### PERCENTAGE

- Project complete percentage
- Get original price from percentage discount
- Percent of goal in Excel
- Get profit margin percentage
- Percent sold
- Get total from percentage
- Decrease by percentage
- Get amount with percentage
- Calculate percent variance

#### PIVOT TABLE

- Calculated Fields
- Sort
- Transpose Data
- Conditional Formatting
- Percentage
- Distinct
- Google Sheets
- Refresh/Update
- How to Create/Make
- Calculated Field
- Indirect named range different sheet
- Get domain name from URL
- VLOOKUP from another sheet
- Sum if cells contain specific text

#### RANDOM

- Random times at specific intervals
- Random value from list or table
- Random number weighted probability
- Random text values
- Random number from fixed set of options
- Random number between two numbers
- Randomly assign people to groups

#### RANGE

- All values in a range are at least
- All values in a range are at least
- Get relative column numbers in range
- Total cells in a range
- Range contains a value not in another range
- Last row in mixed data with blanks
- Range contains numbers
- First match between two ranges
- Last row in mixed data with no blanks
- Last row in text data
- Last row number in range
- All cells in range are blank

#### RANK

- How to use rank function
- How to RANK from lowest to highest
- How to RANK using COUNTIFS
- How to use RANK with suffix
- Rank with criteria
- Rank function example
- Rank with ordinal suffix

#### ROUND

- Round to nearest 1000
- Round a number up
- Excel ROUNDUP function
- Round a number
- Round a number down to nearest multiple
- Round a price to end in .99
- Round a number to nearest multiple
- Get integer part of a number
- Get number at place value
- ROUND
- Round a number down

#### ROW

#### SELECT SPECIAL

#### STATISTICAL

- QUARTILE.EXC
- QUARTILE.INC
- VARPA
- VARA
- VARP
- VAR.S
- VAR.P
- VAR
- TRIMMEAN
- STDEVPA
- STDEVP
- STDEVA
- STDEV.S
- STDEV
- STDEV.P
- AVERAGE
- LARGE
- PERCENTILE.EXC
- PERCENTRANK
- COUNTBLANK
- AVEDEV
- COUNTIF
- COUNTA
- COUNT
- DEVSQ
- MINA
- AVERAGEIF
- FREQUENCY
- AVERAGEIFS
- MODE.MULT
- MEDIAN
- GEOMEAN
- PERCENTILE
- QUARTILE
- MIN
- Excel MODE Function
- PERMUT
- PERCENTILE.INC
- MAX
- PERCENTRANK.EXC

#### SUM

- How to
- Autosum in Excel
- 3D sum multiple worksheets
- Sum last n columns
- Sum if multiple criteria
- Sum sales in last 30 days by ID
- Sum by week number
- Sum if equal to one of many things
- Sum bottom n values with criteria
- Sum if cell contains text in another cell
- Sum if cells are equal to
- Sum entire column
- Sum if by year
- Sum if not blank
- Sum if greater than
- Subtotal by color
- Sum every nth column
- Sum by group
- Sum if ends with
- Sum columns based on adjacent criteria
- Sum if begins with
- Sum if cells contain both x and y
- Sum if one criteria multiple columns
- Sum visible rows in a filtered list
- Sum if equal to either x or y
- Sum by weekday
- Sum by week
- Sum if between
- Sum top n values with criteria
- Sum if cells contain an asterisk
- Subtotal invoices by age
- Sum every n rows

#### SUMIF

- Google Sheets
- Multiple Criteria
- Blank / Not Blank
- How to Use SUMIF to Sum Values Between Two Dates
- Sum visible rows in a filtered list

#### TABLES

- Count table columns
- Basic inventory formula example
- Dynamic reference Table name
- Two-way lookup VLOOKUP in a Table
- Get column index in Excel Table

#### TEXT

- Join text together
- TEXTJOIN
- UPPER
- VALUE
- Replace one character with another
- CHAR
- Remove unwanted characters
- Remove characters from right
- Remove text by variable position
- Remove leading and trailing spaces from text
- Remove text by position
- Remove text by matching
- Remove line breaks
- Remove file extension from filename
- Split text string at specific character
- Split text and numbers in Excel
- Cell equals one of many things
- REPLACE
- LEFT
- Strip non-numeric characters
- Split dimensions into two parts
- Count keywords cell contains
- RIGHT
- CODE
- Count total words in a cell
- Cell contains number
- MID
- TRIM
- Add a line break with a formula
- Cell contains all of many things
- Clean and reformat telephone numbers
- Excel PROPER Function
- Double quotes inside a formula
- Excel REPT Function
- Count specific words in a range
- EXACT
- Count specific words in a cell
- Remove characters from left side of a cell
- LOWER
- Count specific characters in a range
- Excel REPT Function
- Count total characters in a range
- Cell contains some words but not others
- DOLLAR
- Count line breaks in cell
- Count total words in a range

#### VLOOKUP

- Calculation
- Formula
- Compare
- Conditional Formatting
- Error
- Multiple Columns
- Multiple Sheets
- Check
- How to
- Google Sheets VLOOKUP function
- Not Working
- INDEX MATCH versus VLOOKUP
- IF
- Multiple Workbooks
- Fuzzy Lookup
- Random date between two dates
- VLOOKUP with two client rates
- Lookup value between two numbers
- Get nth match with VLOOKUP
- VLOOKUP from another workbook
- VLOOKUP by date
- Get address of lookup result
- Calculate shipping cost with VLOOKUP
- Lookup up cost for product or service