Hey Satvik, please find the below link http://www.ozgrid.com/VBA/conversion-functions.htm
On Mon, Sep 5, 2011 at 9:28 AM, <satvik...@gmail.com> wrote: > ** Hi guru, > > Plz help me how to convert number in to a text. > > Regards, > Satvik > > Sent from BlackBerry® on Airtel > ------------------------------ > *From: * ChilExcel <chilexcel...@gmail.com> > *Sender: * excel-macros@googlegroups.com > *Date: *Sun, 4 Sep 2011 12:36:39 -0400 > *To: *<excel-macros@googlegroups.com> > *ReplyTo: * excel-macros@googlegroups.com > *Subject: *Re: $$Excel-Macros$$ Help to create summary table count unique > > I have solved my problem Thank www.contextures.com everything I > need in a PivotTable without using macros > www.contextures.com excellent!! thanks > 2011/8/26 ChilExcel <chilexcel...@gmail.com> > >> in the example I use: >> 1 advanced filter >> 2 Pivot table >> 3 and formula for count unique >> >> i need macro for all in summary table >> >> 2011/8/26 ChilExcel <chilexcel...@gmail.com> >> >>> Thx , I know all of the above >>> >>> my problem is to use all operations once >>> Sum, Count, and Count unique !!! >>> >>> all, not separated >>> >>> >>> 2011/8/26 NOORAIN ANSARI <noorain.ans...@gmail.com> >>> >>>> Dear Sandeep, >>>> >>>> Please see attached sheet for Example........... >>>> >>>> >>>> >>>> -- >>>> Thanks & regards, >>>> Noorain Ansari >>>> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> >>>> >>>> On Fri, Aug 26, 2011 at 10:51 AM, <chhajersand...@gmail.com> wrote: >>>> >>>>> **Dear excelguru, >>>>> >>>>> Can u pls elaborate what is unique count? >>>>> And how it helps? >>>>> >>>>> Sent on my BlackBerry® from Vodafone >>>>> ------------------------------ >>>>> *From: *NOORAIN ANSARI <noorain.ans...@gmail.com> >>>>> *Sender: *excel-macros@googlegroups.com >>>>> *Date: *Fri, 26 Aug 2011 10:49:39 +0530 >>>>> *To: *<excel-macros@googlegroups.com> >>>>> *ReplyTo: *excel-macros@googlegroups.com >>>>> *Subject: *Re: $$Excel-Macros$$ Help to create summary table count >>>>> unique >>>>> >>>>> Dear ChilExcel, >>>>> >>>>> For Unique Count............... >>>>> >>>>> Use below function..with Ctrl+shift+Enter.. >>>>> >>>>> *=SUM(1/COUNTIF(I1:I28,I1:I28))* >>>>> >>>>> -- >>>>> Thanks & regards, >>>>> Noorain Ansari >>>>> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> >>>>> >>>>> >>>>> On Fri, Aug 26, 2011 at 3:20 AM, ChilExcel <chilexcel...@gmail.com>wrote: >>>>> >>>>>> hi all >>>>>> >>>>>> Please help to create summary table with unique count >>>>>> Summary table need: >>>>>> unique count (repeated) >>>>>> sum all >>>>>> count all >>>>>> >>>>>> >>>>>> file attachment >>>>>> >>>>>> -- >>>>>> >>>>>> ---------------------------------------------------------------------------------- >>>>>> 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 >>>> >>> >>> >>> >>> -- >>> Visita ; http://sites.google.com/site/chilexcel/Home >>> Visita ; http://www.youtube.com/user/timextag41 >>> >>> >> >> >> -- >> Visita ; http://sites.google.com/site/chilexcel/Home >> Visita ; http://www.youtube.com/user/timextag41 >> >> > > > -- > Visita ; http://sites.google.com/site/chilexcel/Home > Visita ; http://www.youtube.com/user/timextag41 > > -- > > ---------------------------------------------------------------------------------- > 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
