Paste this Function into your Excel VBE and then use this in Worksheet =Ratio2(Value1,Value2,Value3............)
On Tue, May 24, 2011 at 2:12 PM, Kabir....:-) <[email protected]> wrote: > Dear Rajan, > > I would be thank ful for your help. But I m not getting how exactly to run > this VBA code in my required Excell Work Book. Can u help me.......? > > Regards, > > Saroj > > > On Mon, May 23, 2011 at 8:20 PM, rajan verma <[email protected]>wrote: > >> Amended.. >> >> Function Ratio2(*ParamArray* arr()) As String >> For i = 0 To UBound(arr) >> Ratio2 = Ratio2 & arr(i) / WorksheetFunction.Gcd(arr) & ":" >> Next >> Ratio2 = Left(Ratio2, Len(Ratio2) - 1) >> End Function >> >> On Mon, May 23, 2011 at 8:16 PM, rajan verma >> <[email protected]>wrote: >> >>> *Try this Function* >>> >>> Function Ratio2(*ParamArray* arr()) As String >>> Dim Arr2(1) As Integer >>> For i = 0 To UBound(arr) >>> Ratio2 = Ratio2 & arr(i) / WorksheetFunction.Gcd(arr) & ":" >>> Next >>> Ratio2 = Left(Ratio2, Len(Ratio2) - 1) >>> End Function >>> >>> >>> On Mon, May 23, 2011 at 12:35 PM, Kabir....:-) <[email protected]>wrote: >>> >>>> Dear Rajan, >>>> >>>> Thanks for your formula....it works. But I want to know, will there be >>>> any macro or VBA code for the query like this. Kindly help me if anything >>>> available like such. >>>> >>>> Thank you all........... >>>> >>>> Regards, >>>> >>>> Saroj. >>>> >>>> On Sat, May 21, 2011 at 10:00 AM, Rajan_Verma <[email protected] >>>> > wrote: >>>> >>>>> Hi Kabir, >>>>> >>>>> See if it help. >>>>> >>>>> >>>>> >>>>> *From:* [email protected] [mailto: >>>>> [email protected]] *On Behalf Of *Kabir....:-) >>>>> *Sent:* Friday, May 20, 2011 5:09 PM >>>>> *To:* [email protected] >>>>> *Subject:* $$Excel-Macros$$ Need a formula for getting the output of >>>>> one calculation as RATIO >>>>> >>>>> >>>>> >>>>> Dear Gurus, >>>>> >>>>> I need a formula for calculated two numbers and resulted output should >>>>> be in a Ratio.i.e., 2:1 or 1.5:3. >>>>> >>>>> Thank you in advance, >>>>> >>>>> Regards, >>>>> >>>>> Saroj. >>>>> >>>>> -- >>>>> >>>>> ---------------------------------------------------------------------------------- >>>>> 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 [email protected] >>>>> >>>>> <><><><><><><><><><><><><><><><><><><><><><> >>>>> 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 [email protected] >>>>> >>>>> <><><><><><><><><><><><><><><><><><><><><><> >>>>> 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 [email protected] >>>> >>>> <><><><><><><><><><><><><><><><><><><><><><> >>>> Like our page on facebook , Just follow below link >>>> http://www.facebook.com/discussexcel >>>> >>> >>> >>> >>> -- >>> Regards >>> Rajan verma >>> +91 9158998701 >>> >> >> >> >> -- >> Regards >> Rajan verma >> +91 9158998701 >> >> -- >> >> ---------------------------------------------------------------------------------- >> 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 [email protected] >> >> <><><><><><><><><><><><><><><><><><><><><><> >> 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 [email protected] > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Regards Rajan verma +91 9158998701 -- ---------------------------------------------------------------------------------- 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 [email protected] <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
