1 Reply Latest reply on Feb 16, 2018 10:19 AM by Moira Reade

    Having a rank calculation problem

    Moira Reade

      Can anyone help me?  I have a text table with System as my columns and General IC Function as my rows.  At the intersection/cell I have a label for a specific IC and its cost. Or sometimes more than one IC and it's cost.  I'd like to rank those ICs wrt their cost within the system/Function intersection.

       

      Is that even possible?  I'm including a small subset of my data in a packaged workbook here: