Removing Duplicates #4.1 - Extracting Min and Max values
Removing Duplicates can do more than just delete duplicate rows. If we combine the sort feature followed by Remove duplicates we can get more logical outputs. If sort the data in descending order, it will give us maximum in each category. If we do it by ascending, we get the minimum.