Ok, so specifically what do you want help with here?
I wouldn't "laugh" at anyone who makes the effort to have a go at what are quite complex Excel formulas (ok, maybe column I...), but I should let you know that column I does contain a bunch of #REF! errors - presumably you cut some sheets/cell references before posting?
Anyway, like I said, if you could be specific about what exactly you want help with in here.
Regards
TO SEND take 2.xlsxHiya, I have tidied up my mess and you will see on sheet2 my idea behind the lists.
Things that do not work:
1 I can't get the entity LOOKUP formula to respond.
2 Names, please see highlighted in yellow as an example.
3 Advice on how to search for the bad words formula.
4 Company name - looks ok??
Regarding, whether its a surname or not there is no way to really tell, but I would like it to return a best guess first name for instance, as per my list.
I think I'm nearly there, thanks to you!! :D
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks