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
