paramnayak
Member
dear all,
I want to count the unique values satisfying 2 critera.
eg
ref no date item
2 01-02-2016 abc
3 01-02-2016 xyz
7 02-02-2016 abc
2 04-03-2016 abc
2 04-03-2016 xyz
7 05-03-2016 abc
3 07-03-2016 xyz
here ref no. and date should be unique . so total should be 6. I want to get the result with one formula.
thanks and rgds
I want to count the unique values satisfying 2 critera.
eg
ref no date item
2 01-02-2016 abc
3 01-02-2016 xyz
7 02-02-2016 abc
2 04-03-2016 abc
2 04-03-2016 xyz
7 05-03-2016 abc
3 07-03-2016 xyz
here ref no. and date should be unique . so total should be 6. I want to get the result with one formula.
thanks and rgds