Using Percentile with Specific Cell in Worksheet

Sponsor

Excel Formulas : Using Percentile with Specific Cell in Worksheet [Q]

I am trying to use microsoft excel percentile formulas with specific cells in a column. Further example:
A
1 5
2 6
3 7
4 8

Using percentile on state A1:A3 is very easy sufficient, but I desire to do state A1 and A4. I can accomplish this by characterising a entitled variety such that it would be identical to A1 and A4, but would rather not use entitled varieties, as the overhead is a very simplistic demonstration of what I desire to do, utilising entitled varieties would need a considerable allowance of effort to accomplish my end goal.

I furthermore recognize I could re-order the lines such that I swap A4 with A2, thus could use percentile on A1:A2, but that will not work for my desires
either. I tried to use the INDIRECT function in an array unchanging, but recognized that you can’t use a function in an array unchanging, in order that directions that considered out.

Is there a way I can “create” the variety to be utilised in an Excel equation (ala the RANGE function in microsoft excel VBA)? The entitled variety is doing this (as it works), but I can’t number out how to emulate it inside my Excel workbook formulas.

Thanks for any recommendations

Excel Formulas : Using Percentile with Specific Cell in Worksheet [A]

Try this excel formulas

=PERCENTILE((A1,A4),0.95)

Rate This Tips:

Incoming excel search terms

mss,excel percentile formula,excel percentile calculation,calculating 95th percentile excel,conditional percentile excel,excel percentile conditional,formula for percentile,95th percentile equation,percentiel excel,percentile calculation formula,percentile formula in excel,95th percentile excel,calculate percentile in excel using array function,excel percentile formulas,formula for percentiles,how to calculate percentiles in excel,percentil excel,percentile excel,percentile formula,percentile in excel,percentile macro excel,percentile of multiple arrays excel,using =percentile,using percentile in excel,vba percentile,vba percentile formula,=percentile((a1:a4) 0 95),95th percentile calculation in excel,95th percentile formula,95th percentile formula > excel,95th percentile in excel,add a percentile in excel spreadsheet,adding 0 95 percentiles,array formula excel percentile,calculate 95th percentile,calculating percentile by month in excel,calculating percentiles in excel,calculation of 95th percentile xls,conditional array excel with percentile,conditional percentile,conditional use of percentile excel vba,determine percentile in excel,excel and percentiles,excel average 5 and 95 percentile,excel average 95th percentile,excel average specific cells > 0,excel calculate 95th percentile,excel calculate percentiles,excel formula to calculate 95th percentile,excel formula to calculate 95th percentile average

Related Excel Tips

• Look to Cell References to a Worksheet (0)
• Conditional Formula in Different Worksheets (0)
• Calculate Age from Two Date Cells (3)
• Writing a Formula Which Dynamically Generates Results (0)
• Intersection of Two Tabs in Excel Worksheet (0)
• IF Statement Calculating Average Has Numeric and Text (0)
• Automatically Insert Number of Days in Specific Month (0)

Comments

• Archives

  • October 2009
  • September 2009
  • August 2009
  • July 2009
  • June 2009
  • May 2009
  • April 2009
  • March 2009

• Categories

  • Excel Vba
  • Excel Tips
  • Excel Formulas
  • Excel Date Functions
  • Excel Spreadsheet
  • Excel Worksheet
  • Excel Miscellaneous

• Partners

  • Search Xls
  • Xls Files

• Latest Excel Tips

  • Search-Engine-Excel.Com - The Helpful One for You
  • Switch Minutes to Seconds in Excel
  • Excel Polynomial Trendline
  • Sending Multiple Personalized Email from Excel
  • Excel Sumif Multiple Criteria
  • Remove Hyperlinks in Excel
  • Copy Entire Rows to Another Spreadsheet Based on Cell Criteria
  • Streamlining Macro Created by Macros Recorder
  • Copying Cells Which Include Conditional Formatting in Worksheet
  • How to Draw Lines on User Form

• Most Viewed Excel Tips

  • How to Divide a Number With “Less Than” Sign? - 30,439 views
  • Macro VBA to Remove Characters in String of Text - 20,678 views
  • Date Calculation Start Date Minus Year, Month and Days - 19,347 views
  • Copy Entire Rows to Another Spreadsheet Based on Cell Criteria - 18,323 views
  • Insert Introduce Time Delay in Macro Vba - 14,310 views
  • Combine Multiple Workbooks Overcome 255 Char Limit - 14,214 views
  • Protect Range of Rows and Columns in Worksheet with Macro - 13,952 views

• Best Excel Tips

  • Calling Macro Visual Basic Procedures of a Different Project (5.00 out of 5)
  • How to Remove Excel Vba Macro Button (5.00 out of 5)
  • Delete Worksheet (5.00 out of 5)
  • Copy from Worksheet (5.00 out of 5)
  • How to Calculate 6 Working Days Between Two Dates (5.00 out of 5)
  • Remove Hyperlinks in Excel (5.00 out of 5)
  • Unprotect Worksheet Password (5.00 out of 5)

• Excel Tags

  Excel Vba vba excel xcel vba vba xcel Excel Tips Excel Formulas excel formula xcel formulas xcel tips excel vba add worksheet excel vba create new workbook excel worksheet formulas xcel formula Excel Worksheet microsoft excel tips excel vba date functions excel date function Excel Spreadsheet excel vba active worksheet excel vba worksheet change excel vba worksheet name excel vba worksheet_change excel vba delete worksheet excel vba select worksheet excel vba clear worksheet excel vba copy worksheet excel vba macro add new worksheet how to add new worksheet excel miscellanous