Applying RANK function to a conditional range

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

Just figured out how to add an attachment. Formula I want changing is in E2. I can't change the format of the table because there are multiple tables in the workbook that need to follow an identical layout.

Thanks again if anyone can help

That's great, thanks for solving so quickly. You have used some techniques there that I'm not familiar with so it looks like I have some homework to do.

Cheers