View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
EmyG EmyG is offline
external usenet poster
 
Posts: 1
Default 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?