CODEWITHSUNDEEP
excel
San Backups
San Backups

Reputation: 503

Unique Filter, Highest Value

I would like to take this list in Excel and make it a unique list with no duplicates. I also want the single remaining entry for each food to be the highest value: 

Crab            1600
Mackerel        1600
Beef            1600
Beef            1600
Beef            1600
Beef            1600
Beef            1600
Chicken         1600
Cod (fish)      1600
Cod (fish)      1600
Split Peas      1500
Lobster         1500
Lobster         1500
White Beans     1500
Lobster         1500
Liver, Chicken  1500
Liver, Beef     1500
Beef            1500
Beef            1500
Turbot (fish)   1500
Shrimp          1500
Tuna (fish)     1500

will become: 

Crab            1600
Mackerel        1600
Beef            1600
Chicken         1600
Cod (fish)      1600
Split Peas      1500
Lobster         1500
White Beans     1500
Lobster         1500
Liver, Chicken  1500
Liver, Beef     1500
Turbot (fish)   1500
Shrimp          1500
Tuna (fish)     1500

Upvotes: 0

Views: 56

Answers (1)

brietsparks
brietsparks

Reputation: 5006

I would like to take this list in Excel and make it a unique list with no duplicates. I also want the single remaining entry for each food to be the highest value.

  1. Apply a filter to the data and sort descending on the numbers column
  2. Select the sorted data and go to the tab Data > Remove Duplicates, checkbox only the column that contains the names (in example it would be column A)

Upvotes: 2

Related Questions