Hello,

My question is whether it is possible to check – or even better filter – data in a worksheet for a given sub-set of data. To illustrate what I mean, here an example:

If I have worksheets with lists of companies, will it be possible to check these lists for a particular sub-set, e.g. Company B, Company D, Company F and Company Y? ==> I have also attached a stripped down version of the worksheets in case that helps.


I would need to know whether any or all of them are listed in the individual worksheets. But rather than go through each list entry by entry I was hoping there might be some kind of function that could do this.

I have Excel 2010, by the way.

Thanks

Attached Files

Companies_example.xlsx.xls (466.0 KB, 21 views)