4 Replies Latest reply on Aug 14, 2013 10:51 AM by michael.wu

    How do I use the MAX function as a condition to pull text from another column?


      I have Column A which is text and Column B which is a number. How can I pull Column A based on the MAX of Column B? I tried using CASE, IF, IIF, and others but couldn't get it to work.