$$Excel-Macros$$ Re: Unique Data summary problem

Hi Vishvesh http://help.lockergnome.com/office/COUNTIFS-workaround-Excel-2003--ftopict951180.html the above link can help u in getting the countifs workaround for excel 2003 hope it helps Thanks and Regards, V

$$Excel-Macros$$ Re: Unique Data summary problem

Vivek, I understood the problem actually countifs is not there in excel 2003, and any function which is written in 2007 and open in 2003 if it is not there then it shown _xlfn.countifs(...). But when trying to change some it shows #NAME error On Thu, Jul 23, 2009 at 10:25 PM, Vishvesh Chauhan < v

$$Excel-Macros$$ Re: Unique Data summary problem

i think your ver of excel is 2007, could you help me writing same function using sumif(and()), cause i think _xlfn is not there in 2003 On Thu, Jul 23, 2009 at 10:19 PM, vivek agrawal wrote: > depends what formula you are putting... the referencing of cells need to be > taken care of > Thanks

$$Excel-Macros$$ Re: Unique Data summary problem

depends what formula you are putting... the referencing of cells need to be taken care of Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Thu, Jul 23, 2009 at 10:16 PM, Vishvesh Chauhan < vishvesh.chau...@gmail.com> wrote: >

$$Excel-Macros$$ Re: Unique Data summary problem

Vivek, When i'm changing formula, its not again coming and showing an error of #NAME. I have Excel 2003 On Thu, Jul 23, 2009 at 10:07 PM, Vishvesh Chauhan < vishvesh.chau...@gmail.com> wrote: > Hey Vivek, > > I'm really thankful to you for your kind help. May god bless you. > > Regards > > > On

$$Excel-Macros$$ Re: Unique Data summary problem

Hey Vivek, I'm really thankful to you for your kind help. May god bless you. Regards On Thu, Jul 23, 2009 at 10:03 PM, vivek agrawal wrote: > Hi Vishesh > > find the attached file...hope this is what you want > > Thanks and Regards, > Vivek Agrawal > Skype ID - vivek.agrawal83 > > Googl