You can save the data from excel into tables, but how to modify or use filter as per column name?
For example, you have table in excel with the following columns and rows:
name marks city
A 90 Mumbai
B 70 Delhi
C 100 Mumbai.
I have entered the following information in the table using set range option and capturing it in table, now want to use loop to get only mumbai name in another table or excel.