Excel Formulas Guide
Number Manipulation formulas
- SUM of digits when cell contains all numbers
- SUM of digits when cell contains alphanumeric value
- Count No. of unique values
- Count No. of unique values conditionally
- Count No. of numeric cells
- Extract Integer / Decimal part from a Number
- Roman Representation of Numbers
- Sum Bottom N Values in a Range
- Sum Every Nth Row
- MEDIANIF and MODEIF?
String Manipulation formulas
- Count cells that start / end with a given string
- Count no. of Cells that contain only non numeric values
- No. of characters in a string excluding blanks
- No. of times a character appears in a string
- Count non numeric characters in a string
- Count numeric characters in a string
- Count alphabets in a string
- Most frequently occurring value in a range
- Extract First Name from Full Name
- Extract Last Name from Full Name
- Extract the Initial of Middle Name
- Extract Middle Name from Full Name
- Remove Middle Name in Full Name
- Reverse a String
- Extract alphabets from a string
- Count the number of words in a cell / range
- Extract user name from an e-mail id
- Extract domain name from an e-mail id
- Location of first number in a string
- Location of last number in a string
Date Manipulation formulas
- Add/Subtract month from a given date
- Add/Subtract year from a given date
- Convert a Number to a Month Name
- Convert Date to a Calendar Quarter
- Convert Date to a Indian Financial Year Quarter
- Calculate Age from Given Birthday
- Number to Date Format Conversion
- Number to Time Format Conversion
- First Day of the Month for a Given Date
- Count any day of the week between 2 dates (e.g Monday)
- Find next week of a given day
- Find previous week of a given day
- Find Last day of month for a given date
- Find number of days in a month
- Check if given Year is a Leap Year
- Last working day of the month for a given date
- First working day of the month for a given date
- Date for Nth Day of a given Year
- Extract Date and Time from Date Timestamp
- Get Financial Year
- First Working Day of the Year
- Last Working Day of the Year
- Convert Gregorian Date to Julian Date
- Convert Julian Date to Gregorian Date
Misc Excel Functions
- Validate list of values for uniqueness (Check duplicates)
- COUNTIF on Filtered List
- SUMIF on Filtered List
- Calculate MAX count of consecutive entries of a value
- Get File Name using Formula
- Get Workbook Name using Formula
- Get Sheet Name using Formula
- Get Workbook's Directory using Formula
- Rank within the Groups
- Get Column Name of a Column No.