Hi,

It sounds like you should be using the standard Excel filtering functionality, either the AutoFilter or the Data Advanced Filter. Check out that functionality.

If necessary upload your workbook in which you have manually created a set of the results that you expect to see for any given name selection.