Hello I am needing help with a formula. column A has multiple agents names in that column are also the word summary I want a formula that can detect the word summary then change it to the cell (advisors name) above it. so that when I filter it does not miss that cell.
Last edited: