Quote:
Originally Posted by Coach
Your assumption is correct that Column C is being maintained as a overall roster, while column A will have either new name or a repeat name, albeit may be missing certain keywords as explained earlier.
I just wished it wasn't such a pain in the ass.
|
You can do some sweet shit with macros as well if you want to. For instance, it could check to see if the name exists in the roster list and, if not, add your entry to the list. Gets a bit complex, but Excel can do much, much more than most people realize.