Skip to main content
12-Amethyst
July 7, 2023
Solved

Extract column from table (Excel) with subcategorys

  • July 7, 2023
  • 2 replies
  • 1515 views

Hi

I want to extract a column with data from different tables, where each table contains several subcategorys. See example below (and attached file). Is this possible to do in mathcad? 

 

For example, by selecting "Table 1", "Subcategory 3" and section "C" I want to extract a column containing the right set of data. 

 

ksk_10594232_0-1688732507816.png

Thanks in advance! 

 

Best answer by Werner_E

The attached file may help.

2 replies

12-Amethyst
July 7, 2023
14-Alexandrite
July 7, 2023

Hello @ksk_10594232 , I've attached a solution that should work for you. There may be several ways to solve the problem, but the method I've provided is straightforward to understand and implement.

 

EP_10515634_0-1688737068201.png

 

Werner_E25-Diamond IAnswer
25-Diamond I
July 7, 2023
12-Amethyst
July 11, 2023

Thanks to both of you! 🙂