Good Quiz Keep it up.
Hope more quizes.
Pankaj Michel
On Tue, Nov 13, 2012 at 11:59 PM, Ayush Jain wrote:
> Dear group,
>
> Thanks for your participation in the quiz. There was very good response to
> the quiz from the members of this forum.
>
> Excel quiz : 250 responses
> VBA quiz : 228 resp
Thanks EB..!
Karan Singh
On Wed, Nov 14, 2012 at 7:32 PM, >>Excel Beginner<< wrote:
> Hi Karan,
>
> use this CSE formula
>
>
> "=INDEX($C$1:$C$8,SMALL(IF($A$1:$A$8&$B$1:$B$8=G3&H3,ROW($A$1:$A$8)),COUNTIFS($A$1:$A$8,G3,$B$1:$B$8,H3)))"
>
>
>
>
> --
> *Regards,*
> *
> *
> *Excel Be
Use the following in the XML code..
http://schemas.microsoft.com/office/2006/01/customui";>
Regards,
Anoop
On Wed, Nov 14, 2012 at 11:44 PM, Sam Mathai Chacko wrote:
> Divaker, can you post this file?
>
> Regards,
> Sam Mathai Chacko
>
>
> On Wed, Nov 14, 2012 at 2:57 PM, Divaker Pandey wrote:
Divaker, can you post this file?
Regards,
Sam Mathai Chacko
On Wed, Nov 14, 2012 at 2:57 PM, Divaker Pandey wrote:
> Hello Exprets,
>
> I am struggling with the following strange problem in MS Excel 2007
> (rarely occurs).
>
> I have an excel Application with a userdefined ribbon built in usin
Hi Karan,
use this CSE formula
"=INDEX($C$1:$C$8,SMALL(IF($A$1:$A$8&$B$1:$B$8=G3&H3,ROW($A$1:$A$8)),COUNTIFS($A$1:$A$8,G3,$B$1:$B$8,H3)))"
--
*Regards,*
*
*
*Excel Beginner*
*
*
On Wed, Nov 14, 2012 at 1:08 PM, Karan Singh wrote:
> Dear All,
>
> Please suggest me to get value fro
Hi Anjali,
You can also try..
Sub Test()
Application.Calculation = xlCalculationAutomatic
End Sub
On Wed, Nov 14, 2012 at 8:39 AM, Prince wrote:
> Hi Anjali,
>
> Please set the below option in your workbook.
>
> Tools -> Options -> Formulas -> Calculation Options -> Automatic -> Click
> Ok
>
Prince ji happy diwali,
i thing me want to share wid u why u always share wid new mail, why dont
wid related quary?
thanks
On Wed, Nov 14, 2012 at 8:39 AM, Prince wrote:
> Hi Anjali,
>
> Please set the below option in your workbook.
>
> Tools -> Options -> Formulas -> Calculation Options ->
Hello Exprets,
I am struggling with the following strange problem in MS Excel 2007 (rarely
occurs).
I have an excel Application with a userdefined ribbon built in using xml.
Suddenly, during loading application i get an error message.
=> The message box that appears has no words, number or any
Okey finally i have able to solved it.
i have another uncertain issue now in Excel 2007, some time a blank error
dialog box display. with title 'Mirosoft Visual Basic' during robbon load.
Exprets, what problem may be?
Divaker
On Mon, Nov 12, 2012 at 3:54 PM, Divaker Pandey wrote:
> Hi All
