Dear All, I am facing a problem with how to get CountIFS without duplicate,
example:
04/Mar/15 RV1503-0001
04/Mar/15 RV1503-0002
04/Mar/15 RV1503-0003
04/Mar/15 RV1503-0004
04/Jan/15 RV1503-0005
05/Mar/15 RV1503-0006
06/Mar/15 RV1503-0007
04/Jan/15 RV1503-0008
04/Jan/15 RV1503-0009
04/Mar/15 RV1503-0010
04/Mar/15 RV1503-0011
04/Mar/15 RV1503-0011
04/Mar/15 RV1503-0011
04/Mar/15 RV1503-0011
04/Mar/15 RV1503-0011
04/Mar/15 RV1503-0011
04/Mar/15 RV1503-0011
first Criteria is the date within the month of H1
and to count those in col D with "*RV*"
I can do half way. those duplicate one have no idea... ... ...
thank you so much for your kindly help
2) CountIFS without duplicate.xlsb
Please refer to file attached.
Bookmarks