Free download excel 2010 formula book

Find duplicate values in two columns. Highlight approximate match lookup conditional formatting. Highlight cells that begin with. Highlight cells that contain. Highlight cells that contain one of many. Highlight cells that end with. COUNTIF RIGHT LEN EXACT. Highlight cells that equal. Highlight data by quartile. Highlight dates greater than. Highlight dates in same month and year. Highlight dates in the next N days.

Last row in numeric data. Last row in text data. Last row number in range. Multiple cells have same value. Multiple cells free download excel 2010 formula book same value case sensitive.

Get name from email address. Get top level domain TLD. Strip protocol and trailing slash from URL. MID RIGHT LEN FIND. Get first name from name. Get free download excel 2010 formula book name from name with comma. Get last name from name. Get last name from name with comma. Get middle name from full name. Join first and last name. Put names into proper case. Get amount with percentage.

Data validation date in specific year. Data validation don't exceed total. Free download excel 2010 formula book validation exists in list. Data validation must begin with. Data validation must not contain. Data validation must not exist in list. Data validation only dates between. Data validation require unique number. Data validation unique values only. Get decimal part of a number. Get integer part of a number.

Square root of number. Transpose table without zeros. Validate input with check mark. Value exists in a range.

Average last 5 values. Average last 5 values in columns. Average numbers ignore zero. Average response time per month. Average the last 3 numeric values. LOOKUP LARGE ROW AVERAGE. Average top 3 free download excel 2010 formula book. First in, last out times. MINIFS MAXIFS MAX IF. Larger of two values.

Round by bundle size. Round time to nearest 15 minutes. Round to nearest Round to nearest 5. Add business days to date. Add days exclude certain days of week.

If Monday, roll back to Friday. Join date and text. Last updated date stamp. List holidays between two dates. Next biweekly payday from date. Next business day 6 months in future. Pad week numbers with zeros. Random times at specific intervals. Sum race time splits.

Force negative numbers to zero. If cell begins with x, y, or z. If cell is blank. Free download excel 2010 formula book cell is greater than. If cell is not blank. If cell is this OR that. If NOT this or that. If this AND that. Invoice status with nested if. Free download excel 2010 formula book IF function example. Tax rate calculation with fixed base.

Split text string at specific character. LEFT RIGHT LEN FIND. Strip html from text or numbers. TEXTJOIN MID ROW INDIRECT. Strip numeric characters from cell. Annual compound interest schedule. Calculate cumulative loan interest. Calculate cumulative loan principal payments. Calculate interest for given period.

Range contains a value not in another range. Total cells in a range. Total columns in range. Total rows in range. Basic attendance tracking formula. Basic free download excel 2010 formula book trapping example. Basic in cell histogram. Build hyperlink with VLOOKUP. Calculate a ratio from two numbers. Cap percentage at specific amount. Change negative free download excel 2010 formula book to positive. Convert column letter to number. Convert column number to letter.

Get number at place value. Round a number down. Round a number down to nearest multiple. Round a number to n significant digits. ROUND LOG10 INT ABS. Round a number to nearest multiple. Round a number up. Round a number up to nearest multiple. Round a number up to next half. Round a price to free download excel 2010 formula book in.

Double quotes inside a formula. Extract multiple lines from a cell. Extract nth word from text string. Extract text between parentheses. Extract word containing specific text. Extract word that begins with specific character. Find nth occurrence of character. Get last line in cell. Join cells with comma. Most frequently occurring text. Position of 2nd 3rd etc instance of character. Remove characters from left. Remove characters from free download excel 2010 formula book. Remove file extension from filename.

Two-way summary count with COUNTIFS. Subtotal by invoice number. Subtotal invoices by age. Sum bottom n values. Sum by month ignore year. Sum columns based on adjacent criteria. Sum every n rows. Sum every nth column. Sum if begins with. Sum if by year. Sum if cell contains text in another cell. Sum if cells are equal to. Sum if cells are not equal to. Sum if cells contain an asterisk. Sum if cells contain both x and y.

Percent of students absent. Address of first cell in range. ADDRESS ROW COLUMN CELL. Free download excel 2010 formula book of last cell in range. ADDRESS ROW COLUMN ROWS COLUMNS. All cells in range are blank. Dynamic named range with INDEX. Free download excel 2010 formula book named range with OFFSET. First column number in range. First match between two ranges. First row number in range.

Maximum if multiple criteria. Minimum if multiple criteria. Smaller of two values. Approximate match with multiple criteria. Basic INDEX MATCH approximate. Basic INDEX MATCH exact. Basic Tax Rate calculation with VLOOKUP. Calculate grades with VLOOKUP. Calculate shipping cost with VLOOKUP. Categorize text with keywords. INDEX MATCH ISNUMBER SEARCH. Dynamic lookup table with INDIRECT.

Get relative column numbers in range. Get relative row numbers in free download excel 2010 formula book. Last column number in range. Last row in mixed free download excel 2010 formula book with blanks. Free download excel 2010 formula book row in mixed data with no blanks.

