| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Use excel to calculate a percentile from data in multiple sheets
using office 2003 i would like to use data from multiple sheets in workbooks
to calculate the 95th percentile. It appears that the percentile function only allows an array from one sheet. Is there any way of getting around this so that i dont have to copy and paste reams of data into one worksheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate percentile for indexed numbers. Thanks | New Users to Excel | |||
| calculate percentile for indexed numbers. Thanks | New Users to Excel | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| how do i find data in multiple sheets in excel | Excel Worksheet Functions | |||
| Updating Excel Data on Multiple Sheets | Excel Worksheet Functions | |||
Linear Mode
