How the Large Formula Can Be The Secret Ingredient To Your Dashboard Preparation
The large formula is an excellent tool that I haven’t really used that much until just recently. The beauty about it is that you can search through a large set of data, and identify the first, second, third, fourth …..Nth largest number/value in any given data set for a column/field. When I started to really think about this, I realized that this could be a great tool (perhaps even the secret ingredient) to building detailed dashboards showing the top 3, 5 or 10 records for pretty much any data set that you could think of. In this post, you are going to use the large formula first to identify the top 3 records of your entire data set, then you’ll use the index formula in combination with the match formula to identify the corresponding values that will make up your entire record. We will then have a look at how you can find the top 3 records based on a certain criteria within your data set. Here you will also use the index match formula using multiple criteria to get your corresponding values to complete each of the top 3 records.