Remove leading and trailing spaces from text. Remove text by matching. Remove text by position. Remove text by variable position. Replace one character with another. Split dimensions into three parts.

Map inputs to arbitrary values. Map text to numbers. Match next highest value. Max if criteria match. Merge tables with VLOOKUP. Multiple free download excel 2010 formula book in comma separated list. Next largest match with the MATCH function. Partial match against numbers with wildcard.

Get last match cell contains. Get location of value in 2D array. SMALL IF MIN ROW. Get nth match with VLOOKUP. Group arbitrary text values. Group numbers with VLOOKUP.

Split dimensions into two parts. Split numbers from units of measure. MAX LEFT RIGHT ISNUMBER VALUE MID. Split text and numbers. FIND MIN RIGHT LEFT.

Get original number from percent change. Get original price from percentage discount. Get percentage of total. Get profit margin percentage. Get total from percentage.

Value is between two numbers. Volunteer hours requirement calculation. If this page is useful to you, can you please share it? It turns out that your site is my goto site for explanations. As your header says "Quick, clean, and to the point" - Lee. Excel video training Quick, clean, and to the point. Home About Blog Contact Feedback.

Cell contains specific text. Cell contains which things. Cell equals one of many things. Clean and reformat telephone numbers. Convert numbers to text. Convert text to numbers. Count line breaks in cell. Count specific characters in a cell. Count specific characters in a range. Count specific words in a cell. Count specific words in a range. Count total characters in a cell. Count total characters in a range. Count total words in a cell. Count total words in a range.

Add days to date. Add decimal hours to time. Add decimal minutes to time. Add months to date. Add workdays no weekends. Add workdays to date custom weekends. Add years to date. DATE Free download excel 2010 formula book MONTH DAY. Assign points based on late time. Calculate date overlap in days. Calculate elapsed work time. Calculate years between dates. Convert date string to date time. DATEVALUE LEFT MID TIMEVALUE. Convert date to Julian format. Convert date to month and year.

Most frequently occurring number. Normalize size units to Gigabytes. Pad a number with zeros. Random date between two dates.

Count visible rows in a filtered list. Count visible rows only with criteria. COUNTIFS with multiple criteria and OR logic. Group numbers into ranges with COUNTIFS. Running count of occurrence in list. Summary count by month with COUNTIFS. Summary count of non-blank categories. Summary count with COUNTIF. Summary count with percentage breakdown.

Get nth day of week in month. Get nth day of year. Get percent of year complete. Get quarter from free download excel 2010 formula book. Get same date next month. Get same date next year. Get start date based on target date. Get week number from date. Get work hours between dates. Get work hours between dates custom schedule. CHOOSE ROW INDIRECT WEEKDAY SUM. Get workdays between dates. Get year from date. Group times into 3 hour buckets. Group times into unequal buckets.

Win loss points calculation. Highlight 3 smallest free download excel 2010 formula book with criteria. Conditional formatting dates overlap. Conditional formatting gantt chart. Conditional formatting gantt chart weekends. Conditional formatting highlight target percentage. Conditional formatting numbers that include symbols. Conditional formatting unprotected cells.

Convert date to text. Convert decimal hours to Excel time. Convert decimal minutes to Excel time. Convert decimal seconds to Excel time. DATE LEFT MID RIGHT TRIM. Convert text to date. DATE LEFT MID RIGHT. Convert time to time zone. Count birthdays by month. Count day of week between dates. Count holidays between two dates. Count times in a specific range. Create date range from two dates. Date is same month. Date is same month and year. Days until expiration date. Display the current date.

Sum if equal to one of many things. Sum if greater than. Sum if less than. Sum if multiple criteria. Sum if not blank. Sum if one criteria multiple columns. Sum last n columns. Sum top n values. Sum top n values with criteria. Sum visible rows in free download excel 2010 formula book filtered list. SUMIFS with multiple criteria and OR logic.

Series of dates by year. DAY MONTH YEAR DATE. Add a line break with free download excel 2010 formula book formula. Add line break based on OS. Cell contains all of many things. Cell contains one of many things. Cell contains one of many with exclusions. Cell contains some words but not others.

Highlight rows that contain. Highlight rows with blank cells. Highlight rows with dates between. Highlight values greater than. Highlight values not between X and Y. Highlight values that don't exist. Shade alternating groups of n rows. ROW CEILING ISEVEN ISODD. Data validation allow numbers only. Data validation allow text only. Data validation allow uppercase only. Data validation allow weekday only. Data validation contains specific text. Data validation date in next 30 days.

Get first Monday before any date. Get fiscal quarter from date. Get last day of month. Get last weekday in month. Get last working day in month. Get month from date. Get month name from date. Get months between dates. Get most recent day of week. Get next day of week.

