I can't seem to find an answer to this issue in over an hour of
searching the groups. My question is simple. I have a list of records
that has duplicate values. I want to extract those records that are
MAX for a unique value. Here is my example

Column A Column G
Type1 ... 1
Type1 ... 2
Type1 ... 3
Type2 ... 4
Type2 ... 5
Type3 ... 1

The result looking like what is below. In addition, there are many
columns between these columns. I want to return the whole row (or at
least the range with data) for the max of each unique value. Any
ideas? Please help if you can. Thanks!

Column A Column G

Type1 ... 3
Type2 ... 5
Type3 ... 1