I have a spreadsheet where each cell in the range A1:A20 has a list of concatenated names, e.g. Jack, Mary, Jim, Stuart, Tracy etc. Is it possible to highlight all of the cells where the same two names appear e.g. Jack and Stuart or Jack and Jim. If not highlighting, is it possible to count how many times the two names, which can be typed in any free cell appear in the same cells in the range A1:A20?
Thanks for any help in advance.