[Excel] Recive value of column A referared to minimum value of column B a based on unique values in column C
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