How can I process all the "Name of results Save" column's rows for a date variable (like yest date) using Excel query?

[Srini84 (Srinivas Kadamati)]

@anjasing

Check as below for your reference

Filter Datatable rows on yesterday's date - large excel

Hi, I have a very large excel sheet with tens of thousands of rows. Column A contains dates in the format dd/mm/yyyy. I want to filter out the rows that have todays date -1 day. While this is simple to do it takes a long time for the ‘read range’ activity to read through the whole excel sheet and then to do a ‘for each row’. Is there any other ways of doing this that would be quicker?

Hope this may help you

Thanks