I have a list of values in column C. There is a list of 10 values, where if present, I would like the value in column I to be updated to "_". But, I only want any of this to occur if today's date is before 1/1/2022.
I know I can use the search function to see if the value exists, but how exactly would I queue the macro to clear the values?
Thank you kindly!
I know I can use the search function to see if the value exists, but how exactly would I queue the macro to clear the values?
Code:
=SEARCH("1528",C2)
Thank you kindly!