Excel Tips: Calculation & Formulas > Formula Examples

File
How to open containing folder of current workbook in Microsoft Excel?	LEFT FIND CELL
How to display / show negative time properly in Excel?	TEXT MIN
How to create a dynamic print area in Excel?	OFFSET COUNTA
How to print long column on one page in Excel?	IF OFFSET COLUMN ROW
How to remove (temporarily hide) conditional formatting when printing in Excel?	AND
How to create a time sheet template in Excel?	IF
How to create billable hours template in Excel?	IF SUM SUMIF
How to create loan amortization interest calculator of Excel template?	PMT IF
How to create Value at Risk template in Excel?	NORM.INV SQRT
How to make a monthly budget template in Excel?	SUM IF
How to display blank if sum is zero in Excel?	IF SUM
Insert
Insert > Bullets & numbering
How to add unique id number column for duplicate rows in Excel?	IF
How to auto number a column based on cell value on another column in Excel?	IF COUNTIF
How to auto number a column in Excel?	ROW OFFSET
How to autonumber rows if adjacent cell not blank in Excel?	IF COUNTA
How to insert bullet points into cells of Google sheet?	CHAR
How to number rows after inserting or deleting rows automatically in Excel?	ROW
How to numbering every other row in Excel?	IF ISEVEN ROW ISNUMBER OFFSET MAX
Insert > Chart
How to make a cumulative sum chart in Excel?	SUM
How to add a scrollbar to chart in Excel?	OFFSET
How to add vertical/AVERAGE line to bar chart in Excel?	AVERAGE
How to change chart axis's min/max value with formula in Excel?	ROUNDUP ROUNDDOWN MAX MIN
How to create a bar chart from yes no cells in Excel?	COUNTIF COUNTA
How to create a chart with conditional formatting in Excel?	IF
How to create a control chart in Excel?	AVERAGE STDEV.S STDEV
How to create a pie chart for YES/NO answers in Excel?	COUNTIF
How to create burn down or burn up chart in Excel?	SUM
How to create dot plot in Excel?	ROW ROWS
How to create population pyraMID chart in Excel?	SUM
How to create timeline (milestone) chart template in Excel?	DATE OFFSET ROW
How to create waterfall chart in Excel?	SUM MIN MAX
How to highlight max and min data points in a chart?	IF OR MAX MIN NA
How to insert in-cell bar chart in Excel?	REPT
How to wrap X axis labels in a chart in Excel?	CHAR
Insert > Illustrations
How to insert an image in cell within a google sheet?	IMAGE
How to insert image or picture dynamically in cell based on cell value in Excel?	INDIRECT ADDRESS MATCH
Insert > Links
How to convert a bunch of text URLs to active hyperlinks in Excel?	HYPERLINK
How to convert file path to hyperlink in Excel?	HYPERLINK
How to convert multiple email addresses to hyperlinks in Excel?	HYPERLINK
How to create dynamic hyperlink to another sheet in Excel?	HYPERLINK
How to quickly create a hyperlink to specific worksheet in another workbook?	HYPERLINK
Insert > List
How to list / generate all possible combinations in Excel?	IF ROW COUNTA INDEX INT MOD
How to create a dynamic list of worksheet names in Excel?	SUBSTITUTE GET.WORKBOOK INDEX ROWS
How to create a dynamic list without blank in Excel?	IF MAX IFERROR INDEX MATCH ROW OFFSET
How to create a unique alphabetically sorted list from a column in Excel?	INDEX MATCH COUNTIF SUM
How to create alphabetical series list in Excel?	CHAR
How to create scrollable list / area in worksheet?	OFFSET
How to generate a list of all possible 4 digits combinations in Excel?	TEXT ROW
How to generate all prime numbers between two given numbers in Excel?	ROW INDIRECT SMALL IF MMULT TRANSPOSE IFERROR
How to generate all prime numbers between two given numbers in Excel?	RAND RANK COUNTIF VLOOKUP
How to generate unique combinations in Excel?	MOD ROW INT INDEX
How to list all dates between two dates in Excel?	IF ROW
How to list all days as date in a specified month in Excel?	IF MONTH
How to list all matched instances of a value in Excel?	INDEX SMALL ROW
How to list all Mondays / Fridays in a month in Excel?	IF WEEKDAY EOMONTH
Insert > PivotTable & PivotChart
How to group a pivot table by day of week in Excel?	TEXT
How to group by fiscal year in an Excel pivot table?	YEAR MONTH
How to group by week in pivot table?	YEAR TEXT WEEKNUM
How to group data by half an hour or 15 minutes in Excel PivotTable?	MOD INT FLOOR TIME
How to group time by minutes or hours intervals in Excel?	FLOOR TIME
Insert > Others
How to create a dynamic monthly calendar in Excel?	DATE
How to create increment number with or inside text in Excel?	TEXT
How to create your own search box in Excel?	ISNUMBER SEARCH IFERROR SEARCH ROW RANK VLOOKUP

