...but the sample posted by the OP is sorted.

True, but the entries in Column C are all identical for a given code in
Column B also... now the OP is telling us that is not the case. I only
posted my message to you to give the OP a head's-up in case the data is not
**really** sorted the way shown (here I am assuming the OP may have taken a
copy/paste shortcut when posting his initial question).

Rick