DGET is a straightforward lookup function designed to retrieve a single value from a column in a table or database. It's ...

If you regularly work with data sets in Excel, you know how important it is to be able to quickly find the information you ...

Excel's PIVOTBY function allows you to group your figures without needing to recreate your data in a PivotTable. What's more, ...

You can’t use it to split values based on a conditional value in a second column. Instead, we’ll use two IF() functions, one for debit and one for credit. The IF() function uses the following ...

Excel ROW function will return the row number of a reference. ROWS will return the number of rows in a column. Learn how to use the Row and Rows function in Excel.

The TEXTSPLIT() function is a new feature that is available only in Excel for Microsoft 365 and Excel for the web. If you have other editions of MS Excel, you can use the Text to Column wizard to ...

How to freeze multiple rows and columns in Excel. You can freeze multiple rows by selecting a cell below the row you want to be fixed in place. The same applies to multiple columns – select the ...

How to use Excel’s AGGREGATE Function. This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel. By Kelly L. Williams, CPA, Ph.D. April 1, 2025. Related. July 16, 2025 ...