Edit
Edit > Change cell content
How to add text to the beginning or end of all cells in Excel?	CONCATENATE
How To Add or Pad Leading Zeros To Numbers or text In Excel?	TEXT CONCATENATE
How to add prefix or suffix to range of cells in Excel?	CONCATENATE
How to flip the first and last name in cells in Excel?	MID FIND LEN
How to change uppercase to lowercase in Microsoft Excel?	LOWER UPPER PROPER
How to change uppercase to proper or title case in Microsoft Excel?	PROPER
How to capitalize first letter only or first letter of each word in Excel?	PROPER UPPER LEFT LOWER RIGHT LEN CHAR
How to add a character before each word in a cell in Excel?	SUBSTITUTE
How to add comma after first word in each cell?	REPLACE SUBSTITUTE LEFT FIND MID
How to add comma before number in Excel?	MATCH ISNUMBER ROW INDIRECT REPLACE MID
How to add leading zero to fixed number length in Excel?	TEXT FIXED INT LOG ABS
How To Add or Pad Leading Zeros To Numbers or text In Excel?	TEXT CONCATENATE
How to add prefix or suffix into cell values in Google sheets?	ARRAYFORMULA
How to add quotes around numbers or text in Excel?	CHAR
How to add spaces after commas in Excel?	TRIM SUBSTITUTE
How to add spaces between numbers in cells?	TEXT
How to add text in middle of selected cells in Excel?	LEFT MID REPLACE
How to add the same email address to a list of names in Excel?	CONCATENATE
How to add trailing spaces to text in Excel?	LEFT REPT
How to add trailing zeroes to column of numbers in Excel?	REPT LEN
How to capitalize all letters in cell or a column in Excel?	UPPER
How to change all caps to lowercase except first letter in Excel?	PROPER UPPER LEFT LOWER RIGHT LEN
How to change case of text in Excel?	LOWER UPPER PROPER
How to change case to UPPER/lower/Proper in Google Sheet?	LOWER UPPER PROPER
How to convert all caps to only first cap in selected range in Excel?	PROPER
How to convert lowercase to proper or sentence case in Excel?	PROPER SUBSTITUTE LOWER CHAR CODE UPPER LEFT MID
How to convert text string to PROPER case with exceptions in Excel?	UPPER LEFT MID TRIM SUBSTITUTE LEN
How to easily and quickly move first word to end in Excel?	RIGHT LEN FIND LEFT
How to enclose all cells in quotes or insert quotes around text in Excel?	CHAR
How to force text string to uppercase / lowercase / proper case in Excel?	EXACT UPPER LOWER PROPER
How to insert colon between numbers to make them as time format automatically in Excel?	TIME LEFT LEN RIGHT INT MOD
How to insert space between number and text in cells in Excel?	TRIM REPLACE MIN FIND
How to make an entire column capital (uppercase) or lowercase in Excel?	UPPER LOWER
How to plus text to cell value in Excel?	CONCATENATE
How to quickly add comma between words in Excel?	SUBSTITUTE TRIM
How to quickly add dashes to multiple phone numbers in Excel?	REPLACE TEXT
How to quickly add dashes to ssn in Excel?	TEXT LEFT MID RIGHT
How to quickly convert/change text to upper cases in Microsoft Excel?	UPPER
How to rearrange text in a cell in Excel?	TRIM MID SEARCH LEFT
How to repeat a character n times in a cell in Excel?	REPT
How to reverse text strings within cells in Google sheet?	JOIN ARRAYFORMULA MID LEN ROW INDIRECT
How to reverse the first name and last name within cells in Google sheet?	MID FIND LEN
How to swap or switch text around within one cell in Excel?	RIGHT LEN FIND LEFT
Edit > Combine
Merge and Combine Columns without Losing Data in Excel	CONCATENATE
How to combine date and time into one cell in Excel?	TEXT
How to quickly combine the first and last names in one cell in Excel?	CONCATENATE
How to merge and combine rows without losing data in Excel?	CONCATENATE TRANSPOSE
How to convert column list to comma separated list in Excel?	CONCATENATE TRANSPOSE
How to concatenate keeping number/date formatting in Excel?	CONCATENATE TEXT
How to add words/texts from different cells together in Excel?	CONCATENATE
How to append or adding text from one cell to another cell in Excel?	CONCATENATE
How to combine / merge multiple sheets into one sheet in Google sheet?	FILTER LEN
How to combine cells and keep the cell formatting in Excel?	TEXT
How to combine cells with line break / carriage return in Excel?	CONCATENATE CHAR
How to combine date and time columns into one column in Google sheets?	CONCATENATE TEXT
How to combine multiple cells with leading zeros into a cell in Excel?	CONCATENATE
How to combine multiple columns into one single column in Google sheet?	FILTER LEN
How to combine multiple rows to one cell in Excel?	CONCATENATE TRANSPOSE
How to combine the first initial and last name into one cell in Excel?	CONCATENATE LEFT
How to combine three cells to create date in Excel?	DATE
How to concatenate cells and add space between words in Excel?	CONCATENATE
How to concatenate cells from another sheet/different sheets in Excel?	CONCATENATE
How to concatenate cells if same value exists in another column in Excel?	IF
How to concatenate cells ignore or skip blanks in Excel?	IF
How to concatenate columns with Alt + Enter in Excel?	CHAR
How to concatenate first letters of names/cells in Excel?	CONCATENATE LEFT
How to concatenate letter and number into one cell in Excel?	CONCATENATE
How to concatenate multiple cells with line break in Google sheet?	ARRAYFORMULA CONCATENATE CHAR
How to concatenate range with adding/including quotation marks in Excel?	CONCATENATE CHAR
How to concatenate range/cells with comma, space, line break in Excel?	CONCATENATE TRANSPOSE
How to concatenate rows into one cell based on group in Excel?	IF
How to easily concatenate text based on criteria in Excel?	IFERROR INDEX MATCH COUNTIF
How to join text from different cells into one cell in Excel?	CONCATENATE
How to merge columns but not merging rows in Excel?	CONCATENATE
How to merge every other row/cell in Excel?	OFFSET ROW
How to merge two tables by matching a column in Excel?	IFERROR VLOOKUP COLUMN
How to quickly combine text and date into same cell in Excel?	CONCATENATE TEXT
How to quickly condense rows based on same value in Excel?	INDEX MATCH COUNTIF SUMIF
How to quickly transpose group of rows to column in Excel?	IFERROR INDEX MATCH COUNTIF SMALL ROW MIN
How to reverse the text to column function in Excel?	CONCATENATE
Edit > Convert
How to change or convert number to text in Excel?	TEXT
How to convert month name to number in Excel?	MONTH DATEVALUE TEXT
How to convert formula to text string in Excel?	CONCATENATE
How to convert scientific notation to text or number in Excel?	TRIM UPPER
How to change negative number to zero in Excel?	IF
How to convert week number to date or vice versa in Excel?	MAX DATE WEEKDAY MIN WEEKNUM
How to convert letter to number or vice versa in Excel?	COLUMN INDIRECT MID
How to convert between hours, minutes, seconds or days in Excel?	CONVERT
How to calculate currency conversion in Google Sheet?	GOOGLEFINANCE
How to convert 1-12 to month name in Excel?	TEXT
How to convert angle between degrees and radians in Excel?	RADIANS DEGREES MINUTE SECOND
How to convert between roman number and Arabic number in Excel?	ROMAN MATCH INDEX ROW INDIRECT
How to convert currency to text with formatting or vice versa in Excel?	TEXT VALUE
How to convert date stored as text to date in Excel?	DATEVALUE
How to convert dates to text or text formatting date to real date in Excel?	TEXT
How to convert decimal number to binary/octal/hex number or vice versa in Excel?	DEC2BIN DEC2OCT DEC2HEX BIN2DEC OCT2DEC HEX2DEC
How to convert feet to inches, miles, and meters easily in Excel?	CONVERT
How to convert full state names to abbreviations in Excel?	VLOOKUP
How to convert gallon to liter/ounce or vice versa in Excel?	CONVERT
How to convert hex number to decimal number in Excel?	HEX2DEC DEC2HEX
How to convert hex to binary in Excel?	HEX2BIN BIN2HEX
How to convert inch to foot, cm or mm in Excel?	CONVERT
How to convert kilograms to stones and pounds in Excel?	INT CONVERT ROUND MOD
How to convert letter grade to number in Excel?	VLOOKUP
How to convert yyyy-mm-dd-to standard date in Excel?	DATE LEFT MID RIGHT TEXT
How to convert yyyymmddhhmmss date format to normal datetime in Excel?	TEXT LEFT MID TIME
How to convert yyyymmdd to normal date format in Excel?	DATE LEFT MID RIGHT
How to convert weekday string to number in Excel?	MATCH
How to convert various unit measurements in cells in Excel?	CONVERT
How to convert time to integer hours or minutes in Excel?	INT
How to convert time to decimal over 24 hours in Excel?	IF TIME TEXT
How to convert time to decimal hours/minutes/seconds in Excel?	HOUR MINUTE SECOND
How to convert temperature units between Celsius, Kelvin and Fahrenheit in Excel?	CONVERT
How to convert seconds to time (hh mm ss ) or vice versa in Excel?	TEXT CHOOSE MATCH
How to mass convert text to date in Excel?	DATEVALUE
How to quickly convert milliseconds to a date in Excel?	DATE
How to quickly convert pounds to ounces/grams/kg in Excel?	CONVERT
How to spell out month of date in Excel?	TEXT
Edit > Copy & Paste
How to transpose / convert columns and rows into single column?	INDEX INT ROW COLUMNS MOD
How to repeat cell value x times in Excel?	VLOOKUP
How to copy and paste only non-blank cells in Excel?	LOOKUP CHOOSE INDEX SMALL IF ROW ROWS
How to transpose/convert a single column to multiple columns in Excel?	OFFSET COLUMNS ROWS INDEX
How to always get the value from above cell when inserting or deleting row in Excel?	INDIRECT ADDERESS ROW COLUMN
How to convert horizontal list to vertical list in Excel?	INDEX ROWS
How to convert matrix to vector or single column in Excel?	OFFSET TRUNC ROW COLUMNS MOD ROWS COLUMN
How to convert multiple rows to columns and rows in Excel?	OFFSET INT ROW COLUMN MOD
How to convert vector / single row or column to matrix in Excel?	OFFSET COLUMN ROW ROWS
How to copy and paste only non-blank cells in Excel?	LOOKUP CHOOSE INDEX SMALL IF ROW ROWS
How to copy and paste values skipping duplicates in Excel?	INDEX MATCH COUNTIF
How to copy column based on cell value to another sheet?	INDEX MATCH
How to copy conditional formatting rules to another worksheet/workbook?	COUNTIF
How to copy current cell address to other location in Excel?	ADDRESS COLUMN
How to move every other row to column in Excel	IF ISEVEN ROW ISODD
How to paste data in alternate blank rows in Excel?	MOD ROW
How To Paste Data into Filtered List Only Skipping Hidden Rows In Excel?	ROW
How to quickly stack multiple columns into one column in Excel?	INDEX INT ROW COLUMNS MOD ROW COLUMNS
How to quickly transpose blocks of data from rows to columns in Excel?	TRANSPOSE OFFSET
How to transpose / convert columns and rows into single row?	OFFSET ROW FLOOR COLUMN
How to transpose and concatenate cells into one column with delimiter in Excel?	TRIM CONCATENATE
How to transpose and link values in Excel?	TRANSPOSE
How to transpose cells in one column based on unique values in another column?	INDEX MATCH COUNTIF IFERROR IF
How to transpose every 5 or n rows from one column to multiple columns?	INDEX ROW COLUMN
How to transpose reference while auto fill down/RIGHT in Excel?	TRANSPOSE
Edit > Delete & Clear
How To Remove First, Last X Characters Or Certain Position Characters From Text In Excel?	RIGHT LEN LEFT MID
How to remove spaces between characters and numbers within cells in Excel?	SUBSTITUTE
How to remove text before or after a specific character from cells in Excel?	RIGHT FIND LEN SUBSTITUTE LEFT CHAR
How to remove leading spaces in cells in Excel?	TRIM
How to quickly remove dashes from cells in Excel?	SUBSTITUTE
How to remove duplicates and replace with blank cells in Excel?	IF COUNTIF
How to automatically remove duplicates form a list in Excel?	COUNTIF
How to avoid #ref error while deleting the rows in Excel?	OFFSET
How to delete rows if column contains values from the to remove list in Excel?	IF ISERROR VLOOKUP
How to delete string after nth character in Excel?	LEFT
How to quickly remove all numberings or bullet points from an Excel column?	RIGHT LEN
How to remove all asterisk characters from cells in Excel?	SUBSTITUTE
How to remove all but first x characters from cells in Excel?	LEFT RIGHT
How to remove all characters after the first/last space from cells in Excel?	LEFT FIND SUBSTITUTE LEN
How to remove all decimal points but retain value in Excel?	INT
How to remove all zeros after decimal in Excel?	SUBSTITUTE TRIM
How to remove both duplicate rows in Excel?	IF COUNTIF
How to remove conditional formatting from blank cells in Excel?	ISBLANK
How to remove duplicates but keep blank rows in Excel?	IF LEN TRIM ROW
How to remove duplicates but leaving lowest value in another column in Excel?	MIN MAX IF
How to remove duplicates that are case sensitive in Excel?	IF SUMPRODUCT EXACT AND
How to remove extension from filename in Excel?	LEFT LOOKUP FIND ROW INDIRECT
How to remove extra spaces between words in cells in Excel?	TRIM
How to remove first / last word from text string in cell?	RIGHT LEN FIND LEFT TRIM SUBSTITUTE
How to remove first or last n characters from a cell or string in Excel?	RIGHT LEN REPLACE LEFT
How to remove internal spaces in Excel string?	SUBSTITUTE TRIM
How to remove last / ending comma from cell in Excel?	IF RIGHT LEFT LEN
How to remove last/first character if it is a comma or certain character in Excel?	IF RIGHT LEFT LEN
How to remove leading and trailing spaces in Excel ?	TRIM
How to remove leading minus sign from numbers in Excel?	ABS
How to remove leading zeros from alphanumeric text string in Excel?	MID MATCH MID ROW INDIRECT LEN
How to remove letters from strings/numbers/cells in Excel?	SUM MID LARGE INDEX ISNUMBER ROW
How to remove middle initial from full name in Excel?	TRIM LEFT FIND LOWER MID
How to remove negative SIGN from numbers in Excel?	ABS
How to remove non-printable characters from cells in Excel?	CLEAN
How to remove plus sign or minus sign of data in Excel?	SUBSTITUTE
How to remove prefix / suffix from multiple cells in Excel?	RIGHT LEN LEFT
How to remove salutations from names cells in Excel?	RIGHT LEN FIND LEFT MID
How to remove text indicator (‘) in Excel?	VALUE
How to remove trailing zeros from number in Excel?	LEFT LEN
How to remove whitespace after text in Excel?	TRIM LEFT LEN

