in this tutorial we’ll discuss how to easily unhide a row or column in a worksheet when you have multiple ones hidden, and you don’t want to have to unhide the entire group to see a single row or column.
Tag Archives | Rows
In this tutorial I’ve created a formula that can retrieve a list of items, repeat that list, and automatically adjust if items are added to or deleted from that list. You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner. […]
This video will take you through the steps of creating a chart that dynamically changes based on the selection you make from a Data Validation drop down list. We’ll use various functions including INDEX, MATCH, COLUMNS, and ROWS.
Previously I did a post to convert a data range to a single column. In this video I will do the opposite – convert a single column into a data range or table. We will use the OFFSET, ROWS, and COLUMNS functions in the process.
Here is how you can take a list and create a formula to repeat the items in that list the given number of times you specify. We will use the IFERROR, ROUNDUP, INDEX and ROWS functions in the process.
Here is an alternative way to re-order your rows and column in your PivotTables in Excel…..