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