Re: $$Excel-Macros$$ Multiple Criteria issue formula

2013-03-21 Thread amar takale
Thanks for suggestion Dear xlstime.But descending & Ascending issue remaining at final stage. On Thu, Mar 21, 2013 at 10:38 PM, xlstime wrote: > change ur formula dear > > include iferror function and enjoy > > > > . > > Enjoy > Team XLS > > > > On Thu, Mar 21, 2013 at 5:

Re: $$Excel-Macros$$ Multiple Criteria issue formula

2013-03-21 Thread xlstime
change ur formula dear include iferror function and enjoy . Enjoy Team XLS On Thu, Mar 21, 2013 at 5:51 PM, amar takale wrote: > Dear Xlstime > > I use formula in column P=IF(OR(ISERROR(N2/(M2-N2))),"0",N2/(M2-N2)) & > remove #DIV/0! Error So now there is only

Re: $$Excel-Macros$$ Multiple Criteria issue formula

2013-03-21 Thread amar takale
Dear Xlstime I use formula in column P=IF(OR(ISERROR(N2/(M2-N2))),"0",N2/(M2-N2)) & remove #DIV/0! Error So now there is only issue that how to descending & Ascending order output data automatically. If there are no way then sheet paste special value & then do descending & Ascending order outp

Re: $$Excel-Macros$$ Multiple Criteria issue formula

2013-03-21 Thread xlstime
why? try macro recording using find replace function or Google it . Enjoy Team XLS On Thu, Mar 21, 2013 at 4:01 PM, amar takale wrote: > Dear Sir > > Can anyone give me VBA code to remove #DIV/0! Error from Specific column > > Regards > Amar > > > On Thu, Mar 21,

Re: $$Excel-Macros$$ Multiple Criteria issue formula

2013-03-21 Thread amar takale
Dear Sir Can anyone give me VBA code to remove #DIV/0! Error from Specific column Regards Amar On Thu, Mar 21, 2013 at 3:59 PM, amar takale wrote: > Dear MS Excel, > > Mind Freaking Sir !!! Awesome!!! > > I got answer which I want,you are great Sir.Thanks very much... > > > But I have

Re: $$Excel-Macros$$ Multiple Criteria issue formula

2013-03-19 Thread xlstime
I think its done with using index, match and small/large function .if i am not wrong please try below link http://excel.bigresource.com/Using-INDEX-MATCH-with-MAX-and-LARGE-lymO5ySE.html#FK94kfmd . Enjoy Team XLS On Wed, Mar 20, 2013 at 10:23 AM, amar takal

Re: $$Excel-Macros$$ Multiple Criteria issue formula

2013-03-19 Thread xlstime
Hi Amar, still not clear... can you please give me example ? . Enjoy Team XLS On Tue, Mar 19, 2013 at 6:04 PM, amar takale wrote: > Dear David, > First Thanks for reply.Actually I need to Extract Bank Nifty-OPEN_INT > (More than 5).there are 13 cell which is mor

Re: $$Excel-Macros$$ Multiple Criteria issue formula

2013-03-19 Thread amar takale
Dear David, First Thanks for reply.Actually I need to Extract Bank Nifty-OPEN_INT (More than 5).there are 13 cell which is more than 5. Regards Amar On Tue, Mar 19, 2013 at 5:31 PM, David Grugeon wrote: > I cannot understand your question. you will have to be much more > explicit. If y

Re: $$Excel-Macros$$ Multiple Criteria issue formula

2013-03-19 Thread David Grugeon
I cannot understand your question. you will have to be much more explicit. If you cannot explain in English, perhaps you know someone who can help you. Please put the explanation in the body of the email, not in a spreadsheet. Regards David Grugeon On 19 March 2013 21:40, amar takale wrote:

Re: $$Excel-Macros$$ Multiple Criteria issue formula

2013-03-19 Thread amar takale
Dear All, Pls Can anybody solve my issue? On Tue, Mar 19, 2013 at 1:27 PM, amar takale wrote: > Dear All > Pls see Sheet (Sample Sheet+1) I used Sumproduct formula in K 32 cell but > I want to modified it to search only that value not sum.If experts help me > then my issue will be solved.Pls see