I got an e-mail today from my wife who is a big cat lover. She says YouTube suggested her to watch the „Cat Icon Array Chart“ video. And since there is often a need to show the share of a value in a whole, using icon array chart, I decided to write a “recipe” that would teach you how to present data this way, without really using charts.
Each cell in the worksheet can be blank or have some content (text, number). It can also have its own formatting elements. The CELL function allows you to read the attributes of a cell, however it is not nearly as powerful as the old GET.CELL macro function. In the following text, you will learn how to read cell attributes.
Fixing cell addresses is an old topic. However, when you create a structured table (data table) and try to copy a formula that points to a cell inside it, the rules of the game change. That is, the address will not be updated as desired. These addresses can also be fixed, and in the text that follows you will learn how to do this.
The FREQUENCY function is used to calculate how often certain values in a given range are repeated. This is an array function, and we can use it to calculate a distribution by which we can see how many points students have scored on a test and for other similar statistical analyzes. To help you understand how the function works will also illustrate this with a simple chart …
One of the earlier posts referred to date hierarchies, a relatively new functionality that allows the month, quarter, or year to be automatically created based on a column containing a date (depending on the data that column contains). This can cause a problem with previous reports that contain dates, and the user wants to see them as originally created. How to solve this?