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 =$S$11)*($E$1:$E$68 = $R$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),1),)* Select cell S14:S19, 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 =$S$11)*($E$1:$E$68 = $R$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),3),)* Select cell T14:T19, 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 =$S$11)*($E$1:$E$68 = $R$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),4),)* Select cell U14:U19, 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 =$S$11)*($E$1:$E$68 = $R$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),12),)* Select cell V14:V19, 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=$S$11)*($E$1:$E$68=$R$13)*($M$1:$M$680),0,))*ROW($A$1:$A$68),),ROW($A$1:$A$68)),),13),) * Select cell W14:W19, 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 =$S$11)*($E$1:$E$68 = $W$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),1),)* Select cell X14:X19, 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 =$S$11)*($E$1:$E$68 = $W$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),3),)* Select cell Y14:Y19, 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 =$S$11)*($E$1:$E$68 = $W$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),4),)* Select cell Z14:Z19, 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 =$S$11)*($E$1:$E$68 = $W$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),12),)* Select cell AA14:AA19, 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=$S$11)*($E$1:$E$68=$W$13)*($M$1:$M$680),0,))*ROW($A$1:$A$68),),ROW($A$1:$A$68)),),13),) * Hope it will give you the same you expact. On Tuesday, 2 April 2013 12:53:21 UTC+5:30, Dhaval Shah wrote: 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 xls...@gmail.com javascript:wrote: Hi Dhaval, dhaval shah (1).xlsxhttps://docs.google.com/file/d/0B4LBSzxr1QTiVjZoYkRneFFUY1k/edit?usp=drive_web PFA... . Enjoy Team XLS On Tue, Apr 2, 2013 at 10:39 AM, Dhaval Shah todhav...@gmail.comjavascript: wrote: cmp is current market price ( CLOSE PRICE ) On Tue, Apr 2, 2013 at 10:18 AM, xlstime xls...@gmail.com javascript: wrote: what is CMP ?... you can use sumifs or sumproduct . Enjoy Team XLS On Tue, Apr 2, 2013 at 9:56 AM, Dhaval Shah todhav...@gmail.comjavascript: wrote: Hello all experts any solution for my query On Mon, Apr 1, 2013 at 4:37 PM, Dhaval Shah todhav...@gmail.comjavascript: 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? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com javascript:. To post to this group, send email to excel-...@googlegroups.comjavascript: . Visit this group at
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 = 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 =$S$11)*($E$1:$E$68 = $R$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),1),)* Select cell S14:S19, 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 =$S$11)*($E$1:$E$68 = $R$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),3),)* Select cell T14:T19, 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 =$S$11)*($E$1:$E$68 = $R$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),4),)* Select cell U14:U19, 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 =$S$11)*($E$1:$E$68 = $R$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),12),)* Select cell V14:V19, 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=$S$11)*($E$1:$E$68=$R$13)*($M$1:$M$680),0,))*ROW($A$1:$A$68),),ROW($A$1:$A$68)),),13),) * Select cell W14:W19, 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 =$S$11)*($E$1:$E$68 = $W$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),1),)* Select cell X14:X19, 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 =$S$11)*($E$1:$E$68 = $W$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),3),)* Select cell Y14:Y19, 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 =$S$11)*($E$1:$E$68 = $W$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),4),)* Select cell Z14:Z19, 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 =$S$11)*($E$1:$E$68 = $W$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),12),)* Select cell AA14:AA19, 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=$S$11)*($E$1:$E$68=$W$13)*($M$1:$M$680),0,))*ROW($A$1:$A$68),),ROW($A$1:$A$68)),),13),) * Hope it will give you the same you expact. On Tuesday, 2 April 2013 12:53:21 UTC+5:30, Dhaval Shah wrote: 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 xls...@gmail.com wrote: Hi Dhaval, dhaval shah (1).xlsxhttps://docs.google.com/file/d/0B4LBSzxr1QTiVjZoYkRneFFUY1k/edit?usp=drive_web PFA... . Enjoy Team XLS On Tue, Apr 2, 2013 at 10:39 AM, Dhaval Shah todhav...@gmail.comwrote: cmp is current market price ( CLOSE PRICE ) On Tue, Apr 2, 2013 at 10:18 AM, xlstime xls...@gmail.com wrote: what is CMP ?... you can use sumifs or sumproduct . Enjoy Team XLS On Tue, Apr 2, 2013 at 9:56 AM, Dhaval Shah todhav...@gmail.comwrote: Hello all experts any solution for my query On Mon, Apr 1, 2013 at 4:37 PM, Dhaval Shah todhav...@gmail.comwrote: 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? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/**discussexcelhttps://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to
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 Dhaval Shah 079 - 40055253 On Wed, Apr 3, 2013 at 12:25 PM, Lalit Mohan Pandey mohan.p...@gmail.comjavascript: 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 = 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 =$S$11)*($E$1:$E$68 = $R$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),1),)* Select cell S14:S19, 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 =$S$11)*($E$1:$E$68 = $R$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),3),)* Select cell T14:T19, 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 =$S$11)*($E$1:$E$68 = $R$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),4),)* Select cell U14:U19, 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 =$S$11)*($E$1:$E$68 = $R$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),12),)* Select cell V14:V19, 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=$S$11)*($E$1:$E$68=$R$13)*($M$1:$M$680),0,))*ROW($A$1:$A$68),),ROW($A$1:$A$68)),),13),) * Select cell W14:W19, 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 =$S$11)*($E$1:$E$68 = $W$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),1),)* Select cell X14:X19, 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 =$S$11)*($E$1:$E$68 = $W$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),3),)* Select cell Y14:Y19, 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 =$S$11)*($E$1:$E$68 = $W$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),4),)* Select cell Z14:Z19, 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 =$S$11)*($E$1:$E$68 = $W$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),12),)* Select cell AA14:AA19, 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=$S$11)*($E$1:$E$68=$W$13)*($M$1:$M$680),0,))*ROW($A$1:$A$68),),ROW($A$1:$A$68)),),13),) * Hope it will give you the same you expact. On Tuesday, 2 April 2013 12:53:21 UTC+5:30, Dhaval Shah wrote: 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 xls...@gmail.com wrote: Hi Dhaval, dhaval shah (1).xlsxhttps://docs.google.com/file/d/0B4LBSzxr1QTiVjZoYkRneFFUY1k/edit?usp=drive_web PFA... . Enjoy Team XLS On Tue, Apr 2, 2013 at 10:39 AM, Dhaval Shah todhav...@gmail.comwrote: cmp is current market price ( CLOSE PRICE ) On Tue, Apr 2, 2013 at 10:18 AM, xlstime xls...@gmail.com wrote: what is CMP ?... you can use sumifs or sumproduct . Enjoy Team XLS On Tue, Apr 2, 2013 at 9:56 AM, Dhaval Shah todhav...@gmail.comwrote: Hello all experts any solution for my query On Mon, Apr 1, 2013 at 4:37 PM, Dhaval Shah todhav...@gmail.comwrote: 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? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/**discussexcelhttps://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a
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 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 Dhaval Shah 079 - 40055253 On Wed, Apr 3, 2013 at 12:25 PM, Lalit Mohan Pandey mohan.p...@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 = 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 =$S$11)*($E$1:$E$68 = $R$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),1),)* Select cell S14:S19, 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 =$S$11)*($E$1:$E$68 = $R$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),3),)* Select cell T14:T19, 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 =$S$11)*($E$1:$E$68 = $R$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),4),)* Select cell U14:U19, 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 =$S$11)*($E$1:$E$68 = $R$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),12),)* Select cell V14:V19, 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=$S$11)*($E$1:$E$68=$R$13)*($M$1:$M$ 680),0,))*ROW($A$1:$A$68),),ROW($A$1:$A$68)),),13),)* Select cell W14:W19, 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 =$S$11)*($E$1:$E$68 = $W$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),1),)* Select cell X14:X19, 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 =$S$11)*($E$1:$E$68 = $W$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),3),)* Select cell Y14:Y19, 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 =$S$11)*($E$1:$E$68 = $W$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),4),)* Select cell Z14:Z19, 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 =$S$11)*($E$1:$E$68 = $W$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),12),)* Select cell AA14:AA19, 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=$S$11)*($E$1:$E$68=$W$13)*($M$1:$M$ 680),0,))*ROW($A$1:$A$68),),ROW($A$1:$A$68)),),13),)* Hope it will give you the same you expact. On Tuesday, 2 April 2013 12:53:21 UTC+5:30, Dhaval Shah wrote: 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 xls...@gmail.com wrote: Hi Dhaval, dhaval shah (1).xlsxhttps://docs.google.com/file/d/0B4LBSzxr1QTiVjZoYkRneFFUY1k/edit?usp=drive_web PFA... . Enjoy Team XLS On Tue, Apr 2, 2013 at 10:39 AM, Dhaval Shah todhav...@gmail.comwrote: cmp is current market price ( CLOSE PRICE ) On Tue, Apr 2, 2013 at 10:18 AM, xlstime xls...@gmail.com wrote: what is CMP ?... you can use sumifs or sumproduct . Enjoy Team XLS On Tue, Apr 2, 2013 at 9:56 AM, Dhaval Shah todhav...@gmail.comwrote: Hello all experts any solution for my query On Mon, Apr 1, 2013 at 4:37 PM, Dhaval Shah todhav...@gmail.comwrote: 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? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/**discu**ssexcelhttps://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing
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)* *.Range(S11).FormulaArray = =MAX(($B$2:$B$68=$S$10)*($A$2:$A$68 = FUTSTK)*$I$2:$I$68)* *.Range(R14:R19).FormulaArray = =IFERROR(INDEX($B$1:$N$68,IFERROR(SMALL(IFERROR(INT(SUBSTITUTE(($D$1:$D$68 =$S$11)*($E$1:$E$68 = $R$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),1),)* *.Range(S14:S19).FormulaArray = =IFERROR(INDEX($B$1:$N$68,IFERROR(SMALL(IFERROR(INT(SUBSTITUTE(($D$1:$D$68 =$S$11)*($E$1:$E$68 = $R$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),3),)* *.Range(T14:T19).FormulaArray = =IFERROR(INDEX($B$1:$N$68,IFERROR(SMALL(IFERROR(INT(SUBSTITUTE(($D$1:$D$68 =$S$11)*($E$1:$E$68 = $R$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),4),)* *.Range(U14:U19).FormulaArray = =IFERROR(INDEX($B$1:$N$68,IFERROR(SMALL(IFERROR(INT(SUBSTITUTE(($D$1:$D$68 =$S$11)*($E$1:$E$68 = $R$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),12),)* *.Range(V14:V19).FormulaArray = =IFERROR(INDEX($B$1:$N$68,IFERROR(SMALL(IFERROR(INT(SUBSTITUTE(($D$1:$D$68 =$S$11)*($E$1:$E$68 = $R$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),13),)* *.Range(W14:W19).FormulaArray = =IFERROR(INDEX($B$1:$N$68,IFERROR(SMALL(IFERROR(INT(SUBSTITUTE(($D$1:$D$68 =$S$11)*($E$1:$E$68 = $W$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),1),)* *.Range(X14:X19).FormulaArray = =IFERROR(INDEX($B$1:$N$68,IFERROR(SMALL(IFERROR(INT(SUBSTITUTE(($D$1:$D$68 =$S$11)*($E$1:$E$68 = $W$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),3),)* *.Range(Y14:Y19).FormulaArray = =IFERROR(INDEX($B$1:$N$68,IFERROR(SMALL(IFERROR(INT(SUBSTITUTE(($D$1:$D$68 =$S$11)*($E$1:$E$68 = $W$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),4),)* *.Range(Z14:Z19).FormulaArray = =IFERROR(INDEX($B$1:$N$68,IFERROR(SMALL(IFERROR(INT(SUBSTITUTE(($D$1:$D$68 =$S$11)*($E$1:$E$68 = $W$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),12),)* *.Range(AA14:AA19).FormulaArray = =IFERROR(INDEX($B$1:$N$68,IFERROR(SMALL(IFERROR(INT(SUBSTITUTE(($D$1:$D$68 =$S$11)*($E$1:$E$68 = $W$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),13),)* *End With* * * *End Sub* On Wednesday, 3 April 2013 12:50:55 UTC+5:30, Dhaval Shah wrote: 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.p...@gmail.comjavascript: wrote: 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 Dhaval Shah 079 - 40055253 On Wed, Apr 3, 2013 at 12:25 PM, Lalit Mohan Pandey mohan.p...@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 = 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 =$S$11)*($E$1:$E$68 = $R$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),1),)* Select cell S14:S19, 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 =$S$11)*($E$1:$E$68 = $R$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),3),)* Select cell T14:T19, 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 =$S$11)*($E$1:$E$68 = $R$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),4),)* Select cell U14:U19, 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 =$S$11)*($E$1:$E$68 = $R$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),12),)* Select cell V14:V19, 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=$S$11)*($E$1:$E$68=$R$13)*($M$1:$M$ 680),0,))*ROW($A$1:$A$68),),ROW($A$1:$A$68)),),13),)* Select cell W14:W19, 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 =$S$11)*($E$1:$E$68 = $W$13)*($M$1:$M$68 0),0,))*ROW($A$1:$A$68),), ROW($A$1:$A$68)),),1),)* Select cell X14:X19, press F2 and paste below formuls and confirm it with CSE
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 xlst...@gmail.com wrote: Hi Dhaval, dhaval shah (1).xlsxhttps://docs.google.com/file/d/0B4LBSzxr1QTiVjZoYkRneFFUY1k/edit?usp=drive_web PFA... . Enjoy Team XLS On Tue, Apr 2, 2013 at 10:39 AM, Dhaval Shah todhavals...@gmail.comwrote: cmp is current market price ( CLOSE PRICE ) On Tue, Apr 2, 2013 at 10:18 AM, xlstime xlst...@gmail.com wrote: what is CMP ?... you can use sumifs or sumproduct . Enjoy Team XLS On Tue, Apr 2, 2013 at 9:56 AM, Dhaval Shah todhavals...@gmail.comwrote: Hello all experts any solution for my query On Mon, Apr 1, 2013 at 4:37 PM, Dhaval Shah todhavals...@gmail.comwrote: 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? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor
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 todhavals...@gmail.com wrote: Hello all experts any solution for my query On Mon, Apr 1, 2013 at 4:37 PM, Dhaval Shah todhavals...@gmail.comwrote: 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? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
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 xlst...@gmail.com wrote: what is CMP ?... you can use sumifs or sumproduct . Enjoy Team XLS On Tue, Apr 2, 2013 at 9:56 AM, Dhaval Shah todhavals...@gmail.comwrote: Hello all experts any solution for my query On Mon, Apr 1, 2013 at 4:37 PM, Dhaval Shah todhavals...@gmail.comwrote: 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? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Re: Need expert advise for multipal Selection
Hi Dhaval, dhaval shah (1).xlsxhttps://docs.google.com/file/d/0B4LBSzxr1QTiVjZoYkRneFFUY1k/edit?usp=drive_web PFA... . Enjoy Team XLS On Tue, Apr 2, 2013 at 10:39 AM, Dhaval Shah todhavals...@gmail.com wrote: cmp is current market price ( CLOSE PRICE ) On Tue, Apr 2, 2013 at 10:18 AM, xlstime xlst...@gmail.com wrote: what is CMP ?... you can use sumifs or sumproduct . Enjoy Team XLS On Tue, Apr 2, 2013 at 9:56 AM, Dhaval Shah todhavals...@gmail.comwrote: Hello all experts any solution for my query On Mon, Apr 1, 2013 at 4:37 PM, Dhaval Shah todhavals...@gmail.comwrote: 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? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the