Re: FW: $$Excel-Macros$$ Re: Need expert advise for multipal Selection

Find below link for solution: http://www.excelfox.com/forum/f2/need-array-formula-help-912/ On Thursday, 18 April 2013 10:50:04 UTC+5:30, Dhaval Shah wrote: > > > > Hello Lalitji, > > Thanks for you formula > sir i modified with formula littel bit now its not working actually while > i run fo

Re: $$Excel-Macros$$ Re: Need expert advise for multipal Selection

Copy this code and run it and get the output. After getting expected result please check what you were doing manually which is not giving you correct output. and sorry for not sharing file with you. Hope you understand: *Sub ApplyFormula()* * * *With ThisWorkbook.Worksheets(1)* *.Ran

Re: $$Excel-Macros$$ Re: Need expert advise for multipal Selection

yes sir me applied with CSE but ... if u have sheet pls mail me On Wed, Apr 3, 2013 at 12:42 PM, Lalit Mohan Pandey < mohan.pande...@gmail.com> wrote: > They all are array forumlas did you applied with Control + Shift + Enter. > Please check. I applied all these formulas in your attached wor

Re: $$Excel-Macros$$ Re: Need expert advise for multipal Selection

They all are array forumlas did you applied with Control + Shift + Enter. Please check. I applied all these formulas in your attached workbook and its working. On Wednesday, 3 April 2013 12:39:39 UTC+5:30, Dhaval Shah wrote: > > Lalit Sir > > didt work can u send me the sample file > > Thanks

Re: $$Excel-Macros$$ Re: Need expert advise for multipal Selection

Lalit Sir didt work can u send me the sample file Thanks Dhaval Shah 079 - 40055253 On Wed, Apr 3, 2013 at 12:25 PM, Lalit Mohan Pandey < mohan.pande...@gmail.com> wrote: > Hi Dhaval, > > Copy below formula at cell address C11 and confirm it with CSE > *=MAX(($B$2:$B$68=$S$10)*($A$2:$A$68 = "

Re: $$Excel-Macros$$ Re: Need expert advise for multipal Selection

Hi Dhaval, Copy below formula at cell address C11 and confirm it with CSE *=MAX(($B$2:$B$68=$S$10)*($A$2:$A$68 = "FUTSTK")*$I$2:$I$68)* * * Select cell R14:R19, press F2 and paste below formuls and confirm it with CSE *=IFERROR(INDEX($B$1:$N$68,IFERROR(SMALL(IFERROR(INT(SUBSTITUTE(($D$1:$D$68 <=

Re: $$Excel-Macros$$ Re: Need expert advise for multipal Selection

Dear Thanks for u r prompt reply but out put is not as per my requirement pls check the reference sheet On Tue, Apr 2, 2013 at 10:49 AM, xlstime wrote: > Hi Dhaval, > > dhaval shah > (1).xlsx > > PFA... > > >

Re: $$Excel-Macros$$ Re: Need expert advise for multipal Selection

Hi Dhaval, dhaval shah (1).xlsx PFA... . Enjoy Team XLS On Tue, Apr 2, 2013 at 10:39 AM, Dhaval Shah wrote: > cmp is current market price ( CLOSE PRICE ) > > > On Tue, Apr 2, 2013 at

Re: $$Excel-Macros$$ Re: Need expert advise for multipal Selection

cmp is current market price ( CLOSE PRICE ) On Tue, Apr 2, 2013 at 10:18 AM, xlstime wrote: > what is CMP ?... > > you can use sumifs or sumproduct > > > > . > > Enjoy > Team XLS > > > > On Tue, Apr 2, 2013 at 9:56 AM, Dhaval Shah wrote: > >> Hello all experts >> >> any

$$Excel-Macros$$ Re: Need expert advise for multipal Selection

Colud you please elaborate. On Tuesday, 2 April 2013 09:56:37 UTC+5:30, Dhaval Shah wrote: > > Hello all experts > > any solution for my query > > > On Mon, Apr 1, 2013 at 4:37 PM, Dhaval Shah > > wrote: > >> Dear Experts >> >> I want to make out multipul selection for my project pls refer my

Re: $$Excel-Macros$$ Re: Need expert advise for multipal Selection

what is CMP ?... you can use sumifs or sumproduct . Enjoy Team XLS On Tue, Apr 2, 2013 at 9:56 AM, Dhaval Shah wrote: > Hello all experts > > any solution for my query > > > On Mon, Apr 1, 2013 at 4:37 PM, Dhaval Shah wrote: > >> Dear Experts >> >> I want to make o

$$Excel-Macros$$ Re: Need expert advise for multipal Selection

Hello all experts any solution for my query On Mon, Apr 1, 2013 at 4:37 PM, Dhaval Shah wrote: > Dear Experts > > I want to make out multipul selection for my project pls refer my sheet > > > > Thanks > > Dhaval Shah > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? I