我想把这个列表在Excel中,使其成为一个唯一的列表,没有重复。我还希望每种食物的单个剩余条目是最高值:
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
将变成:
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
我想把这个列表在Excel中,使它成为一个唯一的列表,没有重复。我还希望每种食物的单个剩余条目是最高值。
- 对数据应用过滤器并按数字列降序排序
- 选择已排序的数据并转到选项卡
Data > Remove Duplicates
,只选中包含名称的列(在示例中为列A)