Use excel to calculate a percentile from data in multiple sheets

G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

slow calculation of rank and percentile in Excel 2007 3
Copying Data from Multiple Sheets to One sheet 1
vlookup from multiple sheets 2
LOOKUP across Multiple Sheets 4
Pivot Table using data from multiple sheets 1
Percentile function in MS Access 2
Pulling data from Sheets in A workbook 2
using the =page! feature to transpose a row to column 0

Top