Forum Discussion
Text Filter
Hello All, Would you be able to tell me how to filter two columns of individual names for differences, that rule out middle initials? I've tried using a filter that would tell me if the nam...
Just to demonstrate that my post above wasn't merely the product of a deranged mind, I attach a functioning workbook (standard installation rather than insider). The name 'testName' is now a relative reference to a cell in the column header and the sequence 'k' is now somewhat more turgid
k: =COLUMN( INDEX(aRow,1):INDEX(aRow,n))
[not that a number sequence should rely upon the definition of a somewhat arbitrary range]