Edit > Extract
How to extract number only from text string in Excel?	SUMPRODUCT LARGE INDEX ISNUMBER MID ROW
How to extract part of text string from cell in Excel?	LEFT MID RIGHT
How to extract first / last / nth word from text string in Excel?	IF ISERR LEFT FIND RIGHT SUBSTITUTE LEN
How to extract month and year only from date in Excel?	TEXT
How to extract text between commas/brackets/parentheses in Excel?	SUBSTITUTE MID REPT FIND
How to extract time or hour only from datetime in Excel?	TIME HOUR MINUTE SECOND
How to extract first/last n characters from string in Excel?	LEFT RIGHT
How to quickly extract email address from text string?	TRIM RIGHT SUBSTITUTE LEFT FIND REPT LEN
How to extract unique values from multiple columns in Excel?	INDIRECT TEXT MIN IF COUNTIF ROW COLUMN
How to dynamically extract a list of unique values from a column range in Excel?	IFERROR INDEX MATCH COUNTIF
How to extract all but first / last word in Excel?	RIGHT LEN FIND LEFT SUBSTITUTE
How to extract all but first/last character from string in Excel?	MID LEN LEFT
How to extract all duplicates from a column in Excel?	INDEX MATCH COUNTIF IF IFERROR
How to extract all records between two dates in Excel?	SUMPRODUCT IF INDEX SMALL IF ROW ROWS
How to extract company name from email address in Excel?	LEFT REPLACE FIND
How to extract date from text strings in Excel?	MID MIN IFERROR LOOKUP ROW INDIRECT LEN
How to extract decimal numbers from text string in Excel?	LOOKUP LEFT MID MIN FIND ROW INDIRECT IFERROR COUNT SUBSTITUTE
How to extract decimal value from string in Excel?	ABS TRUNC
How to extract diagonal matrix in Excel?	INDEX ROWS
How to extract domain name from URL in Excel?	IF ISNUMBER FIND MID
How to extract domains from multiple email addresses in Excel?	MID SEARCH
How to extract extension from filename in Excel?	RIGHT LEN FIND SUBSTITUTE
How to extract file extension from worksheet?	REPLACE SEARCH RIGHT
How to extract first or first two words from text strings in Google sheet?	LEFT FIND REGEXEXTRACT
How to extract first two or n words from text string?	TRIM LEFT FIND SUBSTITUTE TRIM REPT
How to extract initials from names in Excel?	LEFT IF ISNUMBER FIND MID
How to extract middle name only or split names from full name in Excel?	IF ISERROR FIND MID
How to extract milliseconds from time in Excel?	RIGHT TEXT
How to extract numbers only from text strings in Google sheet?	SPLIT LOWER
How to extract or get the year, month and day from date list in Excel?	YEAR MONTH DAY
How to extract postcode from address list in Excel?	MID FIND SUBSTITUTE SUMPRODCT ROW INDIRECT LEN
How to extract state, zip code or city from address in Excel?	MID SUBSTITUTE FIND
How to extract string between two different characters in Excel?	MID LEFT FIND LEN SUBSTITUTE
How to extract street number from address in Excel?	IF ISERROR VALUE LEFT FIND
How to extract string from IP address in Excel?	MID FIND
How to extract text before / after the second space or comma in Excel?	IF ISERROR FIND LEFT MID
How to extract text before or after dash from cells in Excel?	LEFT FIND REPLACE
How to extract text between single or double quotes from cells in Excel?	MID FIND
How to extract text between the second and third comma from cells in Excel?	TRIM MID SUBSTITUTE REPT
How to extract text between two words in Excel?	MID SEARCH
How to extract unique values based on criteria in Excel?	INDEX MATCH IF COUNTIF
How to extract unique values from list in Excel?	IFERROR MATCH FREQUENCY IF EXACT TRANSPOSE ROW INDEX COUNTIF
How to extract username from email addresses in Excel?	LEFT FIND LEN
How to make lucky draw names in Excel?	IF ROWS INDEX ROW ISNA MATCH RANDBETWEEN COUNTA
How to pull or extract characters from right to left in a cell until a space is reached in Excel?	TRIM RIGHT SUBSTITUTE REPT
How to quickly determine or extract AM and PM from DateTime string in Excel?	IF MOD
How to quickly extract a nth character from a string in Excel?	MID LEN
How to quickly extract filename from full path in Excel?	MID FIND SUBSTITUTE LEN
How to quickly extract part of date from cell in Excel?	YEAR MONTH DAY WEEKDAY WEEKNUM
Edit > Fill cell content
How to generate random character strings in a range in Excel?	RANDBETWEEN CHAR RAND INT
How to quickly insert sheet names in cells in Excel?	RIGHT LEN CELL FIND
How to reference tab name in cell in Excel?	MID CELL FIND
How to generate random number without duplicates in Excel?	RAND IF ROW RANK OFFSET COLUMN INDEX
How to quickly insert file path into Excel?	LEFT FIND CELL
How to insert current day or month or year into cell/header/footer in Excel?	MONTH TODAY
How to insert file name or path into cell / header or footer in Excel?	MID CELL SEARCH LEFT FIND RIGHT
Generate random number by given certain mean and standard deviation in Excel	NORMINV AVERAGE STDEV.P STDEVP
How to autofill alpha characters in Excel?	CHAR ROW
How to autofill formula when inserting rows in Excel?	IF MOD
How to autofill VLOOKUP in Excel?	VLOOKUP
How to autofill weekdays exclude weekends in a list of Google sheet?	IF WEEKDAY
How to display default value based on anther cell in Excel?	VLOOKUP INDIRECT
How to display January (month name) if cell starts with 1(numbers) in Excel?	IF MONTH TEXT CHOOSE
How to display system time or date in Excel?	NOW TODAY
How to easily enter dates without slashes in Excel?	DATE RIGHT LEFT IF LEN RIGHT
How to enter/display text or message if cells are blank in Excel?	IF
How to fill a default value if cell is blank in Excel?	IF
How to fill column with series repeating pattern numbers in Excel?	IF
How to fill down IP Address with increment in Excel?	ROWS
How to fill down sequence numbers skip hidden rows in Excel?	SUBTOTAL
How to fill sequence dates without weekends and holidays in Excel?	WORKDAY
How to fill weekdays or weekends only in Excel?	TEXT INT ROW CEILING ROW
How to generate only random even or odd numbers in Excel?	EVEN RANDBETWEEN ODD
How to generate random date quickly in Excel?	RANDBETWEEN DATE
How to generate random decimal/integer numbers in Excel?	RAND INT RANDBETWEEN
How to generate random positive and negative numbers in Excel?	RANDBETWEEN RAND
How to generate random value based on assigned probability in Excel?	SUM INDEX COUNTIF RAND
How to generate random value from a given list in Excel?	INDEX RANDBETWEEN
How to generate random weekday or weekend date in Excel?	DATE LARGE IF WEEKDAY ROW RANDBETWEEN SUM WEEKDAY
How to generate random Yes or No in Excel?	CHOOSE RANDBETWEEN IF ISODD INT RAND
How to get the active workbook location/path in Excel?	LEFT CELL FIND SUBSTITUTE
How to get the next sheet name in Excel workbook?	WORKDAY DATE YEAR TODAY MONTH DAY
How to handle if cell contains a word then put a text in another cell?	IF ISNUMBER SEARCH
How to insert current date and time in Excel cell/header/footer?	NOW
How to insert current date and time in Excel?	NOW TODAY YEAR MONTH TEXT
How to insert current date into textbox?	NOW TODAY TEXT
How to insert current Excel file location in a cell of Excel?	LEFT CELL FIND
How to insert filename in header/footer/cell without extension in Excel?	TRIM LEFT SUBSTITUTE MID CELL FIND REPT SEARCH
How to insert random (integer) numbers between two numbers without repeats in Excel?	RAND RANDBETWEEN
How to quickly generate random password in Excel?	CHAR RANDBETWEEN CHAR
How to quickly generate random time in Excel?	TEXT RAND
How to randomly fill values from a list of data in Excel?	RANDBETWEEN VLOOKUP
How to reference or link value in unopened/closed Excel workbook file?	INDEX
How to reference worksheet by INDEX number instead of name in Excel?	INDIRECT SUM
How to repeat a cell value until new value is seen or reached in Excel?	IF
How to retrieve date and time from computer in Excel?	TODAY NOW
How to set cell value equal to tab name in Excel?	MID CELL FIND
Edit > Find
How to find duplicate values in two columns in Excel?	LEFT FIND MID
How to find duplicate values in two columns in Excel?	IF ISERROR MATCH
How to find unique/duplicate values between two columns in excel?	IF ISNA VLOOKUP
How to identify and return row and column number of cell in Excel?	ROW COLUMN MATCH
Find the lowest common denominator or greatest common factor in Excel	LCM GCD
How to apply the reverse find or search function in Excel?	TRIM RIGHT SUBSTITUTE REPT
How to detect duplicate entries in a list in Excel?	COUNTIF
How to find address of cell with max or min value in Excel?	CELL INDEX MATCH MAX
How to find all combinations that equal a given sum in Excel?	ROW INDIRECT ROWS IF ISNUMBER MATCH MOD INT TRANSPOSE MMULT SUMPRODUCT
How to find and extract maximal / minimal string based on alphabetic order in Excel?	INDEX MATCH COUNTIF
How to find and get the value of first visible cell after filtering in Excel?	INDEX MIN IF SUBSTITUTE OFFSET ROW
How to find duplicate or unique values in two columns of two sheets?	COUNTIF
How to find duplicate values without removing them in Excel?	IF COUNTIF
How to find exact word in a string in Excel?	ISNUMBER SEARCH
How to find first blank cells in column in Excel?	MIN ROW
How to find first value not equal to a value such as 0 in Excel?	IF
How to find first/all numbers in a string in Excel?	MID MIN IF ISNUMBER ROW INDIRECT LEN
How to find intersection of two column lists in Excel?	IF ISERROR MATCH
How to find out if exact match in Excel?	EXACT
How to find string in a cell/column with formulas in Excel?	ISNUMBER SEARCH FIND
How to find the first duplicate value in Excel column?	IF COUNTIF
How to find the longest or shortest text string in a column?	INDEX MATCH MAX LEN MIN
How to find the max length in an Excel column?	MAX LEN
How to find the nth non blank cell in Excel?	INDEX SMALL ROW COLUMN
How to find value in a cell with comma separated list in Excel?	IF ISNUMBER SEARCH
How to quickly find partial duplicates in an Excel column	LEFT COUNTIF
How to quickly find the position of first letter (alpha) from string in Excel?	MATCH ISERROR ROW MID INDIRECT LEN
How to quickly find the position of first uppercase in Excel text string?	MIN ISERROR FIND CHAR ROW INDIRECT
How to reverse search last word in a string with formula in Excel?	RIGHT LEN FIND SUBSTITUTE IF ISERROR
Edit > Go to
How to directly jump to next duplicate cell in Excel?	MATCH IFERROR ROW ADDRESS HYPERLINK IF
How to quickly jump to the cell with current date in Excel?	TODAY
Edit > Hide & Unhide
How to only show positive numbers in Excel?	IF SUM
How to show only duplicate rows in Excel column?	COUNTIFS
How to show only first nth characters in a cell string?	LEFT SUBSTITUTE
How to show only the last 4 digits of social security number (ssn) in Excel?	RIGHT
Edit > Move
How to move cells from horizontal to vertical or vice versa?	TRANSPOSE
How to move last character to front of a cell or another column in Excel?	RIGHT LEFT LEN
How to move last word to next adjacent cell?	RIGHT FIND SUBSTITUTE LEN
How to move multiple cells into one in Excel?	CONCATENATE
Edit > Replace
How to change or find and replace first number in cell in Excel?	REPLACE SUBSTITUTE
How to convert carriage return to comma in Excel?	SUBSTITUTE CHAR
How to replace first n character or nth occurrence of character with another in Excel?	REPLACE SUBSTITUTE
How to replace multiple spaces with single space from cells in Excel?	TRIM SUBSTITUTE CHAR
How to replace nth/all occurrences of a character in string in Excel?	SUBSTITUTE
How to replace the last comma with and in cells in Excel?	SUBSTITUTE LEN
Edit > Select
How to select cells randomly in Excel?	RAND INDEX RANK
How to select the highest or lowest value in Excel?	MAX MIN LARGE SMALL
How to identify missing numbers sequence in Excel?	IF SMALL MATCH ROW
How to find and select duplicate rows in a range in Excel?	IF SUMPRODUCT CONCATENATE COUNTIF
How to identify uppercase, lowercases, and PROPER cases in Excel?	EXACT UPPER LOWER PROPER SUBSTITUTE
How to randomly select cells based on criteria in Excel?	INDEX LARGE IF ROW INT RAND COUNTIF RANDBETWEEN COUNTIFS
How to select all negative numbers in Excel?	IF
How to select and highlight row differences in Excel?	NOT EXACT
How to select random cells from a list in Google sheets?	ARRAYFORMULA VLOOKUP QUERY UNIQUE RANDBETWEEN ROW INDIRECT COUNTA FILTER
How to select random data from a list without duplicates?	RAND INDEX RANK
How to select random names from a list in Excel?	INDEX RANDBETWEEN COUNTA
Edit > Split
How to split full name to first and last name in Excel?	LEFT FIND RIGHT LEN SEARCH MID
How to separate text and numbers from one cell into two columns?	LEFT MIN FIND RIGHT
How to split date and time from a cell to two separated cells in Excel?	INT
How to reverse the concatenate function in Excel?	TRIM SUBSTITUTE COLUMNS
How to quickly split date into separate day, month and year in Excel?	DAY MONTH YEAR
How to break or split number into individual digits in Excel?	MID COLUMN
How to separate area code from phone number in Excel?	MID
How to separate dollars and cents into two columns in Excel?	INT MOD
How to separate email addresses to username and domain in Excel?	LEFT FIND RIGHT LEN
How to separate positive and negative numbers into two columns in Excel?	IF
How to separate whole number (integer) from decimal in Excel?	INT
How to split a cell at the first number in Excel?	TRIM LEFT MIN FIND REPLACE LEN
How to split a cell vertically in Google sheet?	TRANSPOSE SPLIT
How to split a column every other row in Excel?	INDEX ROWS
How to split cell contents into columns or rows based on newline in Google sheet?	SPLIT CHAR TRANSPOSE JOIN
How to split cell into columns in Google Sheet?	SPLIT
How to split cells by first space delimiter in Excel?	LEFT FIND RIGHT LEN
How to split text into separate columns by capital letter in Excel?	LEFT SMALL FIND CHAR ROW INDIRECT REPLACE LEN
How to split word or number into separate cells in Excel?	MID COLUMNS
How to truncate number/text string in Excel?	LEFT RIGHT MID
Edit > Others
How to repeat a sequence of numbers in Excel?	IF MOD
How to repeat number sequence in Excel?	MOD

