Hi All
Does anybody know a formula or formatting trick so that when I type text in one column it is erased from another column? Obviously this would only apply if I am typing a duplicate value. See example below and attached. For example, if I were to type Tampa Bay Buccaneers in column E2, it would be removed from column B15. Hope this makes sense.
Thanks for any ideas/help!
Capture1.PNG
Bookmarks