Forum Discussion
Conditional Formatting Question
I dont feel as though I explained it well enough. Without coffee, "skills" might not have been the best reference point.
Here is a screenshot of the spreadsheet I'm referring to.
As you can see, there are columns illustrating various Rankings of the same individuals. Also, the same individuals are broken down by positions and in some cases, they are categories by analytical date (K/BB%).
So, I wanted to "gray out"/conditional format highlight the names that have already been chosen, so that I know who is still available. I can check availability across the various rankings, positions, or even statistics.
One-by-one just seems to be the long way to do it and thought there would be a shorter method.
Obviously, I'm open to all recommendations as well.
Thank you for the feedback thus far.
What is the formal logic behind to compare the names. For example,
Martinez, J.D.
J.D. Martinez
J.D. Martinez BOS OF
are above 3 different persons or the same one?
The naming conventions are different based on different sources of the Rankings. The individual is the same for all three.
That complicate the things, some assumption shall be made. I guess Alonso, Pete; Peter Alonso and Alonso Pete something is also the same person.
Assumption could be to check only last name (if comma exists when the text before comma, otherwise the text between first and second space or end of the text). Thus you will consider all Alonso as one person. You better know what is the probability to have Alonso Pete and Alonso Alex as two different persons in the ranking lists.