Sum if cells contain either x or y. Sum if cells contain specific text. Sum if date is between. Sum if date is greater than. Sum if ends with. Sum if equal to either x or y.

If cell contains one of many things. INDEX and MATCH with multiple criteria. Join tables with INDEX and MATCH. Lookup and sum column. Lookup last file version. Lookup up cost for product or service. Lookup with variable sheet name.

Copy value from every nth row. Count consecutive monthly orders. Count with repeating values. Course completion status summary. Course completion summary with free download excel 2010 formula book. Create array of numbers. Cube root of number. Extract unique items from a list. Fixed value every N months. Flag first duplicate in a list. Flip table rows to columns. Formula with locked reference. Get date associated with last entry. Get pivot table grand total.

Skip to main content. Training Videos Functions Formulas Shortcuts Blog. Count Count cells between dates. Count cells between two numbers. Count cells equal to. Count cells equal to case sensitive. Count cells equal to either x or y. Count cells equal to one of many things. Count cells greater than. Count cells less than. Count cells not equal to. Count cells not equal to many things.

Exact match lookup with INDEX and MATCH. Extract data with helper column. INDEX MATCH AND SUM. Extract multiple matches into separate columns.

Random number between two numbers. Random number from fixed set of options. Random value from list or table. Randomly assign data to groups. Range contains one of many substrings. Range contains one of many values. Range contains specific text. Reverse a list or free download excel 2010 formula book. Search entire worksheet for value. Search multiple worksheets for value. Split payment across months.

Get workbook path only. Indirect free download excel 2010 formula book range different sheet. Create email address from name. Create email address with name and domain. Get domain from email address. Get domain name from URL.

Highlight dates that are weekends. Highlight every other row. ISEVEN ISODD ROW MOD. Highlight multiples of specific value. Highlight row and column intersection free download excel 2010 formula book match.

Get pivot table subtotal. Get pivot table subtotal grouped date. Get value of last non-empty cell. Hyperlink to first blank cell. HYPERLINK CELL INDEX MATCH. Hyperlink to first match. Increment a calculation with ROW or COLUMN. Increment a number in a text string. Issue response time calculation. Leave a comment in a formula. Lookup last file revision. Free download excel 2010 formula book ISERROR MAX INDEX IF ROW.

Count cells not equal to x or y. Count cells that are blank. Count cells that are not blank. Count cells that begin with. Count cells that contain either x or y. Count cells that contain errors. Count cells that contain five characters. Count cells that contain negative numbers. Count cells that contain numbers. Count cells that contain odd numbers. Count cells that contain positive numbers. Count cells that contain specific text.

Calculate interest rate for loan. Calculate original loan amount. Calculate payment for a loan. Calculate payment periods for loan. Calculate principal for given period. Get full workbook name and path. Get sheet name only. Get workbook name and path without sheet. Get workbook name only.

Display the current date and time. Extract date from a date and time. Extract time from a date and time. Get age from birthday. Get date from day number. Get day from date. Get day name from date. Get days before a date. Get days between dates. Get days between dates ignoring years. Get days, hours, and minutes between dates. Get days, months, and years between dates. Get first day of month. Get first day of previous month.

Count cells that contain text. Count cells that do not contain. Count cells that do not contain errors. Count cells that end with. Count if row meets internal criteria. Count if row meets multiple internal criteria. Count if two criteria match. Count items in list. Count long numbers without COUNTIF. Count matches between two columns. Count multiple criteria with NOT logic. Count numbers that begin with. Count occurrences in entire workbook. Count rows that contain specific values. Count rows with multiple OR criteria.

Count sold free download excel 2010 formula book remaining. Count total matches in two ranges. Count unique numeric values in a range. Count unique numeric values with criteria. Count unique text values in a range. Count unique text values with criteria. FREQUENCY MATCH ROW SUM. Count unique values in a range with COUNTIF.

Partial match with VLOOKUP. Position of first partial match. Position of max value in list. Related info for max value in range. Sum lookup values using SUMIF. Sum range with INDEX. Two-way lookup with INDEX and MATCH. Two-way lookup with VLOOKUP. VLOOKUP from another sheet. VLOOKUP from another workbook. VLOOKUP with 2 lookup tables. VLOOKUP with multiple critiera. VLOOKUP with numbers and text. VLOOKUP with two client rates.

INDEX SMALL IFERROR ROW COLUMNS. Extract multiple matches into separate rows. INDEX SMALL IFERROR ROW ROWS. Faster VLOOKUP with 2 VLOOKUPS. Find lowest n values. First match in range with wildcard. Get address of lookup result. Get employee information with VLOOKUP. Get first match cell contains. Get first non-blank value in a list. Get first text value in a list. Get first text value with HLOOKUP. INDEX MATCH MAX ROW.

Time difference in hours as decimal value. Total hours that fall between two times. Year is a leap year. Series of dates by day. Series of dates by month. DAY MONTH YEAR DATE EOMONTH. Series of dates by weekends. Series of dates by workdays.