Forum Discussion
Finding data not on a list
Hi guys, I'm using Windows 10 and Office 365. I'm looking to try and find all the date that is not on a different list. I have 2 lists of names, 1 which is split into First and Surname (say c...
I have just seen the requirement to split the names
= LET(
space, SEARCH(" ", Name),
fName, LEFT(Name, space-1),
sName, MID(Name, space+1,10),
found, COUNTIFS(First, fName, Last, sName),
table, IF({1,0}, fName, sName),
FILTER(table, NOT(found)))
The only point is to make a guess what is the Name, First etc here. In particular same size ranges or not, do you think that's obvious for everyone?