Help with Macro
Hello,
I have a table with thousand of row of data. The column consists of part#
and operation, etc....
Within the data rows, there are multiple rows with same part#, but at a
different operations in numerical 10 to 999. I would like to create a macro
of some sort to look in all the data, sort the data by part# column, then by
operation, then find part# with multiple operations, keep the latest
operation (highest of 10-999) and delete other lower operations.
Thank for any help.
|