Find out how you can use the new Excel BYROW and BYCOL functions. These are called Lambda helper functions and they can help you save a lot of time if your analysis is based on a whole row or an entire column. Check out this practical example to find out more.
There is a trick you can use to create multiple dependent drop-down lists on the same sheet in Google sheets. It's simple trick that doesn't involve Apps Script. Check out the full article.
Learn to create a simple searchable drop-down list in Excel on multiple rows. Searchable lists make it easier to find an item from a large data validation list. We finally get to make this with simple formulas.
Switch Data in Columns to Rows Transpose or Unpivot (Some) Fields This will be another tutorial on transposing horizontal data into vertical data. But this technique has a twist. No, wait! TWO twists! Twist 1: we don’t want to change ALL the
Excel HACK: Change HORIZONTAL Data to VERTICAL (NO Transpose Function needed) Efficiency is a key objective here at XelPlus, but sometimes even the best of us miss the mark. In a previous post, we discussed three different ways to transpose data in