If a cell has a 'tick', then import text from this cell

%3CLINGO-SUB%20id%3D%22lingo-sub-2309289%22%20slang%3D%22en-US%22%3EIf%20a%20cell%20has%20a%20'tick'%2C%20then%20import%20text%20from%20this%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2309289%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20do%20the%20following%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20this%20cell%20has%20a%20TICK%20in%20it%2C%20to%20grab%20the%20unit%20code%20the%20tick%20is%20for.%20For%20context%2C%20I%20have%20a%20student%20who%20has%20completed%20X%20amount%20of%20units%20within%20their%20degree.%20If%20they%20wish%20to%20transfer%20to%20a%20new%20degree%2C%20I%20am%20trying%20to%20form%20a%20list%20of%20all%20the%20units%20they%20have%20completed%20in%20their%20degree%20(based%20on%20the%20TICK)%20and%20then%20cross%20reference%20this%20with%20the%20units%20in%20the%20new%20degree.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20added%20a%20screenshot%20of%20the%20text%20here.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%2C%20once%20this%20list%20is%20formed%2C%20there%20may%20be%20empty%20cells%20between%20completed%20units%20(as%20the%20student%20haasn't%20completed%20the%20units%20in%20order.%20Is%20there%20a%20way%20to%20have%20no%20spaces%20between%20this%20list%20of%20completed%20units%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EEDIT%3A%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EI%20made%20the%20below%3A%3CBR%20%2F%3E%3DIF(G14%26lt%3B%26gt%3B%22%22%2CC14%2C%22%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20this%20returns%20the%20value%20of%20C14.%20Which%20works%20and%20does%20work%20with%20a%20TICK%20however%2C%20sometimes%20there%20is%20text%20in%20that%20cell%20and%2C%20IF%20text%2C%20then%20keep%20the%20cell%20blank.%20I%20just%20want%20to%20return%20the%20value%20IF%20a%20TICK%20is%20in%20the%20cell...nothing%20else.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2309289%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2309864%22%20slang%3D%22en-US%22%3ERe%3A%20If%20a%20cell%20has%20a%20'tick'%2C%20then%20import%20text%20from%20this%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2309864%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1041449%22%20target%3D%22_blank%22%3E%40djwri2%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHow%20do%20you%20insert%20the%20check%20marks%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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! 

 

1 Reply

@djwri2 

How do you insert the check marks?