So now , both Kevin Garnet and Kevin Garnett are blacklisted. Whew! How about instead of Garnett, I blacklist Artist Gilmor.
BTW, a mostly useful function and then filter on the column with the filter for you Excel users:
=VLOOKUP(AW41,PSort!B$2:B$640,1,FALSE)
You have the player's names in row column AW, and a list of players on a sheet you have named PSort. Then Filter out (or in) all player names but #N/A and Bob's your uncle. It dosen't work so well if anything is misspelled however.
8/4/2011 10:32 AM (edited)