Subscribe to:
Post Comments (Atom)
skip to main |
skip to sidebar
Excel Tips and Formulas
Look down for more.
- Get sum of values in a range.
- Get total value of a row based on condition/criteria
- Sum based on a string in another cell
- Sum based on a condition from another column
- Sum of top three numbers in a range
- Sum of least three numbers in range of cell.
- Sum formula with multiple criteria.
- Counting of nonblank cells
- Counting of blank cells in range
- Counting of cells with numeric value:
- Counting of cells with text alone
- Counting a repeated text in a range of cells
- Counting part of text that meets the criteria
- Counting of values that’s greater than a value
- Counting cells with values between two ranges.
- Counting smaller values that’s small than the given value:
- Counting values by verifying two cells in excel
- Counting of characters in a cell
- Counting of characters in a cell excluding spaces
- Counting repeated times of single character
- Convert a date into text in date format
- Counting number of entries, separated by a character in a cell
- Counting of Data between two dates
- Find duplicate entry in a range of cells in excel
- Comparing two columns and finding duplicates
- Extract Charecters from Left of a text:
- Extract characters from right of a text
- Extracting a text in a sentence
- Combining two texts on two cells into one cell
- Merging two cells in a simple way
- Convert a date into text in date format
- Extracting a type of text in a range of cells
- Extracting a type of text in a range of cells
- Extracting a text in simple way
- Replace a particular character in a text
- Find day of a Date
Hamster
No comments:
Post a Comment