Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by nssajith

  1. nssajith

    Excel Macro to calculate PERCENTILE

    sorry for that....I got clarity in this this when I started doing it. Thanks for the help
  2. nssajith

    Excel Macro to calculate PERCENTILE

    Thanks for your replies. My situation is little more complex, I have in column A with values P & R, I want to calculate Percentile for both P& R seperately and number of values for P& R is not constant every time. Thanks
  3. nssajith

    Excel Macro to calculate PERCENTILE

    This is the macro I have currently. I am not able to do this for more than 5400 rows. How can I make it happen? 'MACRO TO CALCULATE PERCENTILE Dim Arrray(1 To 5000) As Variant Dim myVar As Double For Each cel In Range("a1:a5000") If cel.Value <> "" Then Arrray(cel.Row) = cel.Value End...
  4. nssajith

    Excel Macro to calculate PERCENTILE

    Can I get some help for writing a macro for calculating PERCENTILE. The data set will always be in one column but the number of rows will be changing. I can give an example for the calculation Data Set Count 10 1 20 2 30 3 40 4 50 5 Lets...
See more

Part and Inventory Search

Back
Top