NON-NUMERIC CHARACTERS in Excel

NON-NUMERIC CHARACTERS in Excel

How to STRIP NON-NUMERIC CHARACTERS in Excel There is a string of formulas that can be written to strip out only the non-numerical values from a cell and only return the numerical values. This is useful in situations where you need to calculate the sum of data...
ROWS FORMULA in Excel

ROWS FORMULA in Excel

How to Use the ROWS FORMULA in Excel The ROWS-formula is used to count the number of rows that are selected in a range. The formula is very simple, just select the array or the table which contains the rows that you want to count within the brackets of the row...
COLUMNS FORMULA in Excel

COLUMNS FORMULA in Excel

How to Use the COLUMNS FORMULA in Excel The columns formula in Excel is used to count the number of columns that are selected in a range. The formula is very simple, just select the array or the table which contains the columns that you want to count within the...
Win/Loss Sparklines Chart in Excel

Win/Loss Sparklines Chart in Excel

How to Use the Win/Loss Sparklines Chart in Excel A win-loss chart shows positive and negative values with different colors in a single cell. The win-loss chart assists with the visualization of trends in data. It shows an upward-facing marker for positive values and...
Table Of Contents With Macro in Excel

Table Of Contents With Macro in Excel

How to Make Table Of Contents With Macro in Excel If you have multiple tabs in a workbook and want to create an easy reference to each of them, a top-level table of contents tab in Excel is appropriate. A table of contents tab has a summary of all the sheets and each...