How to count duplicate items which matches to a list of items in dynamic list view


I am very new to coding, and quite efficient in excel so I am trying to learn coding. I have a table like below in google sheets.


Result should be as




Able to make unique lists

But stuck at duplicate count and value in dynamic view.

Plz guide if u can …

First of all welcome to Koding not Coding :joy:

All your id must be unique just use for each number in list block found in controls section

you can use SQLish commands together with the Google Viusalization API, see also App Inventor Tutorials and Examples: Google Spreadsheet Database | Pura Vida Apps see also the detailed guide by TimAI2 here


1 Like

@Shailesh_Dhoot , may be this one helpful to you. You can use the same method as suggested in this post.