I have a table in wich raw data is entered manually, with info about clients and the requests they made.
And then I have this table in which I'm trying to analyze a bit the raw data (# of requests per client, time consumed, etc).
I need that in the last column (highlighte in yellow) to have the Type of document most type requested by Name, but I don't know how, what I have is the type of document most requested from ALL toghether, by using this formula:
=ARRAYFORMULA(INDEX(D$4:D$14,MATCH(MAX(COUNTIF(D$4:D$14,D$4:D$14)),COUNTIF(D$4:D$14,D$4:D$14),0)))
Also I need the analysis table to auto update each time a new entry is made in the raw data table.
Any help?
This is the sheet I'm using for testing:
https://docs.google.com/spreadsheets/d/1L5YDB-iPyLKgQwTYGJjZcjrOzpkM8fMMzMudJV-ukAA/edit