[Excel] Recive value of column A referared to minimum value of column B a based on unique values in column C

Mozas Torres, Jaime 1 Reputation point
2022-10-02T12:47:25.397+00:00

Hi Comunity,

I have some problems trying to operate with Excel and I hope some of you could help me. The problem is the following one (image attached):

For each value of column E (orange) I need to get the minimum value of column C (blue). For that value of column C i need to show the values ​​of columns A (green) and B (yellow) on columns G and H.

I need to automate it in such a way that by changing columns A and B the results of columns G and H change automatically.

In this case, it coincides that the minimum value for each case is the first, but it is not necessarily so in the future.

Does anyone know how to do it? Thank you in advance

Kind regads

246720-duda.png

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,640 questions
{count} votes