I have a folder containing a number of files whose filename includes the name of a company. There may be more than one file per company in the folder (e.g., Report From Company 1_1.xlsx, Report From Company 1_2.xlsx, Report From Company 2.xlsx, etc.).
I have a table containing company names (Company 1, Company 2, ... Company n).
I need to determine whether each company has submitted at least one file to the folder (the companies email these files to a Sharepoint library, which I have mapped to a local drive to make it easier to work with).
Can anybody suggest an efficient way to compare the company names in the table with the company names in the filenames in the folder?