I have a list of parts with revisions such as below, all in one cell:
ABCD - 0
ABCD - 1
EFGH - 23
EFGH - 24
IJKL - 7
MNOP -
I need a formula to show me the "maximum" or latest revision number for each part. So result in one cell would be:
ABCD - 1
EFGH - 24
IJKL - 7
MNOP -
Thank you!!
ABCD - 0
ABCD - 1
EFGH - 23
EFGH - 24
IJKL - 7
MNOP -
I need a formula to show me the "maximum" or latest revision number for each part. So result in one cell would be:
ABCD - 1
EFGH - 24
IJKL - 7
MNOP -
Thank you!!