Resources
How to find the root of a number
Algebraically, the nth root of a number can be calculated by using 1/n for its power. You can always use caret symbol (^) to find a certain power of a number, but doing this with a formula can be easier to read and identify in nested formula sets. Syntax...
How to find the power of a number
You can always use caret symbol (^) to find a certain power of a number. However, doing this with a formula can be easier to read and identify in nested formula sets. Syntax =POWER(base number, how many times that base number will be multiplied by itself)...
How to find the unique items in a list
Dissecting and organizing data doesn't have to be challenging. You can quickly filter your data items with this method using a combination of formulas to determine which are unique items. Syntax =LOOKUP(2, 1/(COUNTIF(expanding unique list, original...
How to get the column index of a cell using the COLUMN function
Working with Excel's coordinate system makes building data models extremely easy. You can retrieve the column index information of a cell using the COLUMN function and implement in other formulas. Syntax =COLUMN(cell or range reference you want get its...
How to get the row index of a cell using the ROW function
Working with Excel's coordinate system makes building data models extremely easy. You can retrieve the row index information of a cell using the ROW function and implement in other formulas. Syntax =ROW(cell or range reference you want get its row number)...
How to get the first name text from the full name data
One perfect example of automatically cleaning up data in Excel is when working with name fields. You can separate first and last names (or actually any text with spaces) using this method. Syntax =LEFT(Full name, FIND(" ", Full name) – 1) Steps Begin by...
How to calculate payments for a loan
In need of quick money? Well, we can't tell you how to get that, but we can show you how to use Excel to find out what you're getting into. Use this easy method to calculate what you would be paying for that shiny new loan. Syntax =PMT(interest rate for...
How to get the worksheet name, workbook name, and its path
Working across several workbooks with multiple sheets can be tedious. Furthermore, file names are dynamic and can be changed by your users. Use this simple trick to organize your data and label workbook details. Syntax =CELL("filename", reference which is...
How to count the number of characters inside a cell
You can easily count the number of characters inside a cell using the LEN function. This function can be especially useful when identifying data types or creating validation rules. Syntax =LEN(text) Steps Begin by typing in =LEN( Select or type in the...