strings match with the excel sheet RRS feed

  • Question

  • User-2100868856 posted

    Hi everyone,

    I am trying to match the set of strings(say 400 in  numbers) with the excel sheet for a particular column.

    Excel sheet will have 1000 rows and 10 columns.If Excel sheet cell have those set of strings.Then output will be the complete row with matched set of strings in that cell.

    eg I have set of strings "SQL Server","ASP.Net with C#","Delhi University" say 400 different strings(these are keywords that need to be  search in that Excel sheet).Excel sheet have 10 columns.I want to search in the 6th column for these 400 strings in the excel sheet. It will show the all Rows which have atleast one of these strings.

    How to do this filteration.Please help how to do this.

    Tuesday, January 5, 2016 5:05 AM

All replies