In the example below, is there a simple way to get column B values to be populated with the highest value from column C which has the same value in column A.?
So for example the formula in B5 would go something like...
if the value in column A already is not the first in column A, then for all the rows that have the same value ("JS" in this case), find the highest value (most recent date) in column C and put it in here.
I've been struggling with countif & match, but not really getting very far. Can anybody help?
So for example the formula in B5 would go something like...
if the value in column A already is not the first in column A, then for all the rows that have the same value ("JS" in this case), find the highest value (most recent date) in column C and put it in here.
I've been struggling with countif & match, but not really getting very far. Can anybody help?