Index and Match are a powerful method to look-up data from a table, in a similar way to a VLOOKUP or its sibling formula, HLOOKUP. Using INDEX and MATCH together allows you to look-up data in a more flexible manner, and in a way that prevents the breaking of formulae…Keep reading
Open VBA, create a new module, and create a new function as follows. This gives you access to a function in the Excel front-end called Alphabetise, that takes the number to convert as its argument. It converts from A to AZ.Keep reading
Do you get regular data files that you need to consolidate/compile together for a report or dashboard? This method will help you keep your reporting files lightweight and portable, while making updating their data as easy as pressing Refresh. The basics can be done in five easy steps. For our…Keep reading
Something went wrong. Please refresh the page and/or try again.