HI,

Trying to build a macro- to sort the list(ascending) of numbers in column A and identify duplicates and highlight them yellow. Only catch to this is one month the list might have 100 cells information, next month it only be 50.

I am guessing it will incorporate if then else statement(for identifying duplicates) and relative range to do both sorting.

Any suggestions is greatly appreciated.