attached is a sample of a problem i am working on.
i have a range of numbers that i have ranked in a tier system (column d). the process behind that is not important, but for each row, i need to return the highest value for the range of the entire tier data set for the values listed in column a.
so in this example: the 2 rows in tier 1 would each return 39 (the highest value of those two) in column e. the rows in tier 2 would each return 14 in column e, and so forth for the rest of the tiers.
can anyone point me in the right direction? these values will not often be ordered ascending like this