hi can someone guide me as how do I filter out cells that contains text ([Name of Reviewer]) and do a autofill in a new field ([team]) if the previous field ([Name of Reviewer]) contains text.
Original input:
Name of Reviewer | Team |
John | |
#N/A | |
Mary | |
James | |
#N/A |
Desired Output:
Name Of Reviewer | Team |
John | ASC |
#N/A | |
Mary | ASC |
James | ASC |
#N/A |
Cheers,
Lance
Solved! Go to Solution.
wow amazing...thank you so much!