Forum Discussion
Distinct Count With IF condition
Hi I have a list of Sku that I need to distinct count, that will return the number of times that a Sku appears in the column. So that an if condition can then be put in place so that if it appears mo...
Hi Anonymous ,
What conditions are your counts based on?No idea what you are looking for, it is a bit confusing.
The results in your picture cannot be achieved. You need to be based on the context of other columns to get similar results.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sample of Data is below. Its the SKu column I need distinct counting to get the output Ive already posted.
Thanks