multiple operations in one column

Attachment 395139

Hello everyone,

I have some difficulties with a specific formula request.

For my master thesis, I need to compute some median company performance and need to do it separately according to the identifier.

As you can see on the attached file, column A represents an identifier and column B the performance.

Would it be possible in one shot to compute the median of each performance linked to each identifier ? i.e the median for the 1st identifier is computed at line 195, median for identifier no 2 at line 436, etc.

The number of observations per identifier is not identical and therefore I could not use an IF function with the condition that the identifier has to be the same as before because when I scroll down the formula would not integrate all the specific information.

If someone could help me that would be great!

Thanks in advance!
Best regards,

Joel