Get table without knowing which row and column

I have a table somewhere in excel. I want to get the table, but I don’t know which row and column it is located.

Based on the examples, I want to get the red text. But the table located at various place. The only thing that exact is the table header name which is unique and only one exist in the whole excel. The value “MANY” also unique.
test.xlsx (11.0 KB)

Get_table.xaml (15.0 KB)

Sheet1

Sheet2

1 Like

Hi @Eric_Wong_Test good solution, should work!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.