Розмір відео: 1280 X 720853 X 480640 X 360
Показувати елементи керування програвачем
Автоматичне відтворення
Автоповтор
Thanks for this. Is very useful.
Great Sir
Thank you! Great vid. I am trying to do this: I need to know how many times each of the unique items occurred. Is there a way for =Unique to specify that there were two 20s, and 1 of everything else.? Thanks
Use countif.. =countif(unique(A2:A5),"20")
thanks i freaking need this @@sgari1974
Or use Google sheets, which has a countunique formula option - when is Excel going to get this?
Why are you not Uploading Brother ?
How to use countif added to above formula
Countif(Unique(A2:A5),"20")
not useful
20 is duplicate not unique
The first 20 is unique. Depends on how you want to categorize/count.
Thanks for this. Is very useful.
Great Sir
Thank you! Great vid. I am trying to do this: I need to know how many times each of the unique items occurred. Is there a way for =Unique to specify that there were two 20s, and 1 of everything else.? Thanks
Use countif.. =countif(unique(A2:A5),"20")
thanks i freaking need this @@sgari1974
Or use Google sheets, which has a countunique formula option - when is Excel going to get this?
Why are you not Uploading Brother ?
How to use countif added to above formula
Countif(Unique(A2:A5),"20")
not useful
20 is duplicate not unique
The first 20 is unique. Depends on how you want to categorize/count.