Hi all, i want to count repeating every single text from columns and list them from gsheet.(Plz follow demo image)
Can anyone help me?
Thanks in advane.
unfortunately I do not understand the result from the image
can you explain the rules?
for example, why you get total = 0 for HM and total = 10 for AG?
Taifun
Actually this is a record for provisional Classes taken by the teachers. That means in absence of a scheduled teacher, classes given to alternate teacher. The picture is a demo. The list is long, so I didn’t count for every one properly.
How to count the same texts in the chart? And make a list
you mean you want duplicate cells values as a list?
the task is simple. There are several ways to use it. the most convenient one will work directly with an excel spreadsheet and the result can be written directly to another page of the same file. Everything is according to your wishes. use my extension to work with excel spreadsheets.
use the exact search function on the page. You will get a list as a result of the search. the number of items in this list will be total. for example, a search for “AD” will bring up the cells where it is recorded. for example, (1-5 2-6 3-6), which means a list of cells. I think you’ll figure out how to use it. this is a ready-made solution for your idea
1 Like