Hi all,
I'm having trouble with a formula which needs to return a count of unique names found in one column for each unique combination of number and date found in two other columns. Hopefully this example explains it a bit better:
So for the combination of 123 and 01/01/2000, there is one unique name in the Names column and a value of 1 is returned, but for the combination of 456 and 03/03/2000, there are three unique names in the names column and a value of 3 is returned.
My actual dataset is a few thousand rows and I would now be able to specify actual values of number or date in a formula.
Could anyone help?
Thank you,
I'm having trouble with a formula which needs to return a count of unique names found in one column for each unique combination of number and date found in two other columns. Hopefully this example explains it a bit better:
So for the combination of 123 and 01/01/2000, there is one unique name in the Names column and a value of 1 is returned, but for the combination of 456 and 03/03/2000, there are three unique names in the names column and a value of 3 is returned.
My actual dataset is a few thousand rows and I would now be able to specify actual values of number or date in a formula.
Could anyone help?
Thank you,