I am working on a large Pivot Table but I have to manually manipulate the raw data and have it all ready now except for one column.
I keep this column (Z2) to say 2 if another previous column (A2) contains the word keep in any of the text from A2. Can someone help me out here, I know it's simple, it can't be that hard.
Bookmarks