2 Replies Latest reply on Sep 14, 2018 6:36 AM by Akram Ebrahim

    Creating table calculation on arbitrary columns selected via parameters

    Konrad Zdeb

      In this scenario end-user is presented with two parameters, each pertaining to a column name. I would like to develop a functionality where end-user can select column name in parameter ColumnA and another column name in parameter ColumnB and then pass those names to a formula that will use the values in calculation. For instance, in the screenshot below new column added after column F would represent 2 * column A as the end-user is adding column A to column A. End-user should be able to add arbitrary selected two columns.

       

      Workbook with the sample data.