Often you may want to round a value to a certain number of significant figures in Excel. You can use the following formula to do…

# Author: Zach

Often you may want to sum the values of some dataset in Excel based on a category or group. For example, suppose we have the…

You can use the following formula to find unique values from multiple columns in Excel: =INDIRECT(TEXT(MIN(IF(($A$2:$C$11<>””)*(COUNTIF($E$1:E1,$A$2:$C$11)=0),ROW($2:$11)*100+COLUMN($A:$C),7^8)),”R0C00″),)&”” This particular formula finds the unique values in the…

You can use the following syntax to filter for rows that contain specific text in an Excel Advanced Filter: *sometext* The following examples show how…

You can use the following syntax to filter for rows that do not contain specific text in an Excel Advanced Filter: <>*sometext* The following examples…

The easiest way to filter multiple columns in Excel is to use the Advanced Filter function. The following examples show how to use this function…

You can use the following basic syntax to sum values across multiple sheets in Excel: =SUM(Sheet1!A1, Sheet2!B5, Sheet3!A12, …) The following example shows how to…

The easiest way to take the sum of a filtered range in Excel is to use the following syntax: SUBTOTAL(109, A1:A10) Note that the value…

We can use the following formula to find the ending value of some investment after a certain amount of time: A = P(1 + r/n)nt…

Often you may want to delete certain rows after filtering them in Excel. Fortunately this is easy to do and the following example shows how…