Within an Excel file I would like to sort so that anytime a "value", in this case a name, appears in either one of two columns I can see the row. For example if row 1 column C contains "Smith" and "Smith" appears again in row 12 column D, I would like to see the contents of both row 1 and 12.