Need help with my calculation on 95th and 50th percentiles

acoron01

New member
Joined
Aug 7, 2013
Messages
4
Reaction score
0
Points
0
Hello i am new to excel, i need help with my calculation, im not too familiar with the syntax and the percentile function. My calculation calculates every percentile in 'Group', but i dont want it to, i need it to calculate every percentile in each subgroup (ID) in each 'Group'. Can someone please point me in the right direction ?View attachment Copy of Copy of EXAMPLE1 (2).xlsx
 

acoron01

New member
Joined
Aug 7, 2013
Messages
4
Reaction score
0
Points
0
Question ?

I have an issue with the table1 and table2 name managers, i cannot access the Refers to =sheet!1!$L$4:$O$12 ,It seems as if they are suppressed/locked. Also how did you get excel to find the address of GROUP ? i see the @Group. But in the excel spreadsheet im working on it doesnt let me format it the way you have it.
 

Herbds7

Banned
Joined
May 8, 2013
Messages
197
Reaction score
0
Points
0
For learning purposes, don't try to modify your spreadsheet, but enter your data into my spreadsheet.
All my data is in the form of "Tables" with "Structured References".
I'm not using obsolete $A$1 or R1C1 references.
For "Tables" tutorial see:
http://office.microsoft.com/en-us/e...-to-manage-information-RZ102252956.aspx?CTT=1
Also read up on "PivotTables"
The learning curve should be several months/years.
 
Top