Hello,
In column B I have case numbers and some of them are duplicate. I need to have it find the last duplicate number (furthest down in the column) and have it return the corresponding name associated to that row in Column H.
Example:
If I put the formula in cell I2, number 14019509 would...