Hi all,

First post - first time working for a company where I don't have a real expert to turn to! Any help will be very gratefully received.

I am trying to rank a cell reference among a range of cells that all satisfy a common condition. For example in column A I might have names such as "AA1", "AA2", "AA3", "BB1", "BB2", "BB3", "CC1" etc. In column B I have their corresponding "type", i.e. "AA", "BB", "CC". In column C I have the actual data which is a measure of performance.

Question: What formula will give me the rank of AA1's performance relative to the other AAs such that as the data set grows/changes the formula will remain robust? I.e. I know how to do it by manually selecting the cells of all the AAs but this range may grow and I need the formula to remain correct.

Hope that makes sense.

Thanks