Resources
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...
How to search for a string or check if cell contains a specific text
Excel's Search and Find feature is very helpful when looking up things in workbooks, but this means searching for keywords one by one. SEARCH and FIND are formula versions of this very handy feature and can work wonders in large data sets. Syntax...
How to use day information from date data in Excel
Working with dates in Excel can be a bit challenging at times, because Excel doesn't use dates as we conceive it. Knowing how Excel handles dates, you will find it pretty easy to use them in calculations and reports. Syntax =date + days Steps Select or...