Hi Dave,
If by formulas you mean "expressions you create & by function "expressions
already available in excel", Then you can submit your favorite function.
By the way, I like the way you think.
Thank you.
Best Regards,
Ayush Jain
On Thu, Jan 13, 2011 at 8:48 AM, ayush jain <jainayus...@gmail.com> wrote:
> Hi Dave,
>
> Yes, This question is for favorite excel formula and not function.
>
> Thanks.
>
>
> On Thu, Jan 13, 2011 at 7:40 AM, Dave Bonallack <davebonall...@hotmail.com
> > wrote:
>
>> Hi Ayush,
>> There seems to be some confusion. I thought the question related to our
>> favourite formula, not favourite function. Please clarify.
>> Regards - Dave.
>>
>> ------------------------------
>> From: rohan.j...@gmail.com
>> Date: Wed, 12 Jan 2011 16:01:19 +0530
>>
>> Subject: Re: $$Excel-Macros$$ Formula of the week - share your best
>> formula
>> To: excel-macros@googlegroups.com
>> CC: jainayus...@gmail.com
>>
>>
>> Hi Ayush Ji,
>>
>> My formulas are
>>
>> *CHOOSE -* we can rank the candidates with choose & code combination
>> CHOOSE(CODE(B1)-64,"Excellent","Best","Poor"), if B1has the value A, B, or
>> C.
>>
>> *CELL("FILENAME",A1) - *we can get instant result of the path of the
>> current file with sheet name.
>>
>> *REPT - *This one give us a clear understanding of status
>>
>> Thanks & Regards
>>
>> ROHAN
>> 9818247278, 8860567680
>>
>>
>>
>> On Wed, Jan 12, 2011 at 3:25 PM, Dilip Pandey <dilipan...@gmail.com>wrote:
>>
>> Hi Ayush,
>>
>> One of my *Best* formula is *OFFSET*.
>> Reason:- It can be used in getting the desired value (located) anywhere in
>> the spreadhseet, the desired Sum, Average etc. It is also used
>> for creating dynamics ranges - which further can be used in formulas /
>> conditional formatting.
>>
>> Best Regards,
>> DILIPandey
>> On Tue, Jan 11, 2011 at 10:04 PM, Ayush <jainayus...@gmail.com> wrote:
>>
>> Dear Group,
>>
>> Let's discuss excel formula this week. Each of us use many formulas in our
>> excel reports , dashboard metrics etc.
>> Please share your best formula and the reason for being the best.
>>
>> If all of you will share atleast one formula, Then I hope to cover all
>> formulas in excel. :D
>> My one of the best formula is *IFERROR()*....Because it helps to avoid
>> iserror formula and make your overall formula shorter..Its available from
>> Excel 2007 version and thereafter only.
>>
>> I appreciate your active participation especially from our Top posters :
>> Dilip, Dave, Paul, Ashish Kaul and all.
>>
>> Thanks everyone.
>>
>> Thanks & best regards,
>> Ayush Jain
>> Group Manager & Microsoft MVP
>>
>>
>> --
>>
>> ----------------------------------------------------------------------------------
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>>
>>
>>
>> --
>> Thanks & Regards,
>>
>> DILIP KUMAR PANDEY, mvp
>> MBA-HR,B.Com(Hons),BCA
>> Mobile: +91 9810929744
>> dilipan...@gmail.com
>> dilipan...@yahoo.com
>> New Delhi - 62, India
>>
>>
>> --
>>
>> ----------------------------------------------------------------------------------
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>>
>>
>> --
>>
>> ----------------------------------------------------------------------------------
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>> --
>>
>> ----------------------------------------------------------------------------------
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Best regards,
> Ayush Jain
>
>
--
Best regards,
Ayush Jain
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
