Identify and print 3 most repeated itesm + List of values just once
I'm looking to do this two things:
1- find and print the 3 values most repeated
2- print list of values but just once (if any value is repeated just print once)
I have a form that collects tickets of problems in a given apartment. Each problem is a new ticket. So if there is an apartment with 3 problems i would have 3 tickets.
I already did a formula to count only distinct apartment numbers, but i also want to print the list of apartments that had any problem. And to know which are the top 3 with more problems.
Help Article Resources
Check out the Formula Handbook template!