Re: FW: $$Excel-Macros$$ resolve the problem

2012-08-27 Thread NOORAIN ANSARI
gt; > *To:* excel-macros@googlegroups.com > *Subject:* Re: FW: $$Excel-Macros$$ resolve the problem > > ** ** > > Dear Neeraj, > > Try below formula : > > > =IF(COUNTIF($C$2:C2,C2)=1,LARGE(IF($C$2:$C$1006=C2,$D$2:$D$1006),1)-SMALL(IF($C$2:$C$1006=C2,$D$2:$D$1006),1),&q

RE: FW: $$Excel-Macros$$ resolve the problem

2012-08-27 Thread Neeraj
Thanks noorain. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Monday, August 27, 2012 5:07 PM To: excel-macros@googlegroups.com Subject: Re: FW: $$Excel-Macros$$ resolve the problem Dear Neeraj, Try below formula : =IF

RE: FW: $$Excel-Macros$$ resolve the problem

2012-08-27 Thread Neeraj
Dear noorain, I don't want to change the colum min and mix. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Monday, August 27, 2012 4:04 PM To: excel-macros@googlegroups.com Subject: Re: FW: $$Excel-Macros$$ resolve the pr

Re: FW: $$Excel-Macros$$ resolve the problem

2012-08-27 Thread amar takale
Noorin sir Can y send me this file in excel 2003 On Mon, Aug 27, 2012 at 4:03 PM, NOORAIN ANSARI wrote: > Dear Neeraj, > > See attached sheet, Hope it will help to you. > > > On Mon, Aug 27, 2012 at 3:23 PM, Neeraj wrote: > >> ** ** >> >> ** ** >> >> *From:* excel-macros@googlegroups.com [mailto