Re: $$Excel-Macros$$ Formula of the week - share your best formula
Mine Fav Formula this week is =COUNTIF(A$3:A3,A3) It resolved my headache...Give ranking n order number for repetitive values Love tht one -- -- 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
RE: $$Excel-Macros$$ Formula of the week - share your best formula
Hi, The problem is not the sheet names, but the indirect refering to a date, which is really just a date code, not a date as displayed. Regards - Dave. Date: Thu, 13 Jan 2011 23:08:24 -0800 Subject: Re: $$Excel-Macros$$ Formula of the week - share your best formula From: noorain.ans...@gmail.com To: excel-macros@googlegroups.com CC: koul.ash...@gmail.com Dear Ashish, I am unable to find data through Vlookup+indirect when sheet name is Date wise like 14-Jan,15-Jan,16-Jan. Please see attached sheet.. -- Thanks regards, Noorain Ansari On Thu, Jan 13, 2011 at 9:49 PM, ashish koul koul.ash...@gmail.com wrote: hi 1 case sensitive lookup using index and match 2 vlookup indirect function Check the attachment. Given you the situations where I used them in the past On Thu, Jan 13, 2011 at 11:15 PM, Ms-Exl-Learner . ms.exl.lear...@gmail.com wrote: Hi All, I suggest all of you don't say this function I like and then this one like that. Just sharing the function name won't help others to gain some knowledge. All the functions which is available in excel is having the same set of qualities unless it is used in perfect combination. So give brief about the function and its different type of usages which you came across in your past. Hope this makes sense. --- Ms.Exl.Learner --- -- -- 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 -- Regards Ashish Koul akoul.blogspot.com akoul.wordpress.com My Linkedin Profile P Before printing, think about the environment. -- -- 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
Re: $$Excel-Macros$$ Formula of the week - share your best formula
Hi Dave, How can solve it. Please give ur valauble suggestion.. Thanks, Noorain Ansari On Fri, Jan 14, 2011 at 1:34 AM, Dave Bonallack davebonall...@hotmail.comwrote: Hi, The problem is not the sheet names, but the indirect refering to a date, which is really just a date code, not a date as displayed. Regards - Dave. -- Date: Thu, 13 Jan 2011 23:08:24 -0800 Subject: Re: $$Excel-Macros$$ Formula of the week - share your best formula From: noorain.ans...@gmail.com To: excel-macros@googlegroups.com CC: koul.ash...@gmail.com Dear Ashish, I am unable to find data through Vlookup+indirect when sheet name is Date wise like 14-Jan,15-Jan,16-Jan. Please see attached sheet.. -- Thanks regards, Noorain Ansari On Thu, Jan 13, 2011 at 9:49 PM, ashish koul koul.ash...@gmail.comwrote: hi 1 case sensitive lookup using index and match 2 vlookup indirect function Check the attachment. Given you the situations where I used them in the past On Thu, Jan 13, 2011 at 11:15 PM, Ms-Exl-Learner . ms.exl.lear...@gmail.com wrote: Hi All, I suggest all of you don't say this function I like and then this one like that. Just sharing the function name won't help others to gain some knowledge. All the functions which is available in excel is having the same set of qualities unless it is used in perfect combination. So give brief about the function and its different type of usages which you came across in your past. Hope this makes sense. --- Ms.Exl.Learner --- -- -- 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 -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- 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 -- Thanks regards, Noorain Ansari -- -- 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
RE: $$Excel-Macros$$ Formula of the week - share your best formula
Hi Noorian, One option is to format the reference cell (with the date in it) as text, then type in the date again, exactly as it appears on the appropriate sheet tab. You also need to add single quotes around the sheet name, so the indirect function looks like this: INDIRECT('B6'!A:B) Without the single quotes, I think Excel reads the dash as a subtraction sign. I've attached your sheet with these modifications. As to your question regarding case-sensitive VLOOKUP, I have given a slightly shorter, non-array alternative using LOOKUP for you to have a look at. Regards - Dave Date: Fri, 14 Jan 2011 01:53:41 -0800 Subject: Re: $$Excel-Macros$$ Formula of the week - share your best formula From: noorain.ans...@gmail.com To: excel-macros@googlegroups.com Hi Dave, How can solve it. Please give ur valauble suggestion.. Thanks, Noorain Ansari On Fri, Jan 14, 2011 at 1:34 AM, Dave Bonallack davebonall...@hotmail.com wrote: Hi, The problem is not the sheet names, but the indirect refering to a date, which is really just a date code, not a date as displayed. Regards - Dave. Date: Thu, 13 Jan 2011 23:08:24 -0800 Subject: Re: $$Excel-Macros$$ Formula of the week - share your best formula From: noorain.ans...@gmail.com To: excel-macros@googlegroups.com CC: koul.ash...@gmail.com Dear Ashish, I am unable to find data through Vlookup+indirect when sheet name is Date wise like 14-Jan,15-Jan,16-Jan. Please see attached sheet.. -- Thanks regards, Noorain Ansari On Thu, Jan 13, 2011 at 9:49 PM, ashish koul koul.ash...@gmail.com wrote: hi 1 case sensitive lookup using index and match 2 vlookup indirect function Check the attachment. Given you the situations where I used them in the past On Thu, Jan 13, 2011 at 11:15 PM, Ms-Exl-Learner . ms.exl.lear...@gmail.com wrote: Hi All, I suggest all of you don't say this function I like and then this one like that. Just sharing the function name won't help others to gain some knowledge. All the functions which is available in excel is having the same set of qualities unless it is used in perfect combination. So give brief about the function and its different type of usages which you came across in your past. Hope this makes sense. --- Ms.Exl.Learner --- -- -- 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 -- Regards Ashish Koul akoul.blogspot.com akoul.wordpress.com My Linkedin Profile P Before printing, think about the environment. -- -- 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 -- Thanks regards, Noorain
RE: $$Excel-Macros$$ Formula of the week - share your best formula
Hi Noorain, Please use below formula: =VLOOKUP(A7,INDIRECT('TEXT(B7,dd-mmm)'!A:B),2,0) Regards Upendra Singh From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Friday, January 14, 2011 12:38 PM To: excel-macros@googlegroups.com Cc: ashish koul Subject: Re: $$Excel-Macros$$ Formula of the week - share your best formula Dear Ashish, I am unable to find data through Vlookup+indirect when sheet name is Date wise like 14-Jan,15-Jan,16-Jan. Please see attached sheet.. -- Thanks regards, Noorain Ansari On Thu, Jan 13, 2011 at 9:49 PM, ashish koul koul.ash...@gmail.com wrote: hi 1 case sensitive lookup using index and match 2 vlookup indirect function Check the attachment. Given you the situations where I used them in the past On Thu, Jan 13, 2011 at 11:15 PM, Ms-Exl-Learner . ms.exl.lear...@gmail.com wrote: Hi All, I suggest all of you don't say this function I like and then this one like that. Just sharing the function name won't help others to gain some knowledge. All the functions which is available in excel is having the same set of qualities unless it is used in perfect combination. So give brief about the function and its different type of usages which you came across in your past. Hope this makes sense. --- Ms.Exl.Learner --- -- -- 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 http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com 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 -- Regards Ashish Koul http://akoul.blogspot.com/ akoul.blogspot.com http://akoul.wordpress.com/ akoul.wordpress.com My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- 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 http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com 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
Re: $$Excel-Macros$$ Formula of the week - share your best formula
Dear members, We all come to know about many functions their best uses. Please keep sharing. Thanks. 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
Re: Re: $$Excel-Macros$$ Formula of the week - share your best formula
Hi All, from my side. =INT() On Jan 13, 2011 9:04pm, kiran Kancharla srkira...@gmail.com wrote: Hi All, from my side I am adding 2 formulas. 1.Index 2.Match One of the best functions.. Please have a look on the Attachment.. Thanks Regards, Kiran On Thu, Jan 13, 2011 at 8:46 PM, Ayush jainayus...@gmail.com wrote: Dear members, We all come to know about many functions their best uses. Please keep sharing. Thanks. 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 -- -- 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
Re: $$Excel-Macros$$ Formula of the week - share your best formula
Hi All, I suggest all of you don't say this function I like and then this one like that. Just sharing the function name won't help others to gain some knowledge. All the functions which is available in excel is having the same set of qualities unless it is used in perfect combination. So give brief about the function and its different type of usages which you came across in your past. Hope this makes sense. --- Ms.Exl.Learner --- -- -- 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
Re: $$Excel-Macros$$ Formula of the week - share your best formula
hi 1 case sensitive lookup using index and match 2 vlookup indirect function Check the attachment. Given you the situations where I used them in the past On Thu, Jan 13, 2011 at 11:15 PM, Ms-Exl-Learner . ms.exl.lear...@gmail.com wrote: Hi All, I suggest all of you don't say this function I like and then this one like that. Just sharing the function name won't help others to gain some knowledge. All the functions which is available in excel is having the same set of qualities unless it is used in perfect combination. So give brief about the function and its different type of usages which you came across in your past. Hope this makes sense. --- Ms.Exl.Learner --- -- -- 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 -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- 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 sample.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Formula of the week - share your best formula
One of the function which I do like is TRANSPOSE function. - This function copies data from a range, and places in it in a new range, turning it so that the data originally in columns is now in rows, and the data originally in rows is in columns. - The transpose range must be the same size as the original range. - The function needs to be entered as an array formula. - To enter an array formula you must first highlight all the cells where the formula is required. Next type the formula, such as *=TRANSPOSE(A1:A5)* and Finally press *Ctrl+Shift+Enter* to confirm it. If changes need to be made to the formula, the entire array has to be highlighted, the edits can then be made and the Ctrl+Shift+Enter used to confirm it. *Syntax :-* *=TRANSPOSE(Range)* Regards, Manoj Kumar On Thu, Jan 13, 2011 at 11:15 PM, Ms-Exl-Learner . ms.exl.lear...@gmail.com wrote: Hi All, I suggest all of you don't say this function I like and then this one like that. Just sharing the function name won't help others to gain some knowledge. All the functions which is available in excel is having the same set of qualities unless it is used in perfect combination. So give brief about the function and its different type of usages which you came across in your past. Hope this makes sense. --- Ms.Exl.Learner --- -- -- 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 TRANSPOSE FUNCTION_Manoj.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Formula of the week - share your best formula
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
RE: $$Excel-Macros$$ Formula of the week - share your best formula
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
Re: $$Excel-Macros$$ Formula of the week - share your best formula
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.comwrote: 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
Re: $$Excel-Macros$$ Formula of the week - share your best formula
Hi group, My formulas for the week is 1. normdist = to find the normal distribution of random numbers. 2. FV = To find the future value of the cash flows. 3. stdev = to find the standard deviation of the distribution. Thanks Regards, Kenil Gala From: Ayush jainayus...@gmail.com To: excel-macros@googlegroups.com Sent: Tue, January 11, 2011 10:04:30 PM Subject: $$Excel-Macros$$ Formula of the week - share your best formula 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 -- -- 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
Re: $$Excel-Macros$$ Formula of the week - share your best formula
Hi Group, My Best Formula for this week is. SUMPRODUCT()-We can use it instead of *Sumif*,*Countif*,*Sumifs* and *Countifs *in 2003 or 2007. -- Thanks regards, Noorain Ansari On Tue, Jan 11, 2011 at 9:09 AM, Kenil Gala keni...@yahoo.com wrote: Hi group, My formulas for the week is 1. normdist = to find the normal distribution of random numbers. 2. FV = To find the future value of the cash flows. 3. stdev = to find the standard deviation of the distribution. Thanks Regards, Kenil Gala -- *From:* Ayush jainayus...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Tue, January 11, 2011 10:04:30 PM *Subject:* $$Excel-Macros$$ Formula of the week - share your best formula 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 -- -- 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
Re: $$Excel-Macros$$ Formula of the week - share your best formula
Hi Group My Best formula for the week is: XNPV() - We can use it to calculate the net present value of a cash flow. Thanks Regards Sumit Kumar On Wed, Jan 12, 2011 at 11:36 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Hi Group, My Best Formula for this week is. SUMPRODUCT()-We can use it instead of *Sumif*,*Countif*,*Sumifs* and *Countifs *in 2003 or 2007. -- Thanks regards, Noorain Ansari On Tue, Jan 11, 2011 at 9:09 AM, Kenil Gala keni...@yahoo.com wrote: Hi group, My formulas for the week is 1. normdist = to find the normal distribution of random numbers. 2. FV = To find the future value of the cash flows. 3. stdev = to find the standard deviation of the distribution. Thanks Regards, Kenil Gala -- *From:* Ayush jainayus...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Tue, January 11, 2011 10:04:30 PM *Subject:* $$Excel-Macros$$ Formula of the week - share your best formula 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 -- -- 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