Hi,
I would like a formula to:-
a) Find the MIN value in ColB which corresponds to value "A" in ColA (which will be 01-Feb)
b) Return the corresponding value in ColC (which will be 15-Feb)
Bearing in mind I have hundreds of rows with similar data but different values in ColA.
Also, if ColA was the last column, can this be achieved by using INDEX/MATCH etc?
Many thanks in advance.
I would like a formula to:-
a) Find the MIN value in ColB which corresponds to value "A" in ColA (which will be 01-Feb)
b) Return the corresponding value in ColC (which will be 15-Feb)
Bearing in mind I have hundreds of rows with similar data but different values in ColA.
ColA | ColB | ColC |
A | 03-Feb | 01-Feb |
A | 05-Feb | 08-Feb |
A | 01-Feb | 15-Feb |
Also, if ColA was the last column, can this be achieved by using INDEX/MATCH etc?
Many thanks in advance.