Format
Format > Conditional formatting
How to highlight largest / lowest value in each row or column?	MIN MAX
How to alter about approaching due date/deadline in Excel?	IF
How to apply conditional formatting across worksheets/workbooks?	MOD COLUMN ROW
How to apply conditional formatting search for multiple words in Excel?	SUM COUNTIF
How to change conditional formatting icon set color in Excel?	PERCENTILE
How to compare adjacent cells with Conditional Formatting icon sets in Excel?	IF SIGN
How to conditional format cells based on first letter/character in Excel?	LEFT
How to conditional format cells if containing #N/A in Excel?	ISNA
How to conditional format or highlight first occurrence (all unique values) in Excel?	COUNTIF
How to conditional formatting based on another sheet in Google sheet?	MATCH INDIRECT
How to conditional formatting based on date in Excel?	TODAY AND DATEVALUE
How to conditional formatting based on frequency (the most common number/text) in Excel?	MODE
How to conditional formatting cells which end with a string in Excel?	COUNTIF
How to conditional formatting data based on percentile rank in Excel?	PERCENTILE
How to conditional formatting duplicate cells in a column in Google sheet?	COUNTIF
How to conditional formatting only in Excel visible cells?	MOD SUBTOTAL
How to conditional formatting red amber green based on date in Excel?	AND TODAY EDATE
How to conditional formatting smiley face chart or font in Excel cells?	IF AND
How to conditional formatting values not between two numbers in Excel?	OR
How to highlight / conditional formatting cells with formulas in Excel?	GET.CELL INDIRECT
How to highlight / fill every nth row or column in Excel?	MOD COLUMN
How to highlight all error cells in Excel?	ISERROR
How to highlight all subtotal rows at once in Excel?	ISNUMBER FIND
How to highlight cell if value exists in or equals to cell in another column in Excel?	NOT ISNA VLOOKUP
How to highlight cell or row with checkbox in Excel?	IF
How to highlight cells based on length of text in Excel?	LEN
How to highlight cells between two dates in Excel?	AND
How to highlight cells if not in another column in Excel?	ISERROR MATCH
How to highlight duplicate rows across multiple columns in Excel?	COUNTIFS
How to highlight duplicate values except first instance in Excel?	COUNTIF
How to highlight largest / lowest value in each row or column?	MAX MIN
How to highlight locked cells in Excel	CELL
How to highlight multiples of a specific number in Excel?	MOD
How to highlight non-blank cells in Excel?	NOT ISBLANK
How to highlight odd or even numbers in Excel?	MOD ISODD ISEVEN
How to highlight or conditional formatting the max or min value in Google sheet?	MAX MIN LARGE SMALL
How to highlight row if cell contains date in Excel?	CELL
How to highlight rows based on date in Goolge sheet?	TODAY
How to highlight rows if dates have passed in Excel?	TODAY
How to highlight rows with weekend days in Excel?	WEEKDAY
How to highlight selected row / column / column and row in Excel?	OR CELL ROW COLUMN
How to highlight the closest value in a list to a given number in Excel?	ABS MIN ISNUMBER MATCH SMALL ROW
How to highlight the date of current day / week / month in Excel?	TODAY WEEKDAY TEXT
How to highlight the dates over a year old in Excel?	TODAY
How to highlight the duplicates and overlapping dates in Excel?	SUMPRODUCT
How to highlight the last duplicate row/cell in Excel?	COUNTIF
How to highlight the last row/cell in Excel?	MATCH ROW
How to highlight whole numbers in Excel?	IF LEN MOD
How to highlight winning lottery numbers in Excel worksheet?	COUNTIF
How to highlight/color unlocked cells in Excel?	CELL
How to highlight/conditional formatting dates older than 30 days in Excel?	TODAY
How to identify or highlight expired or upcoming dates in Excel?	TODAY
How to ignore blank or zero cells in conditional formatting in Excel?	ISBLANK AND SMALL IF
How to quickly insert a line based on current date in Excel?	IF TODAY
How to shade a blank cell until something is entered in Excel?	ISBLANK
How to shade every other column in Microsoft Excel?	MOD COLUMN
How to use conditional formatting to create a Gantt chart in Excel?	AND
Format > Format Cells
How to convert date to weekday, month, year name or number in Excel?	TEXT CHOOSE MONTH
How to change American date format in Excel?	TEXT
How to convert date to number string or text format in Excel?	TEXT
How to convert between date and Unix timestamp in Excel?	DATE
How to convert various non-standard date formats to standard date in Excel?	DATEVALUE RIGHT MID LEFT
How to convert dD.MM.YYYY to date format (mM/DD/YYYY) in Excel?	SUBSTITUTE MID LEFT RIGHT
How to align duplicates or matching values in two columns in Excel?	IF ISNA MATCH INDEX
How to alternate row color based on group in Excel?	IF
How to change multiple dates to day of week in excel?	TEXT
How to convert between Julian date and calendar date in Excel?	DATE IF LEFT RIGHT TEXT DATEVALUE
How to convert date from dot to slash format in Excel?	SUBSTITUTE
How to convert date to different or specific format in Excel?	TEXT
How to convert date to ordinal date format in Excel?	DAY IF OR CHOOSE RIGHT TEXT
How to convert date to serial number in Excel?	DATEVALUE
How to convert date to weekday, month, quarter or year in Excel?	TEXT LOOKUP MONTH
How to convert date to yyyy-mm-dd format in Excel?	TEXT
How to convert date/time format cell to date only in Excel?	MONTH DAY YEAR
How to convert dd hh mm time format to hours or minutes in Excel?	LEFT FIND MID LEN RIGHT SUBSTITUTE TEXT CONVERT DATE TIME
How to convert dd/mm/yyyy to mm/dd/yyyy in Excel cells?	DATE VALUE RIGHT MID LEFT
How to convert military time to standard time in Excel?	TIMEVALUE LEFT MID RIGHT
How to convert milliseconds to time in Excel?	CONCATENATE TEXT INT
How to convert number format between European and US in Excel?	NUMBERVALUE SUBSTITUTE FIXED
How to convert time format from 12 hour to 24 hour and vice versa in Excel?	TEXT
How to convert the phone number format to digits in Excel?	SUBSTITUTE
How to convert serial number to date in Excel?	TEXT
How to convert scientific notation to x10 format in Excel?	LEFT RIGHT TEXT
How to display or show year of date only in Excel?	YEAR
How to format date to show abbreviated day of week or month in Excel?	TEXT LEFT CHOOSE
How to format dates to uppercase months in Excel?	UPPER TEXT
How to format mac addresses in cells by adding colon symbol in Excel?	LEFT MID RIGHT
How to format phone number with extension in Excel?	LEFT MID
How to mark duplicate values with color in Excel?	COUNTIF IF
How to move the decimal poINT to LEFT in Excel?	LEFT LEN RIGHT SUBSTITUTE
How to pad cells to a fixed length in Excel?	LEFT RIGHT REPT LEN
How to pad IP address with zero in Excel?	TEXT LEFT FIND MID SUBSTITUTE
How to quickly convert date format between European and US in Excel?	DATE VALUE RIGHT MID LEFT
How to quickly convert Euro date format to US date in Excel?	DATE VALUE RIGHT MID LEFT
How to quickly convert mm/dd/yyyy date format to yyyymmdd in Excel?	TEXT
Data
Data > Check
How to check or find if value exists in another column?	IF ISERROR VLOOKUP MATCH
How to check if / find cells contains formulas in Excel?	ISFORMULA
How to check if a cell value is between two values in Excel?	IF AND
How to check if a cell value MATCH to a list in Excel?	IF ISNUMBER MATCH
How to check if a date is public holiday and count days except holidays in Excel?	DATE CHOOSE WEEKDAY IF COUNTIF NETWORKDAYS OR
How to check if a range of cells is blank or empty in Excel?	SUMPRODUCT
How to check if a value exists in another column then sum in Excel?	IF ISERROR VLOOKUP SUM
How to check if cell contains one of several values in Excel?	SUMPRODUCT ISNUMBER SEARCH IF
How to check if first character in a cell is a letter or number in Excel?	IF ISERR LEFT AND CODE OR
How to check if one list against another in Excel?	IF ISNA VLOOKUP COUNTIF
How to check if the number is integer in Excel?	INT
How to check if the number is prime number in Excel?	IF AND MOD ROW INDIRECT ROUNDUP QURT
How to check or find if a value is in a list in Excel?	IF ISNUMBER MATCH COUNTIF
How to quickly check if a range contains some values in Excel?	COUNTIF
Data > Comparsion
How to compare if multiple cells are equal in Excel?	AND EXACT COUNTIF
How to compare two columns and return values from the third column in Excel?	IF ISNA MATCH VLOOKUP
How to compare alphanumeric values in two columns in Excel?	IFERROR MATCH
How to compare if multiple cells are equal in Excel?	AND EXACT COUNTIF
How to compare numbers but allowing a tolerance in Excel?	AND ABS
How to compare two cells and return Yes if they are matched in Excel?	IF
How to compare two columns and delete MATCHes in Excel?	IF ISERROR MATCH
How to compare two columns and find the duplicate or missing values in Google sheet?	ARRAYFORMULA IFERROR MATCH FILTER ISNA MATCH
How to compare two columns and highlight when found in another column?	MATCH
How to compare two columns and list differences in Excel?	IF ISERROR MATCH
How to compare two columns for (highlighting) missing values in Excel?	IF ISERROR VLOOKUP
How to compare two lists of email addresses in Excel worksheet?	IF COUNTIF
How to compare two numbers with decimal numbers in Excel?	IF FLOOR ROUND
How to compare two sheets in same workbook or different workbooks?	IF
How to compare two strings for similarity or highlight differences in Excel?	EXACT
How to compare two worksheets in a workbook or two workbooks for differences in Excel?	IF
How to easily compare cells by case sensitive or insensitive in Excel?	AND EXACT
How to exactly compare two strings (case sensitive) in Excel?	EXACT IF
How to exclude values in one list from another in Excel?	COUNTIF IF ISERROR VLOOKUP
How to MATCH dates by month and year only in Excel?	MONTH YEAR
Data > Data validation
How to auto populate other cells when selecting values in Excel drop down list?	VLOOKUP
How to create a searchable drop down list in Excel?	ISNUMBER IFERROR SEARCH COUNTIF INDEX MATCH ROWS
How to allow only date format in specific cells?	AND ISNUMBER LEFT CELL
How to allow only yes or no entry in Excel?	OR
How to apply multiple data validation in one cell in Excel worksheet?	OR AND DATE LEN LEFT
How to auto update drop down list in Excel?	OFFSET COUNTA
How to create a dependent drop down list in Google sheet?	ARRAYFORMULA IF
How to create a drop down list from another drop down list in Excel?	INDIRECT
How to create a dynamic drop down list in alphabetical order in Excel?	OFFSET COUNTA IF ROWS INDEX MATCH COUNTIF
How to create a searchable drop down list in Excel?	ISNUMBER IFERROR SEARCH IF INDEX MATCH ROWS
How to create dependent cascading drop down lists in Excel?	INDIRECT
How to create drop down list ignore blank cells in Excel?	LOOKUP CHOOSE INDEX SMALL IF ROW ROWS
How to create drop down list with hyperlinks in Excel?	HYPERLINK
How to create drop down list with images in Excel?	INDEX MATCH
How to create dynamic data validation and extend the drop down automatically?	OFFSET COUNTA
How to data validation the date of current year in Excel worksheet?	YEAR TODAY
How to hide previously used items in dropdown list?	IF COUNTIF ROW COUNT INDEX SMALL OFFSET COUNTA COUNTBLANK
How to only allow alphanumeric characters entry in Excel?	ISNUMBER SUMPRODUCT SEARCH ROW INDIRECT LEN ISTEXT
How to only allow unique values in Excel?	COUNTIF
How to prevent duplicate entry in Google sheets?	COUNTIF
How to prevent entering values with spaces in Excel?	NOT ISNUMBER SEARCH
How to prevent lowercase entry in an Excel selection?	ISERROR FIND UPPER
How to prevent special characters entering in Excel?	ISNUMBER SUMPRODUCT SEARCH MID ROW INDIRECT LEN
How to set/show preselected value for drop down list in Excel?	IF
How to show the first item in the drop down list instead of blank?	OFFSET COUNTA
How to use Data Validation to limit calculated cell in Excel?	SUM
How to use data validation to limit number of digits while typing in Excel?	OR LEN AND ISNUMBER
How to use data validation to only allow SSN number entered in Excel?	AND LEFT ISNUMBER
How to use data validation to prevent blank cells LEFT in Excel column?	COUNTIF
How to validate cells to only accept IP address in Excel?	AND LEN SUBSTITUTE ISNUMBER
How to validate email addresses in a column of worksheet?	ISNUMBER MATCH
Data > Filter
How to filter a worksheet based on a range of cells in another worksheet in Excel?	COUNTIF
How to filter cells by length of text in Excel?	LEN
How to filter cells with case sensitive in Excel?	EXACT UPPER AND SUMPRODCT LOWER
How to filter data based on drop down list in Google sheet?	QUERY
How to filter data begins with number or letter in Excel?	ISNUMBER LEFT
How to filter data by multiple conditions in Google sheets?	FILTER
How to filter data by quarter in Excel?	TRUNC MONTH
How to filter data exclude bottom total row in Excel?	SUBTOTAL
How to filter data from drop down list selection in Excel?	ROWS IF IFERROR SMALL INDEX COLUMNS
How to filter every other row (even /odd rows) in Excel?	MOD
How to filter multiple columns based on single criteria in Excel?	ISERROR MATCH
How to filter numbers end with a specific number in Excel?	RIGHT
How to filter only integers (whole numbers) or decimal numbers in Excel?	INT
How to filter rows based on a list selection in another sheet?	COUNTIF
How to filter weekdays and weekend days in Excel?	WEEKDAY
How to quickly filter or hide even or odd numbers in Excel?	ISEVEN ISODD MOD
Data > Group & Ungroup
How to assign a value or category based on a number range in Excel?	IF AND
How to assign serial number to duplicate or unique values in Excel?	IF COUNTIF MAX VLOOKUP
How to categorize data based on values in Excel?	IF VLOOKUP
How to group ages in ranges with VLOOKUP in Excel?	VLOOKUP
Data > Sort
How to sort dynamic data in Microsoft Excel?	RANK VLOOKUP IFERROR
How to sort birthdays (dates) by month/year/day only in Excel?	YEAR DAY TEXT MONTH
How to randomly sort cells in a column or range in Excel ?	RAND
How to auto sort data alphabetically in Google sheets?	SORT
How to auto sort date when date is entered or changed in Excel?	INDEX MATCH ROWS COUNTIFI
How to quickly flip data upside down in Excel?	INDEX ROWS
How to quickly sort IP address from low to high in Excel?	TEXT FIND MID
How to quickly sort rows to MATCH another column in Excel?	MATCH
How to shuffle rows/columns/a range of cells randomly in Excel?	RAND
How to sort a list of column by character length in Excel?	LEN
How to sort a column to MATCH the value in another column in Excel?	IF COUNTIF
How to sort addresses by street name/number in Excel?	MID FIND VALUE LEFT
How to sort alphanumeric data in Excel?	TEXT
How to sort by file extension in Excel?	REPLACE RIGHT SEARCH
How to sort cells by absolute values in Excel?	ABS
How to sort cells by last character or number in Excel?	RIGHT
How to sort data by case sensitive in Excel?	CODE LEFT
How to sort data by the most frequent value in Excel?	COUNTIF
How to sort data ignoring the first character in Excel?	RIGHT LEN
How to sort date by day of week in Excel?	WEEKDAY
How to sort date by month ignoring year in Google sheets?	ARRAYFORMULA SORT MONTH
How to sort dates by quarter in Excel?	ROUNDUP MONTH
How to sort decimal numbers in a column?	INT TEXT RIGHT LEN FIND
How to sort each row alphabetically and individually at once?	SMALL
How to sort email address by domain in Excel?	MID FIND
How to sort full names by last name in Google sheets?	RIGHT LEN FIND SUBSTITUTE
How to sort list of cells by word count in Excel?	LEN SUBSTITUTE
How to sort list by specific word(s) in Excel?	SUM ISNUMBER SEARCH
How to sort mixed zip codes (5 digits and 9 digits) ascending in Excel?	LEFT
How to sort names by middle name in Excel?	IF ISERR FIND MID
How to sort numbers by first digit in Excel?	TEXT
How to sort numbers or texts and remove the duplicate records directly in Excel?	COUNTIF IF SMALL ROW LARGE MATCH INDEX
How to sort numbers with hyphens in Excel?	TEXT
How to sort numbers within a cell in Excel?	TEXT SUM SMALL MID ROW INDIRECT LEN REPT LARGE
How to sort or shuffle data in a list randomly in Google sheets?	SORT ARRAYFORMULA RANDBETWEEN SIGN ROW
How to sort rows by odd or even numbers in Excel?	ISODD
How to sort rows by upper lower case in Excel?	IF EXACT UPPER LOWER PROPER
How to sort strings by a second or third character in Excel?	RIGHT LEN MID
How to sort values ignore zeros in Excel?	IF

