How can I combine formulas in one cell to generate the following answers:

1. Largest Client in terms of Market Cap by Name. (hint provided: Formula has two steps (xlookup and max(if -))
   • The parameters are as follows:
     • Audit Firm: Ernst and Young
     • Market Cap: Largest Amount
     • Name: Name of Client Needed
2. Fraction of Clients with 12/31 year end (hint provided: Countifs, Column S, and a calculation)
3. Fraction of Clients with paying $5 million or more in total fees (hint provided: Excel has requirement for greater than "">="&5000000")

Here is the link to the datahttps://docs.google.com/spreadsheets/d/1qQhsLtjq_QBoBhT2WqkCUWU6RDFqVei-/edit?usp=share_link&ouid=105483500848314097296&rtpof=true&sd=true