Normal sort occurs on the first word of the text string within a cell, I think. I want to find all the occurences of the word 'President' in column E, and then sort on columns A,B,C, which is company name, first name, last name, etc.
any ideas?
any ideas?