How to use Offset in a table
Need to find a value in a large table and you know only the label of the row and column where the target is located? No problem, Excel can help you do it with only two formulas: Offset and Match. Take a look in the picture bellow. You will find out how to do it. […]
SunSystems Custom VBA Reports
Are you wondering if there is some possibility to extract information from SunSystems database that allow for decisions to be taken without having to ask employees to process the data before presenting it in a standard or custom reporting template? The answer is YES, there is a solution for this and it is called VBA […]