I have a big table where I am trying to calculate percentrank of B in column C for each individual entry in A separately. So based on the example below, "PERCENTRANK("$B$2:$B$10",B2)" for CHI, STL, LOS separately, without having to sort. How can I define a dynamic range in column B based on all =A for that row? So in C2, the formula should pick a range in B that includes values only for A="CHI", but not manually. Is this possible?
A B C
CHI 5 Percentrank among CHI values
CHI 12 Percentrank among CHI values
STL 1 Percentrank among STL values
CHI 7 Percentrank among CHI values
LOS 2 Percentrank among LOS values
LOS 1 Percentrank among LOS values
LOS 8 Percentrank among LOS values
STL 7
CHI 9
Bookmarks