Sorting + "selecting non-Repeated Records" (2) -- minimum values of each group

Sorting + "selecting non-Repeated Records" (2) -- minimum values of each group

Key design points: sorting, filtering, and selecting non-Repeated Records

Xiuxiu: I did not expect this option to "select not repeat records.

Ajin: Ah ?! That's not. This is just a purpose. How can I find the item with the minimum inventory in each category?

Xiuxiu: Well --, the first step is sorting by category, item name, and inventory quantity. The second step is, click "data"-"filter"-"advanced"-select "do not repeat records "......

Ajin: The Key to step 2 is to select the "category and name" columns in the "List area.

Xiuxiu: Oh, well ......, Yes! Ah? In the past, your methods were divided into three steps. How can we solve this problem in two steps?

Ajin: Actually, there are three steps.

Xiuxiu: Huh? Step 3? What is it?

Ajin: Thanks to tech "!