autofill field

[lancegoh1]

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

[lancegoh1]

wow amazing...thank you so much!

[mceleavey]

You're very welcome.

Any time.