I work for a hotel and I have saved a sheet containing all previous guests. Each month I receive an arrival sheet and I would like to cross reference the two. I know it's easy with conditional formatting but this can sometimes miss data.
The imput is usually saved as 'surname, firstname & firstname' (as in SMITH, JOHN & MARY) but as this data is manually entered it is prone to human error. Is there a way to check surname first and then the first names?
Bookmarks