Hi
I have a list of names on tab Y of a spreadsheet which are all 10 characters long and I want Excel to do the following on a different tab (tab X):
Where I enter a matching string of 10 characters in the first column of tab X, populate the adjacent cell to the right with either 'Y' (if the...