Hello everyone!
I am trying to do the following:
If this cell has a TICK in it, to grab the unit code the tick is for. For context, I have a student who has completed X amount of units within their degree. If they wish to transfer to a new degree, I am trying to form a list of all the units they have completed in their degree (based on the TICK) and then cross reference this with the units in the new degree.
I have added a screenshot of the text here.
Also, once this list is formed, there may be empty cells between completed units (as the student haasn't completed the units in order. Is there a way to have no spaces between this list of completed units?
EDIT:
I made the below:
=IF(G14<>"",C14,"")
However, this returns the value of C14. Which works and does work with a TICK however, sometimes there is text in that cell and, IF text, then keep the cell blank. I just want to return the value IF a TICK is in the cell...nothing else.
Thank you!
