![]() So, the array contains the value ‘2’ in the place where it occurs, and other values occur once. Therefore, the intermediate step resolves as follows: This makes the function count the number of times a value appears in this range. The COUNTIF() has two parameters, a range of values (A2:A7) supplied twice. Following it, “1/” and the SUM() are executed. The COUNTIF() is executed first as it is the innermost function. The formula = SUM(IF(FREQUENCY(A2:A7, A2:A7)>0,1)) then proceeds to display the sum of the values returned by frequency(). ![]() For the next subsequent occurrence of the same number, it returns a zero. For the first occurrence of the number, this function returns a number 1. In the above table, the frequency of occurrence of Emp_ID is found. The function frequency () works on numeric values only. ![]() The execution starts from the inner function: frequency.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |