Hello,
I need to compare values in 2 columns within a range of data in two other columns. (Note: first 2 columns must be locked so data in first column is next to the associated value in next column. This also applies to the 2 columns I am compare it to - Column A & B locked with each other as well as D & E locked with each other).
Desired outcome: Column C (Results) indicates"Missed visit" if values in A&B do not occur in D&E. "Good" if they occur.
Bonus: "Late" if date in Column E do not occur in same month.
Thanks for your help.
Bookmarks