I have a worksheet that I was hoping someone could give me a hand on.
I have a row L7 through AP7 that will either contain a 1 or a 2. For example cell L7 through Y7 each one could have a 1 or a 2 in it. not both.
Based on that input I would like cell J7 to display a text either 1st for a 1 displayed or 2nd for a 2 displayed.
These cells will either have a 1 or a 2 (not both).
Thanks a ton in advance.
Bookmarks