Need Help to Sort Data in Airtable Spreadsheet

[Pradyumansinh_Jadeja1 (Pradyumansinh Jadeja)]

Hello Guys.
Here is my Airtable Spreadsheet Demo.

Here you see that abc purchase 3 items.
I want to show in label that “Mr. abc Purchased 3 Items”
I mean i want to find that how many entries available on that particular name?

I Don’t know how to do it. Please help me to solve this issue.

Best Regards

[Still-learning (gsr)]

Pls ref this method , and slightly modify the blocks as per your needs

How to find the repeated item in the list

here is your solution. [blocks - 2020-02-23T172848.382] [blocks - 2020-02-23T172945.043] [blocks - 2020-02-23T172946.707]

[asimjib93 (Asim Jib)]

An example with CollinTree Listview:

[dora_paz (Dora)]

Try something like this