When creating a complex formula sometimes you use multiple cells to get to a desired result. Then at the end you may want to join all those cells into one large formula. You can do this by copying formulas to replace the cell references but it's not ...
The purpose of this function is to act as multiple vlookups to pull all data that has multiple matches, and allows the user to specify how they want the data delimitedThe function is called EXTRACTALL and it has four arguments:Argument 1: Looup Field ...
In this post I have attached a simple calendar template that will allow you to generate a new calendar by just changing the month name or year. In addition there is an empty space for each day that by default tracks cash flows (from the data tab). Yo ...
TEMPLATE - AR STATEMENT This is a template designed for creating customer statements from invoice and customer data. Some accounting software (specifically some ERPs) are not the most user-friendly and creating an easy-to-use statement that is cus ...
A couple quick snippets of VBA code that can help you impress your friends although might not have much real utility.First up: have Excel speak to youApplication.speech.speak "text"Where text is what you want Excel to say. Just like with any other co ...
When copying data into Excel from other sources - be it web pages, documents, or other Excel documents sometimes you end up with unwanted formatting, such as numbers with invisible spaces that prevents it as being read as a number or converted into o ...
When working with a pivot table, you determine a data source to use for that table. But what if later you add rows or columns? You'll normally have to change the data source to include the updated range, otherwise your pivot table isn't including you ...
In my previous post I showed a function that can help pull a certain instance of a day of the week using VBA. In this post, I'll show how to do that without VBA. Specifically, three things this post will look at: 1) how to find the first Monday ...
This function is called dayx. It consists of the following arguments: occurrence number, day of the week, month, year. For example:dayx(2,"Monday",10,2014) or dayx(2,1,10,2014) will return the second Monday of October 2014, which is October 13, ...
This function is designed to help clean up a spreadsheet if you want to either delete or hide cells that have 0 or empty values. How this works:I select a range of data that I want to get 0s and blank cells out of (it doesn't have to be a column) and ...
