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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  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...

Part and Inventory Search

Back
Top