Sometimes, we want to find the occurrences of a specific character in a word. Instead of counting it manually, we can use the Excel COUNTCHAR… Read More »Formula to Count Occurrences of a Character in a String in Excel!
The maximum value is the largest number of a set of values. Sometimes, we want to get the largest value from the list, it can be… Read More »Formulas to Find Maximum Value with Multiple Criteria in Excel!
Excel has a RANK function, so you can calculate the rank of each number that stands in a list in your spreadsheet. Instead of using… Read More »Formulas to Rank Items with One or more Criteria in Excel!
Sometimes you need to sum values in columns based on adjacent criteria in a range, What would you do? We suggest you use the formula… Read More »Formulas to Sum Columns based on Adjacent Criteria in Excel!
In Excel, how could we count the cells with multiple criteria? There is a formula with the COUNTIF function in Excel. By applying it to… Read More »Formulas to Count Cells with Multiple OR Criteria in Excel!
In Excel, how could we extract the content from a specified row and column? There is a formula with INDIRECT and ADDRESS functions in Excel.… Read More »Formulas to Get Content of Given Row & Column in Excel!