No idea about using Excel other than putting in values and colouring them in. (Well, I have dabbled with vlookup in the past, but apart from that- clueless).
I have a spreadsheet with values in columns. What I’d like to do, in pseudocode, is:
Look at Column K. Is the text in it saying “Yes”? If so, print “Column K=Yes” in Column T
else
Look at Column N. Is the text in it saying “Yes”? If so, print “Column N=Yes” in Column T
else
Look at Column P. Is the text in it saying “Yes”? If so, print “Column P=Yes” in Column T
else print “Nothing available” in Column T.
Thats it. This isn’t part of my regular job, but someone has dumped this on me, and I need to do it for Monday morning.
Any clues?