Two questions, if I may.
(1) I am entering data into column B. Some of the data repeats. As I enter the data, I want each entry to also appear in column C, but I do not want duplicates in column C. What do I need to do?
(2) I want to enter a numeric value (ie 101) and have a text value appear in the cell. I have a number of these "codes" that I need to work with, so I assume I'll need a list of some type??
(1) I am entering data into column B. Some of the data repeats. As I enter the data, I want each entry to also appear in column C, but I do not want duplicates in column C. What do I need to do?
(2) I want to enter a numeric value (ie 101) and have a text value appear in the cell. I have a number of these "codes" that I need to work with, so I assume I'll need a list of some type??