Hi Everyone!

excelforumsample.xlsx

I have a data set that I need help with. My data set has multiple iterations of the same number.

As you'll find in the attachment for example:

BA19, BA19-01, BA19-02 are all the same but I only need the latest iteration, in this case BA19-02.

Ideally, I'd like a formula that just removes the other iterations (BA19 and BA19-01), but highlighting them works for now. Basically, if BA19 has BA19-01 check if there's is BA19-02 check if there is BA19-03, if false, else highlight BA19-02. Keep in mind not all items start with BA. I have over 7000 unique items.

Some items won't have suffixes, so I need the formula to leaves the ones that don't be left alone. Also, the iterations sometimes go up to a -07.

Is there a way to do this? Have a done a good job at explaining this? What else can I provide?

Thank you,
Wilson