Skip to main content
12-Amethyst
Jul 7, 2023 12:30 PM UTC
Solved

Extract column from table (Excel) with subcategorys

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! 

 

Werner_E
Werner_EAnswer
25-Diamond I
Jul 7, 2023 1:46 PM UTC

The attached file may help.

4 replies

12-Amethyst
Jul 7, 2023 12:31 PM UTC
14-Alexandrite
Jul 7, 2023 1:40 PM UTC

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

 

Translate
Werner_E
Werner_E25-Diamond IAnswer
25-Diamond I
Jul 7, 2023 1:46 PM UTC
12-Amethyst
Jul 11, 2023 5:28 AM UTC

Thanks to both of you! 🙂

Translate