C
Christie
I have two spreadsheets, one with middle names and the other without. I need
a formula that will says its a match even though the middle name is not
shown, for example:
Sheet one - Surname: Smith (A1), Christian name: Michael John
Sheet two - Surname: Smith (A1), Christian name: Michael
After this narrows it down I would need to match the address on both
spreadsheets.
Can anyone help????
Christie
a formula that will says its a match even though the middle name is not
shown, for example:
Sheet one - Surname: Smith (A1), Christian name: Michael John
Sheet two - Surname: Smith (A1), Christian name: Michael
After this narrows it down I would need to match the address on both
spreadsheets.
Can anyone help????
Christie