Re: $$Excel-Macros$$ Re: Unique values based on two conditions

2014-09-15 Thread Vaibhav Joshi
Hi, This formula will fail to give correct result when you are matching criterion for diff months.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Sep 15, 2014 at 4:41 PM, Mandeep Baluja wrote: > Use this if you have data for this month only small

$$Excel-Macros$$ Re: Unique values based on two conditions

2014-09-15 Thread Mandeep Baluja
Use this if you have data for this month only small and simple =SUMPRODUCT(--((DAY($B$2:$B$15)=DAY(D2 Regards, Mandeep baluja On Friday, September 12, 2014 2:34:42 PM UTC+5:30, Chandru wrote: > > Hello, > > How to get unique values based on two conditions. Could you help me in the