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:
Also I need the analysis table to auto update each time a new entry is made in the raw data table.
This is the sheet I'm using for testing: