Looking for a specific words in a datatable

I read a excel sheet with hundred rows and 20 columns without headers. (so the column name was column1, column2 …)
The data of this datatable contains a unique word called “Test”. How can i find out this “Test” was from which column ?

as a example, it was like this, how can i figure out the column of the “test”


@Wei_Ji_Kwok use this sequence
uipathF.xaml (13.1 KB)

example input


thks a lot, it was wat i need

1 Like

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