Hi everyone

I am new to this forum and very bad in excel. I have hit a roadblock right now. I have attached an excel file.

My issue is this:

I want to find the lowest value associated with a each codes (212, 223, 230, 242) corresponding to its value in the C column.

The resultant value of 212 is 3. The values for 223, 230, 242 should be 1, 3, 5 respectively. I would be very much obliged if someone can derive one formula with which I can get the required results.

Thank you all in advance for your replies and efforts.

I am new to this forum and very bad in excel. I have hit a roadblock right now. I have attached an excel file.

My issue is this:

I want to find the lowest value associated with a each codes (212, 223, 230, 242) corresponding to its value in the C column.

The resultant value of 212 is 3. The values for 223, 230, 242 should be 1, 3, 5 respectively. I would be very much obliged if someone can derive one formula with which I can get the required results.

Thank you all in advance for your replies and efforts.