Hello,I want to count a value in a range but it should count it in serial number order. How I can do that?For Example:Value Range is A2:A9 and it (Count) should appear as in
I want to count a value in a range but it should count it in serial ...
To protect your account and its contents, neither Microsoft moderators here in the Community, nor our support agents are allowed to send password reset links or access and change account details. We recommend checking out the following resources for help in regaining access to your account:
Hi I have this formula but dont give me right values =SORT (FILTER (CHOOSECOLS (EJ8:ER5000, {1,2,4,5,8,7}), (COUNTIF (M8:M180,EK8:EK5000)=1)* (COUNTIF (U8:U150,EQ8:EQ5000)<=1)),2,1) It should be a countifs but first countif is =1 and second countid should be <= Can you give hand please