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

2014-09-15 Thread Vaibhav Joshi
Ok, then you got to use this since there is no default formula in excel./ Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Sep 15, 2014 at 12:23 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Ohk but am using 2010. > > On Fri, Sep 12, 201

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

2014-09-14 Thread Chandra Shekar
Ohk but am using 2010. On Fri, Sep 12, 2014 at 9:51 PM, Vaibhav Joshi wrote: > hi > > yes, if you have excel 2013 you can try DISTINCT function, this will > reduce length of formula... > > Cheers!! > > + > *I did not do this for you. God is here working through me for you.* > > On Fri, Sep 1

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

2014-09-12 Thread Vaibhav Joshi
hi yes, if you have excel 2013 you can try DISTINCT function, this will reduce length of formula... Cheers!! + *I did not do this for you. God is here working through me for you.* On Fri, Sep 12, 2014 at 7:53 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Thanks a lot. but its

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

2014-09-12 Thread Chandra Shekar
Thanks a lot. but its there any single formula to do this? Regards, Chandra On Fri, Sep 12, 2014 at 5:31 PM, Ashish Kumar wrote: > Vaibhav Bhai, Its superb. > > > Regards > Ashish > > On 12 September 2014 15:38, Vaibhav Joshi wrote: > >> Chek this.. >> >> Cheers!! >> >> + >> *I did not do

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

2014-09-12 Thread Ashish Kumar
Vaibhav Bhai, Its superb. Regards Ashish On 12 September 2014 15:38, Vaibhav Joshi wrote: > Chek this.. > > Cheers!! > > + > *I did not do this for you. God is here working through me for you.* > > On Fri, Sep 12, 2014 at 2:34 PM, Chandra Shekar < > chandrashekarb@gmail.com> wrote: > >

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

2014-09-12 Thread Vaibhav Joshi
Chek this.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Fri, Sep 12, 2014 at 2:34 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hello, > > How to get unique values based on two conditions. Could you help me in the > attached file. > > Tha