Howdee! There may be occasions where you need to perform an action a set number of times when writing code. This is generally called “looping”. The Excel VBA for loop is one of the most useful tools an Excel developer can learn. Being able to...
Howdee folks! VLOOKUP is a great Excel function, but sometimes you need a little more flexibility than it provides. That’s where nesting the MATCH formula inside the INDEX (also known as the index match excel function) formula can shine. It also has the added benefit...
Howdee! I can’t believe it’s finally here. This blog has been a long time coming for me. For the longest time after deciding to start an Excel blog I struggled with choosing a topic that would attract and interest readers. Which topic from my list...
Howdee! Do you ever find yourself wishing “if only there were a function in Excel like this, I could do that”? Then this write-up is for you. Creating a custom excel function can help reduce the reliance on having multiple calculated columns or, what I...
Howdee! One of the most useful pieces of code I ever learned was the ability to loop through files in a folder with Excel VBA and pull data from those files (check out the video if that's more your thing). If you’re an analyst, I’m...
 |
Tickets |