"In a blog post, explain how to find the most repeated value in the range (the fashion). What I need is, and know the value, how many times it is repeated. "
The post to which you refer is most frequent value calculation (MODA) for a Range . To address your question we will use the functions CONTAR.SI and FASHION. We start from the following example that shows the ratings obtained in surveys of four shops:
We are located in cell B17 and type the following formula:
= CONTAR.SI (B4: B15; FASHION (B4: B15))
Thus what we doing is using as a criterion to count the value of fashion, ie to count how many times you repeat the mode value in the range B4: B15. In our example we only copy the formula would be introduced into B17 in the range C17: E17.
If you also want to have available the value of fashion if we can write the formula B19:
= MODA (B4: B15) and copy the formula in the range C19: E19
As you can see, the value of surveys Fashion Shop 1 is 2 and this value is repeated 4 times.
0 comments:
Post a Comment