Hello! This is my first post here. I'm pretty familiar with Excel generally using the 365 package but I am new to the Macro function. For a report that I use daily, I want to find a way to make my macro clear part of the contents of a column if a condition is met and leave the rest of the data otherwise.
I have attached an example of the data that I am looking at. Students (column A) are sorted by their Level (column B). My report lists the Honor designation (column C) for each student. I want to always remove the honors for students that have the level of GR or AG. For UG and AP students, however, I want the honor data to remain untouched. My data varies each day so I want to always achieve the same result where all GR and AG students have no honors listed.
For this to be achieved, do I need to use an If/Then statement? Would you recommend any other work-around?
Bookmarks