- Home
- ROW
FORMULA TO GET LAST ROW NUMBER
In Excel, you can write a formula to get the last row number containing data. At first, it’s not an obvious formula, but using Excel’s own logic and lookup function can give you the answer. When i was first asked by somebody for a formula to get the last row number I almost immediately saw […]
Continue readingHow To Auto Fill Sequential Letters in Excel Video
To date, the blog post “How to auto fill sequential letters in Excel” is my most searched post (click here to read how to auto fill sequential letters in excel). For this reason I thought it was worthwhile creating a video breaking down the formula. As well as the formula itself, I also often get […]
Continue readingVLookup with multiple values
So, you can use a VLookUp to retrieve a piece of information. You can use SumIf to total a range based on criteria and you can use CountIf to count how many times criteria appears. What do you do though when you have to create a VLookUp with multiple values? The VLookUp will run through […]
Continue readingHow to auto fill sequential letters in Excel
This week I was asked how to auto-fill sequential letters in Excel. What do I mean by this? If you type 1 in a cell and drag it down Excel can populate the cells with sequential numbers (2, 3, 4, 5, 6, 7, 8, etc). A user needed a list of sequential letters (a, b, […]
Continue reading