Calculation & Formulas
Calculation & Formulas > Calculation options
How to not calculate (ignore formula) if cell is blank in Excel?	IF TODAY
How to replace # formula errors with 0, blank or certain text in Excel?	ERROR.TYPE
How to ignore errors with Vlookup function in Excel?	IF ISERROR VLOOKUP
How to quickly calculate percentile or quartile ignore zeros in Excel?	PERCENTITLE IF QUARTILE
How to quickly rank values ignore errors in Excel?	IF ISNUMBER SUM COUNTIF
How to rank data ignore zero values in Excel?	IF RANK COUNTIF
How to remove divide by zero errors (#DIV/0!) in Excel?	IFERROR
How to update formula when inserting rows in Excel?	SUM INDIRECT ROW
Calculation & Formulas > Date & time
How to convert birthdate to age quickly in Excel?	INT DATEDIF NOW ROUNDDOWN YEARFRAC
How to add or subtract days, months, and years to date in Excel?	EDATE DATE YEAR MONTH DAY
How to remove time from date in Excel?
How to determine if a date falls between two dates or weekend in Excel?	IF AND
How to compare dates if greater than another date in Excel?	IF
How to quickly add hours/minutes/second to date and time in Excel?
How to convert date to fiscal year/quarter/month in Excel?	YEAR DATE MONTH CHOOSE
How to add days to date including or excluding weekends and holidays in Excel?	WORKDAY
How to add number of business/working days or hours to a date in Excel?	WORKDAY IF TIME HOUR MINUTE SECOND MOD
How to add number of years months and days to date in Google sheets?	DATE YEAR MONTH DAY EDATE
How to add or subtract specific years, months and days(2years4months13days) to a date in Excel?	DATE YEAR MONTH DAY EDATE
How to add or subtract times to get hours/minutes/seconds in Excel?	SUM
How to add time with hours/minutes/seconds increments in Excel?	TIME
How to add/subtract half year/month/hour to date or time in Excel?	DATE YEAR MONTH DAY
How to calculate / get day of the year in Excel?	DATE YEAR
How to calculate a future date based on a given date in Excel?	WORKDAY
How to calculate age from birth of date in Google sheet?	DATEIF TODAY IF
How to calculate age from ID number in Excel?	DATEIF DATE IF LEFT TEXT TODAY MID
How to calculate age in years and months and days from date of birth in Excel?	DATEIF
How to calculate age on a specific or future date in Excel?	DATEIF
How to calculate date/time overlap in days or hours in Excel?	MAX MIN MAX
How to calculate days hours and minutes between two dates in Excel?	INT HOUR MOD MINUTE
How to calculate days LEFT in month or year in Excel?	EOMONTH NETWORKDAYS DATE YEAR
How to calculate days LEFT until deadline in Excel?	TODAY MAX
How to calculate days until next birthday in Excel?	TODAY DATE YEAR DATEDIF MONTH DAY IF
How to calculate Easter date in Excel?	FLOOR DAY MINUTE
How to calculate elapsed time/days/months/years between two datetimes in Excel?	IF DATEDIF
How to calculate elapsed years, months, or days from a certain date in Excel?	YEAR TODAY DATEDIF
How to calculate end date from start date and duration in Excel?	IF DATE YEAR MONTH DAY
How to calculate expiration dates in Excel?	EDATE DATE YEAR MONTH DAY
How to calculate hours worked and minus lunch time in Excel?	SUM
How to calculate INTerval days/weeks/months/years between two dates in Excel?	DATEDIF ROUNDDOWN
How to calculate net work hours between two dates excluding weekends or holidays in Excel?	NETWORKDAYS MOD IF MEDIAN NETWORKDAYS.INTL
How to calculate next age of a person’s birthday in Excel?	DATEDIF TODAY TEXT
How to calculate number of days in a month or a year in Excel?	DAY DATE YEAR MONTH EOMONTH IF MOD
How to calculate number of working days left in current month in Excel?	NETWORKDAYS TODAY EOMONTH
How to calculate quarter and year from date in Excel?	INT MONTH YEAR
How to calculate quarter start date or end date based on a given date in Excel?	DATE YEAR INT MONTH FLOOR
How to calculate retirement date from date of birth in Excel?	IF DAY DATE YEAR MONTH
How to calculate the date of Thanksgiving day based on specific years in Excel?	DATE WEEKDAY DATE
How to calculate the employee tenure in months or years in Excel?	DATEDIF NOW
How to calculate the length of service from hire date in Excel?	DATEDIF
How to calculate week ending date of the given dates/years in Excel?	WEEKDAY DATE IF YEAR
How to calculate working hours per month in Excel?	NETWORKDAYS
How to check if a year is a leap year in Excel?	IF OR MOD AND
How to check if time difference greater than a specific time?	IF TIME
How to check if time is between two times in Excel?	IF MEDIAN AND MIN MAX
How to check if time is greater than or less than a specific time in Excel?	IF TIME
How to compare two dates by month and year only in Excel?	AND MONTH YEAR DAY
How to convert date time from one time zone to another in Excel?	TIME
How to convert hours to 8-hour work days in Excel?	QUOTIENT
How to determine if a date falls between two dates or weekend in Excel?	IF AND OR WEEKDAY
How to determine if date has passed in Excel?	IF ISBLANK TODAY
How to determine/check if date is a weekend in Excel?	IF WEEKDAY
How to find and get the first Monday of a specific year in Excel?	DATE WEEKDAY YEAR CHOOSE
How to find beginning/start of week by any given date in Excel?	WEEKDAY MOD
How to find first / last day or working day of a month in Excel?	DATE YEAR MONTH WORKDAY
How to find first or last Friday of every month in Excel?	CEILING EOMONTH DATE YEAR MONTH MOD WEEKDAY
How to find or get quarter from a given date in Excel?	ROUNDUP MONTH
How to find overlapping date/time ranges in Excel?	SUMPRODUCT
How to find the date of next Monday in Excel?	WEEKDAY
How to find the date of previous Sunday in Excel?	INT
How to get date of birth from ID number in Excel?	MID
How to get end of month date in Excel?	DATE YEAR MONTH EOMONTH
How to get month from week number and year in Excel?	CHOOSE MONTH WEEKDAY
How to get same or first day of next month based on given date in Excel?	EDATE IF DAY NA YEAR MONTH
How to get week start and end date based on a specific date in Excel?	WEEKDAY
How to increment date by 1 month, 1 year or 7 days in Excel?	TEXT ROWS
How to quickly convert UTC/GMT time to local time?	TIME
How to remove date from date time in Excel?	INT
How to remove year from date in Excel?	TEXT CONCATENATE MONTH DAY
How to return day of the week from date in Excel?	TEXT
How to return the previous working or business day in Excel?	WORKDAY TODAY
How to set date to first of month in Excel?	EOMONTH DATE YEAR MONTH
How to show first or last day of previous month based on given date in Excel?	EOMONTH DATE YEAR MONTH
How to tell/return day of week from date in Excel?	WEEKDAY
Calculation & Formulas > Formula Application
How to add 1 to a specified cell if cell contains certain text in Excel?	SUM
How to add/sum two numbers then multiply in one formula in Excel?	SUM
How to automatically increase letter by one to get the next letter in Excel?	IF RIGHT CHAR CODE LEFT MOD
How to calculate annual leave in Excel?	LOOKUP DATEEDIF
How to calculate bond price in Excel?	PV
How to calculate income tax in Excel?	SUM SUMPRODUCT N VLOOKUP
How to calculate item percentage of total in Excel?	SUM
How to calculate letter grade in Excel?	IF VLOOKUP
How to calculate monthly mortgage payment in Excel?	PMT
How to calculate rate of return on a share of stock in Excel?	XIRR
How to calculate the correlation coefficient between two variables in Excel?	CORREL
How to calculate the percentage of year or month passed in Excel?	YEARFRAC DATE YEAR DAY EOMONTH
How to calculate the percentage of yes and no from a list in Excel?	COUNTIF COUNTA
How to calculate total interest paid on a loan in Excel?	CUMIPMT
How to do exponential calculation to a range of cells in Excel?	POWER
How to quickly calculate the overtime and payment in Excel?	IF
Calculation & Formulas > Look for a value
How to vlookup values across multiple worksheets?	VLOOKUP INDIRECT INDEX MATCH COUNTIF IFERROR
How to find closest or nearest value in Excel?	INDEX MATCH MIN ABS
How to VLOOKUP and return multiple corresponding values horizontally in Excel?	INDEX SMALL ROW COLUMN
How to vlookup to return blank instead of 0 or N/A in Excel?	IF LEN VLOOKUP IFERROR
How to return value in another cell if a cell contains certain text in Excel?	IF ISNUMBER SEARCH VLOOKUP
How to vlookup find the first, 2nd or nth match value in Excel?	INDEX MATCH EXACT SMALL IF ROW
How to vlookup to another workbook?	VLOOKUP
How to vlookup value and return true or false / yes or no in Excel?	IF ISNA VLOOKUP
How to vlookup between two dates and return corresponding value in Excel?	LOOKUP
How to lookup a value and return cell address in Excel?	CELL INDEX MATCH SMALL ROW
How to vlookup return value in adjacent or next cell in Excel?	VLOOKUP INDEX SMALL IF ISNUMBER SEARCH MATCH ROW
How to return the first / last non blank cell in a row or column?	INDEX MATCH LOOKUP
How to VLOOKUP and return zero instead of #N/A in Excel?	IFERROR VLOOKUP
How to backwards vlookup in reverse order in Excel?	VLOOKUP CHOOSE INDEX MATCH
How to display specific text based on values in another column?	LOOKUP IF
How to display the corresponding name of the highest score in Excel?	INDEX MATCH MAX
How to do a case sensitive vlookup in Excel?	INDEX MATCH EXACT
How to find closest value greater than or less than in Excel?	MIN IF MAX
How to find common values in 3 columns in Excel?	LOOKUP CHOOSE INDEX MATCH COUNTIF IF
How to find matched value by searching upwards in Excel?	LOOKUP
How to find most common number or text in a list in Excel?	MODE
How to find most common value (number or text string) from a list in Excel?	MODE INDEX MATCH
How to find the closest date to today on a list in Excel?	MAX TODAY MIN IF
How to find the first / last positive / negative number in Excel?	INDEX MATCH LOOKUP IF
How to find the first / last value greater than X in Excel?	INDEX MATCH LOOKUP IF
How to find the first numeric cell in an Excel range?	INDEX MATCH ISNUMBER
How to find the highest value and return adjacent cell value in Excel?	VLOOKUP MAX INDEX MATCH
How to find the item with the largest sum in a table range?	INDEX MATCH LARGE MMULT TRANSPOSE ROW IFERROR LOOKUP ISERR SUMIF
How to find the least or most common / frequent value in Excel?	INDEX MATCH MIN COUNTIF
How to find the mode for text value from a list/column in Excel?	INDEX MODE MATCH
How to find the most common text value in a list in Google sheets?	ARRAYFORMULA INDEX MATCH MAX COUNTIF
How to find the second most common/frequent number or text in Excel?	MODE IF
How to find value with highest FREQUENCY in a range in Excel?	INDEX MOD MAX COUNTIF ROW MODE
How to look for a value in a list in Excel?	INDEX MATCH OFFSET
How to look up a value and return the cell above or below in Excel?	INDEX MATCH
How to lookup a value in 3D table in Excel?	INDEX MATCH
How to lookup first non-zero value and return corresponding column header in Excel?	INDEX MATCH
How to lookup partial string match in Excel?	VLOOKUP INDEX MATCH
How to lookup to return an active hyperlink in Excel?	HYPERLINK VLOOKUP
How to lookup value return multiple corresponding values in Excel?	IF ISERROR INDEX SMALL ROW
How to lookup/find values in another workbook?	VLOOKUP
How to merge and update table from another table in Excel?	IFERROR VLOOKUP COLUMN
How to merge two sheets by using VLOOKUP in Excel?	VLOOKUP
How to populate rows based on specified cell value in Excel?	IFERROR INDEX SMALL IF ROW ROWS
How to return a value if a given value exists in a certain range in Excel?	VLOOKUP
How to return another cell if one cell equals text or another in Excel?	IF
How to return cell value based on multiple criteria in Excel?	SUMPRODUCT
How to return cell value every five or nth row in Excel?	OFFSET ROW
How to reverse vlookup function in Google sheet?	INDEX MAX FILTER ROW MATCH
How to use two-way lookup formula in Excel?	INDEX MATCH SUMPRODUCT VLOOKUP
How to use vlookup and sum in Excel?	SUM VLOOKUP PRODUCT
How to use vlookup exact and approximate MATCH in Excel?	VLOOKUP
How to use VLOOKUP to create a unique list from table in Excel?	IFERROR INDEX MATCH COUNTIF IF
How to vlookup across multiple sheets and sum results in Excel?	SUMPRODUCT SUMIF INDIRECT
How to vlookup and concatenate multiple corresponding values in Excel?	IF COUNTIF ROWS INDEX SMALL
How to vlookup and return date format instead of number in Excel?	VLOOKUP MAX TEXT
How to vlookup and return matching data between two values in Excel?	LOOKUP
How to vlookup and return matching value in filtered list?	INDEX MATCH IF SUBTOTAL OFFSET ROW VLOOKUP
How to vlookup and return multiple matching values at once in Google sheet?	TRANSPOSE FILTER
How to vlookup and return multiple values from drop down list?	IFFERROR INDEX SMALL IF MATCH ROW
How to vlookup and return whole / entire row of a matched value in Excel?	VLOOKUP COLUMN
How to vlookup in two dimensional table in Excel?	VLOOKUP MATCH
How to vlookup matching value from another google sheet?	IFERROR VLOOKUP IMPORTRANGE
How to vlookup matching value from bottom to top in Excel?	LOOKUP
How to vlookup next largest value in Excel?	INDEX MATCH LOOKUP
How to vlookup numbers stored as text in Excel?	VLOOKUP VALUE IFERROR
How to vlookup the last or first matching value in Excel?	LOOKUP IF ISNUMBER
How to VLOOKUP the lowest value and return adjacent cell in Excel?	VLOOKUP MIN INDEX MATCH
How to VLOOKUP then multiply in Excel tables?	VLOOKUP MATCH
How to vlookup to compare two lists in separated worksheets?	VLOOKUP IF ISNA
How to vlookup to get the row number in Excel?	MATCH ROW
How to vlookup to return multiple columns from Excel table?	VLOOKUP
How to VLOOKUP value case sensitive or insensitive in Excel?	VLOOKUP SUMPRODUCT EXACT
How to vlookup value with multiple criteria in Excel?	LOOKUP SUMPRODUCT INDEX
How to vlookup values across multiple worksheets to return sheet names in Excel?	INDEX MATCH COUNTIF INDIRECT
How to vlookup values from right to left in Excel?	VLOOKUP IF INDEX MATCH
How to vlookup wildcard (~, *, ?) literally in Excel?	VLOOKUP SUBSTITUTE
How to VLOOKUP with drop down list in Excel?	VLOOKUP

Calculation & Formulas > Math Functions
How to sum values between two dates range in Excel?	SUMIFS
How to sum values based on criteria in another column in Excel?	SUMIF
How to sum cells with text and numbers in Excel?	SUM IF ISNUMBER FIND VALUE LEFT
How to sum the absolute values in Excel?	SUMIF SUM SUMPRODUCT ABS
How to quickly sum every other or nth row/column in Excel?	SUM IF MOD SUMPRODCT COLUMN
How to sum only filtered or visible cells in Excel?	SUBTOTAL
How to sum multiple columns based on single criteria in Excel?	SUM
How to round a range of cells in Excel?	ROUND
How to AutoSum multiple rows/columns/worksheets in Excel?	SUM
How to calculate cumulative sum / running total of a column in Excel?	SUM IF
How to calculate the absolute difference between two values/times in Excel?	ABS IF
How to correctly sum numbers with units in a range in Excel?	SUM SUBSTITUTE
How to create 3D reference to sum same range across multiple sheets in Excel?	SUM
How to exclude cells in a column from sum in Excel?	SUM
How to limit number of decimal places in formula in Excel?	ROUND SUM
How to multiply two columns and then sum in Excel?	SUMPRODUCT
How to quickly calculate the square root of a value in Excel?	SQRT
How to quickly sum a column cells ignore #N/A errors in Excel?	SUMIF
How to quickly sum up data of each column in Excel?	SUM
How to remove digits after decimal in Excel?	INT TRUNC
How to round / round up / round down a range of cell numbers in Excel?	ROUND
How to round / round up / round down time to nearest quarter / half hour in Excel?	MROUND CEILING FLOOR
How to round date to nearest month in Excel?	MONTH EOMONTH DAY
How to round date to previous or next specific weekday in Excel?	IF MOD WEEKDAY
How to round number to nearest 5/10/50/100 in Excel?	ROUND MROUND ROUNDUP ROUNDDOWN
How to round number up or down in Excel?	ROUNDUP ROUNDDOWN
How to round numbers (up/down) to hundreds, thousands, or millions in Excel?	ROUND ROUNDUP ROUNDDOWN
How to round numbers to nearest hundred / thousand / million in Excel?	ROUND
How to round percentage values to two decimal places in Excel?	ROUND ROUNDUP ROUNDDOWN
How to round prices to x.99 in Excel?	ROUND
How to round then sum values by one formula in Excel?	SUM ROUND
How to round time to nearest hour/minute/second in Excel?	MROUND ROUND FLOOR
How to round to nearest 1000s/100s/10s/1s/0.1s numbers in Excel?	ROUND
How to round to nearest even or odd number in Excel?	EVEN ODD
How to round values before summing in Excel?	SUM ROUND ROUNDDOWN ROUNDUP
How to sum / average ignore negative values in Excel?	SUMIF COUNTIF
How to sum / count checked checkboxes in Excel?	COUNTIF SUMPRODUCT
How to sum a column until a condition is met in adjacent column in Excel?	SUM INDEX MATCH
How to sum a specified row or column in a named range in Excel?	SUM OFFSET COLUMNS INDEX
How to sum all digits in a number in Excel?	SUMPRODUCT MID ROW INDIRECT LEN SUMPRODUCT
How to sum based on column and row criteria in Excel?	SUMPRODUCT SUM IF
How to sum cell values in a column until blank cell reached?	IF SUM INDEX MATCH
How to sum cell values with case sensitive in Excel?	SUMPRODUCT EXACT
How to sum cells if the corresponding string is in a certain length?	SUMPRODUCT LEN
How to sum cells when value changes in another column?	IF SUM
How to sum column values until next blank cell in Excel?	SMALL INDEX MATCH
How to sum corresponding values with same date in Excel?	SUMIF
How to sum diagonal of a range in Excel?	SUM ROW COLUMN ROWS
How to sum entire column except header/first row in Excel？	SUM
How to sum every n rows down in Excel?	SUM OFFSET ROW MOD COLUMNS
How to sum first digit of each cell only in Excel?	SUM ISNUMBER IF LEFT
How to sum largest or smallest 3 values in a list of Excel?	LARGE SMALL SUM ROW INDIRECT
How to sum numbers from 1 to n in Excel worksheet?	SUMPRODUCT ROW INDIRECT
How to sum numbers in brackets only in Excel?	IF ISERROR MID FIND SUM
How to sum numbers of last 7 or 30 days including TODAY in Excel?	SUMIF TODAY SUMIFS
How to sum numbers regardless of sign in Excel?	SUM ABS
How to sum numbers until a certain value is reached in adjacent cell in Excel?	SUMIF
How to sum numbers with commas in a single Excel cell?	SUM IF ISERR VALUE MID ROW OFFSET
How to sum only whole numbers in Excel?	SUMPRODUCT MOD INT
How to sum or average unique values only in Excel?	SUMPRODUCT COUNTIF SUM IF FREQUENCY MATCH ROW AVERAGE SUMIF
How to sum or average values if dates in adjacent cells equal to specified month in Excel?	SUM IF MONTH
How to sum or count first n values in an Excel column or row?	SUM OFFSET COUNT
How to sum range of cells ignoring errors in Excel?	SUM IF ISERROR
How to sum same cell in multiple sheets in Excel?	SUM
How to sum time and format as hours, minutes or seconds in Excel?	SUM
How to sum values based on month and year in Excel?	SUMPRODUCT MONTH YEAR
How to sum values based on selection of drop-down list in Excel?	SUMIF SUMPRODUCT
How to sum values based on text criteria in Excel?	SUMIF
How to sum values by group in Excel?	IF SUMIF
How to sum values in same column across multiple sheets?	SUM
How to sum values without or exclude subtotals in Excel?	SUM SUBTOTAL
How to sum values without or with n/a in Excel?	SUMIF IF SUM ISNA
How to SUMIF adjacent cell is equal, blank or containing text in Excel?	SUM IF ISBLANK SUMIF
How to sumif based on partial MATCH in Excel?	SUMIF
How to sumif cell values between two given dates in Google sheets?	SUMIFS
How to sumif cells begin with specific number or text in Excel?	SUMPRODUCT LEFT SUMIF
How to sumif cells if contains part of text string in Goolge sheets?	SUM FILTER REGEXMATCH SUMIF
How to sumif cells not equal to a specific value in Excel?	SUMIF SUMIFS
How to sumif date is less/greater than today in Excel?	SUMIF TODAY
How to sumif with 3d reference to sum across tABS based on criteria in Excel?	SUMPRODUCT SUMIF INDIRECT
How to sumif with multiple criteria in one column?	SUMIF SUM
How to sumif with numbers stored as text in Excel?	SUMIF SUMPRODUCT
How to sumif with one or more criteria in Excel?	SUMIF SUMIFS SUM

Calculation & Formulas > Statistical Functions
How to count and sum cells based on background color in Excel?	SUBTOTAL GET.CELL
How to calculate average/compound annual growth rate in Excel?	XIRR
How to count / calculate weeks / months / years between two dates in Excel?	DATEDIF
How to count duplicate values in a column in Excel?	COUNTIF
How to count if cell contains text or part of text in Excel?	COUNTIF
How to count unique values in pivot table?	IF SUMPRODUCT
How to countif with multiple criteria in Excel?	COUNTIF SUMPRODUCT
How to count the number of days / workdays / weekends between two dates in Excel?	NETWORKDAYS SUM INT WEEKDAY SUMPRODUCT
How to count the number of words in a cell or a range cells in Excel?	IF LEN TRIM SUBSTITUTE SUM
How to find earliest and latest dates in a range in Excel?	MIN SMALL MAX LARGE
How to count / sum only positive or negative numbers in Excel?	COUNTIF SUMIF
How to countif by date/month/year and date range in Excel?	SUMPRODUCT MONTH YEAR
How to count number of “Yes” or “No” answer in Excel?	COUNTIF
How to count number of cells between two values or dates in Excel?	COUNTIFS
How to countif a specific value across multiple worksheets?	SUMPRODUCT COUNTIF INDIRECT
How to average a range of data ignoring zero in Excel?	AVERAGE
How to average absolute values in Excel?	AVERAGE ABS
How to average based on day of week in Excel?	AVERAGE IF WEEKDAY SUMPRODCT
How to average cells based on multiple criteria in Excel?	AVERAGEIF AVERAGEIFS
How to average cells ignoring error values in Excel?	AVERAGE IF ISERROR
How to average data based on weekday or weekend in Excel?	SUM WEEKDAY
How to average every 5 rows or columns in Excel?	AVERAGE OFFSET ROW
How to average filtered cells/list in Excel?	SUBTOTAL
How to average for cells with values only (exclude 0 or blank cells) in Excel?	AVERAGEIF
How to average last 5 values of a column as new numbers entering?	IF COUNT AVERAGE INDEX LARGE MIN ISNUMBER ROW SUBTOTAL OFFSET
How to average multiple vlookup findings in Excel?	AVERAGE IF
How to average non-adjacent/contiguous cells excluding zeroes in Excel?	AVERAGE IF MOD COLUMN
How to average only positive or negative numbers in Excel?	AVERAGE IF
How to average range with rounding in Excel?	ROUND AVERAGE ROUNDUP ROUNDDOWN
How to average right result with missing values in Excel?	AGGERGATE AVERAGE IF ISNUMBER
How to average timestamps of day in Excel?	INT AVERAGE TEXT
How to average top or bottom 3 values in Excel?	AVERAGE LARGE ROW SMALL IF
How to average values if another column contains certain text in Excel?	IFERROR INDEX MATCH COUNTIF AVERAGE
How to calculate average age by year/month/date in Excel?	SUM MONTH IF YEAR AVERAGE SUBTOTAL
How to calculate average between two dates in Excel?	AVERAGE IF SUMPRODUCT
How to calculate average cells from different sheets in Excel?	AVERAGE
How to calculate average in a column based on criteria in another column in Excel?	AVERAGEIF
How to calculate average numbers greater than 0 in Excel?	AVERAGEIF
How to calculate average of dynamic range in Excel?	AVERAGE INDIRECT IF INDEX
How to calculate average without max and min values in Excel?	SUM MIN MAX COUNT TRIMMEAN
How to calculate frequency distribution in Excel?	FREQUENCY
How to calculate median if multiple conditions in Excel?	MEDIAN IF
How to calculate median in a range in Excel?	MEDIAN IF
How to calculate median in an Excel pivot table?	MEDIAN IF
How to calculate midpoint between two dates in Excel?	SUM
How to calculate moving/rolling average in Excel?	AVERAGE
How to calculate rank percentile of a list in Excel?	RANK.EQ COUNT
How to calculate running total / average in Excel?	SUM
How to calculate standard deviation in Excel?	STDEV
How to calculate standard error of the mean in Excel?	STDEV SQRT COUNT
How to calculate the median in visible cells only in Excel？	AGGERGATE
How to calculate the percentile and quartile of a set of numbers in Excel?	PERCENTILE QUARTILE
How to calculate weekly average in Excel?	WEEKNUM IF AND AVERAGEIFS AVERAGEIF
How to calculate weighted average in Excel?	SUMPRODUCT SUM SUMIF
How to count (identify) and change decimal place in Excel?	IF INT LEN MID FIND
How to count / calculate quarters between two dates in Excel?	FLOOR YEAR MONTH
How to count / sum cells based on filter with criteria in Excel?	SUBTOTAL COUNTVISIBLE SUMVISIBLE
How to count / sum odd / even numbers or rows in Excel?	SUMPRODUCT MOD
How to count / sum only positive or negative numbers in Excel?	COUNTIF SUMIF
How to count a character in an Excel cell or a range?	LEN SUBSTITUTE SUMPRODUCT
How to count all cells except a specific value in Excel?	COUNTIF
How to count all cells with value/data in a range in Excel?	COUNTA
How to count and remove duplicates from a list in Excel?	COUNTIF
How to count blank cells as zero when using average in Excel?	AVERAGE SUM
How to count blank cells or nonblank cells in a range in Excel?	COUNTIF
How to count blank or non-blank cells in filtered range in Excel?	SUBTOTAL
How to count cells between two times in Excel?	SUMPRODUCT
How to count cells containing numbers or not in Excel?	COUNT SUMPRODUCT NOT ISNUMBER COUNTA
How to count cells if one of multiple criteria met in Excel?	COUNTIF SUM SUMPRODUCT
How to count cells match to either X or Y in Excel?	COUNTIF
How to count cells that equal to a certain value in Excel?	COUNTIF
How to count cells with length greater than a specific number in Excel?	SUMPRODUCT LEN COUNTCHAR
How to count cells with question marks in Excel?	COUNTIF
How to count cells with specific text in selection in Excel?	COUNTIF
How to count cells with zeros but not blanks in Excel?	COUNTIF
How to count cells/records by group in Excel?	COUNTIF
How to count characters in cell/range/worksheet in Excel?	LEN SUM
How to count comma separated values in a single cell in Excel?	LEN TRIM SUBSTITUTE
How to count consecutive duplicates in Excel?	IF
How to count days between two dates including start date in Excel?	IF OR INT NOT ISBLANK
How to count duplicate values in a column in Excel?	COUNTIF
How to count duplicates between two columns in Excel?	SUMPRODUCT ISNUMBER MATCH
How to count frequency of a text/number/character in Excel column?	SUM IF COUNTIF
How to count how many cells contain certain text or value in Excel?	COUNTIF
How to count how often a word or a value occurs in Excel?	SUMPRODUCT LEN SUBSTITUTE
How to count if cell does not contain text in Excel?	COUNTIF
How to count if cells are nonblank and not equal to specific word in Excel?	COUNTIF COUNTBLANK
How to count if cells are start with or end with specific text in Excel?	IF LEFT COUNTIF RIGHT
How to count if cells contain any date/data in Excel?	COUNTA
How to count if value falls within a given range in Excel?	FREQUENCY
How to count ignore hidden cells/rows/columns in Excel?	SUBTOTAL AGGERGATE
How to count ignoring zeros or blank cells in Excel?	COUNT IF
How to count max number of consecutive positive / negative numbers in Excel?	MAX FREQUENCY IF ROW
How to count max or min occurrences in Excel?	COUNTIF MAX
How to count networkdays between two dates including Saturday in Excel?	SUMPRODUCT TEXT ROW INDIRECT
How to count number of cells greater or less than 0 (zero) in Excel?	COUNTIF
How to count number of cells with nonzero values in Excel?	COUNTIF COUNTA COUNTIF
How to count number of cells with text or number in Excel?	COUNTA COUNT
How to count number of cells/rows until first blank in Excel?	MIN IF ROW MATCH
How to count number of certain/specific words in a cell or a range of cells in Excel?	LEN SUBSTITUTE
How to count number of continuous blank cells in Excel?	IF ISBLANK ROW MAX NOT
How to count number of half hour intervals in Excel?	FLOOR
How to count number of instances if string length is greater than X in Excel?	COUNTIF REPT SUMPRODUCT LEN
How to count number of leap years between two dates in Excel?	DATE YEAR AND MONTH
How to count number of lines (line breaks) in a cell in Excel?	LEN SUBSTITUTE CHAR
How to count number of occurrence in a column in Google sheet?	UNIQUE COUNTIF ARRAYFORMULA QUERY
How to count number of occurrence in a datetime range in Excel?	SUMPRODUCT
How to count number of peaks in a column of data in Excel?	SUMPRODUCT IF AND
How to count occurrences of specific character in a cell in Excel?	SUMPRODUCT LEN SUBSTITUTE
How to count records between two dates with matching criteria in Excel?	SUMPRODUCT
How to count rows until a certain sum value is reached in Excel?	MATCH SUBTOTAL OFFSET ROW INDIRECT ADDRESS COLUMN
How to count same or duplicate values only once in a column?	SUMPRODUCT COUNTIF
How to count specific characters (comma/semicolon/question marks) in cell/range in Excel?	LEN SUBSTITUTE
How to count strings with leading zeros in Excel?	SUMPRODUCT SUM
How to count the cells above certain value or AVERAGE in Excel?	COUNTIF AVERAGE
How to count the days excluding Sundays between two dates in Excel?	WEEKDAY
How to count the difference between letters in Excel?	CODE
How to count the line breaks in cell in Excel?	LEN SUBSTITUTE CHAR
How to count the number of a word or character in an Excel column or cell?	COUNTIF LEN SUBSTITUTE
How to count the number of cells with data in Excel?	COUNTA
How to count the number of characters excluding spaces in Excel cell?	LEN SUBSTITUTE
How to count the number of characters, letters and numbers in cell?	LEN SUBSTITUTE SUM
How to count the number of commas/dashes separated values in a cell in Excel?	LEN SUBSTITUTE
How to count the number of days except Sunday/weekends in Excel?	SUM IF WEEKDAY ROW INDIRECT SUMPRODUCT
How to count the number of days or workdays in a month in Excel?	DAY DATE YEAR MONTH
How to count the number of error cells / non error cells in Excel?	SUM ISERROR COUNTIF NOT
How to count the number of occurrences of a word in a column in Excel?	COUNTIF SUM IF
How to count the number of occurrences per year/quarter/month/week in Excel?	SUMPRODUCT MONTH YEAR
How to count the number of populated cells in a range in Excel?	COUNTA
How to count the number of shaded cells in Excel?	GET.CELL COUNTIF
How to count the number of spaces before text string in Excel cell?	FIND LEFT TRIM
How to count the number of spaces of text string in Excel?	LEN SUBSTITUTE
How to count the number of times a character / word appears in a cell?	LEN SUBSTITUTE
How to count the number of times a word / number appears in a range?	SUM LEN
How to count the number of unique rows (combinations of multiple columns) in Excel?	SUM COUNTIF
How to count the number of uppercase or lowercase letter in cell?	SUMPRODUCT LEN SUBSTITUTE CHAR ROW INDIRECT
How to count the number of weekends/weekdays between two dates in Excel?	INT WEEKDAY
How to count unique values based on another column in Excel?	SUMPRODUCT COUNTIFS
How to count unique values based on multiple criteria in Excel?	SUM IF COUNTIF COUNTIFS DATE
How to count unique values between two dates in Excel?	SUMPRODUCT IF COUNTIFS
How to count unique values excluding duplicates in Excel?	SUM IF FREQUENCY MATCH ROW
How to count unique values in a filtered column in Excel?	SUM IF FREQUENCY SUBTOTAL OFFSET ROW MATCH
How to count unique values or numbers in a column in Excel?	SUMPRODUCT COUNTIF SUM FREQUENCY IF MATCH LEN
How to count unique values with blanks in an Excel column?	SUMPRODUCT COUNTIF
How to count unique values with multiple criteria in Excel?	COUNTIFS COUNTIF
How to count unique/duplicate dates in an Excel column?	SUMPRODUCT COUNTIF
How to count/sum the cells greater than but less than a number?	COUNTIF SUMIF
How to countif absolute values greater/less than given value in Excel?	SUMPRODUCT ABS COUNTIF
How to countif cell values with case sensitive in Excel?	SUMPRODUCT EXACT SUM IF
How to countif filtered data/list with criteria in Excel?	IF COUNTIFS SUMPRODUCT SUBTOTAL OFFSET MIN ROW ISNUMBER SEARCH
How to countif partial string/substring match in Excel?	COUNTIF COUNTIFS
How to countif something is in selected cells in Excel?	COUNTA
How to countif wildcards (asterisks or question marks) in Excel?	SUM LEN SUBSTITUTE
How to determine frequency of a character/text/string in an Excel range?	SUM IF COUNTIF
How to drop the lowest grade and get the average or total of values in Excel?	SUM SMALL
How to easily rank data by absolute value in Excel?	SUMPRODUCT ABS RANK
How to easily rank list without ties in Excel?	RANK COUNTIF
How to easily rank numbers skip blank cells in Excel?	IF ISBLANK VALUE ROW SMALL IFERROR MATCH RANK
How to find and get the largest value based on multiple criteria in Excel?	LARGE IF SUMPRODUCT
How to find and get the max or min value from a list of alphanumeric data in Excel?	LOOKUP COUNTIF
How to find and get the nth largest value without duplicates in Excel?	MAX IF
How to find and return larger or smaller of two values in Excel?	MIN MAX
How to find highest value in a row and return column header in Excel?	INDEX MATCH MAX
How to find largest negative value (less than 0) in Excel?	MAX
How to find max or min value in a certain date range (between two dates) in Excel?	MAX MIN IF
How to find max or min value in a group in Excel?	IF
How to find minimum value in a range excluding zero value in Excel?	SMALL COUNTIF MIN IF
How to find smallest positive value (greater than 0) in Excel?	MIN
How to find the earliest or latest date base on criteria in Excel?	MIN IF MAX
How to find the largest letter in a range in Excel?	LOOKUP COUNTIF
How to find the lowest and highest 5 values in a list in Excel?	LARGE ROWS SMALL
How to find the max or min value based on criteria in Excel?	MAX MIN IF
How to find the max or min value for each day in an Excel range?	MAX MIN
How to find the maximum / minimum absolute values in Excel?	MAX ABS MIN
How to find the maximum value in a dynamic Excel column?	MAX INDEX MATCH OFFSET
How to find the nth largest / smallest unique value in Excel?	LARGE IF ISNUMBER ROW MATCH SMALL
How to find/select minimum data/value in a range in Excel?	MIN
How to get max/min of visible cells only in Excel?	SUBTOTAL
How to ignore blanks when calculate the weighted average in Excel?	SUMPRODUCT SUM
How to limit formula result to maximum or minimum value in Excel?	MIN SUM MAX
How to lookup latest or earliest date in Excel?	MIN IF MAX
How to median values ignore zeros or errors in Excel?	MEDIAN IF ISNUMBER
How to quickly color ranking in Excel?	RANK
How to quickly count appearance in every 15 minutes in Excel?	INT
How to quickly count if cells are equal to x or y in Excel?	COUNTIF SUM IF
How to quickly count the first instance only of values in Excel?	COUNTIF SUM
How to quickly count the number of cells until value changes in Excel?	COUNTIF
How to quickly find or return the second highest or smallest value in Excel?	LARGE SMALL
How to quickly find the largest value but smaller than X in Excel?	MAX IF SUMPRODUCT
How to quickly rank a league table in Excel?	COUNTIF
How to quickly rank a list by a specific value in Excel?	IF COUNTIFS
How to quickly rank closet to zero or a specific value in Excel?	ABS RANK SUMPRODUCT
How to quickly rank data across multiple ranges and sheets in Excel?	IF SUMPRODUCT COUNTIF INDIRECT
How to quickly rank non-continuous range in Excel?	RANK IF ISNA
How to rank based on two columns in Excel?	RANK SUMPRODUCT
How to rank data by alphabetical order in Excel?	COUNTIF
How to rank data by occurrences in Excel?	COUNTIF RANK
How to rank data in reverse order in Excel?	RANK
How to rank data with multiple references in Excel?	SUMPRODUCT
How to rank data without sorting in Excel?	RANK
How to rank duplicate values in Excel?	RANK RANK.EQ RANK.AVG
How to rank duplicate without skipping numbers in Excel?	RANK COUNTIF SUM IF
How to rank if greater than 0 in Excel?	IF RANK
How to rank only visible cells in Excel?	SUM IF SUBTOTAL OFFSET ROW
How to rank positive and negative numbers separately in Excel?	IF MATCH SMALL ROW INDIRECT COUNTIF LARGE
How to rank range numbers uniquely without duplicates in Excel?	RANK COUNTIF
How to rank values by group in Excel?	SUMPRODUCT
How to use countif to calculate the percentage in Excel?	COUNTIF COUNTA
Calculation & Formulas > Others
How to find nth occurrence (position) of a character in text string in Excel?	FIND SUBSTITUTE CHAR
How to use IF function with AND, OR, and NOT in Excel?	IF AND OR
How to combine transpose function and If statement function in Excel?	IF COUNT TRANSPOSE
How to create dynamic named range in Excel?	SUM OFFSET COUNTA
How to define range based on another cell value in Excel?	AVERAGE INDIRECT CONCATENATE SUM INDIRECT
How to determine if a number or value is in a range in Excel?	IF COUNTIF
How to find and return the second to last value in a certain row or column in Excel?	INDEX LARGE ROW IF OFFSET COUNTA
How to find position of first/last number in a text string in Excel?	MIN SEARCH MATCH ABS MID ROW INDEX LEN MAX ISERROR VALUE INDIRECT ISNUMBER FIND
How to find position of nth space in Excel string?	FIND
How to find the first, last or nth occurrence of a character in Excel?	SEARCH SUBSTITUTE LEN LOOKUP MID ROW INDIRECT
How to find the position of the first lowercase letter from text strings?	MATCH IF ABS CODE MID ROW INDIRECT LEN
How to get a row or column letter of the current cell in Excel?	CHAR ROW LEFT ADDRESS COLUMN
How to get the address of active cell in Excel?	ADDRESS ROW COLUMN
How to get the cell value based on row and column numbers in Excel?	INDIRECT ADDERESS
How to increase or increment cell reference by X in Excel?	OFFSET ROW
How to increment worksheet reference automatically in Excel?	INDIRECT
How to prevent cell reference in a formula from incrementing /changing in Excel?	SUM
How to quickly get address of named range in Excel?	ADDRESS ROW COLUMN ROWS COLUMNS
How to return filename without extension to cell?	MID CELL SEARCH SUBSTITUTE TRIM LEFT FIND REPT
How to return the row number of first or last non blank cell in worksheet?	ROW INDEX MATCH SUMPRODUCT MAX
How to use hlookup to sum a range of values in Excel?	SUMPRODUCT HLOOKUP SUM INDEX
How to use Replace function to replace and add string in Excel?	REPLACE DATEVALUE FIND
How to use SUBSTITUE function in Excel?	SUBSTITUTE

Review & Security
How to only hide part of cell value in Excel?	RIGHT LEFT
How to share only one specific sheet to others in Google sheet?	IMPORTRANGE
Developer
How to change a specified cell value or color when checkbox is checked in Excel?	IF
How to create dynamic cascading list boxes in Excel?	IFERROR INDEX MATCH COUNTIF
How to make checkbox checked based on cell value in Excel?	IF
How to display warning/alert messages if cells are blank in Excel?	COUNTBLANK IF ISBLANK
Others
How to analyze survey data in Excel?	COUNTA COUNTBLANK SUM COUNTIF
How to create username from full name using first initial and last name?	PROPER LEFT TRIM RIGHT SUBSTITUTE REPT
How to increment number every x rows in Excel?	INT ROW
How to increment numbers when value changes in another column?	IF COUNTIF
How to keep cell blank when applying formula until data entered in Excel?	IF OR ISBLANK
How to make birthday reminder in Excel?	IF MONTH DAY
How to match the cell value with sheet tab name or vice versa in Excel?	MID CELL FIND
How to rotate table by 90 or 180 degrees in Excel?	OFFSET ROWS ROW COLUMNS COLUMN
How to play a sound if a condition is met in Excel?	IF
How to keep duplicate rows only in a column in Excel?	COUNTIF