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: