Forum Discussion
If column has a word within it pull the name in another column
The file you sent is my first suggestion where all data must be entered. Attached is the file with the changed M code which accepts rows without a city. I changed the name of the file from "If column has a word within it pull the name in another column" to "CHANGED If column has a word within it pull the name in another column" for easier identification.
OliverScheurich attached below. I just downloaded yours that you sent and changed Adam to Ann and added another row and then clicked refresh.
The file you sent is my first suggestion where all data must be entered. Attached is the file with the changed M code which accepts rows without a city. I changed the name of the file from "If column has a word within it pull the name in another column" to "CHANGED If column has a word within it pull the name in another column" for easier identification.
- AMAZING!! Thank you so much, this is perfect!