1.4.3.2 Import Data & Add Formula

sydneygouani
New Contributor

1.4.3.2 Import Data & Add Formula

Can someone help me figure out what formula I need here? All the columns are filled. What am I missing?

7 REPLIES 7
chofacker
Contributor

Re: 1.4.3.2 Import Data & Add Formula

sydneygouani
New Contributor

Re: 1.4.3.2 Import Data & Add Formula

Thanks for this! I understand the concepts but I am still struggling with this specific problem. 

chofacker
Contributor

Re: 1.4.3.2 Import Data & Add Formula

Not sure I understand what your question is. Can you clarify? The images don't seem to help me. 

sydneygouani
New Contributor

Re: 1.4.3.2 Import Data & Add Formula

The directions asked me to make a new module to import all the data. Then it says to create a formula for the "Code" column. I am not clear why I am making a formula because the "Code" column is filled. Can you give me some insight as to the logic behind adding a formula? Where do I start?

ChrisAHeathcote
Community Boss

Re: 1.4.3.2 Import Data & Add Formula

@sydneygouani 

If you recall from Level 1 there is a formula that can be used to derive the code of the list which is dimensioned in the module.

Use this combination of CODE and ITEM functions to return the code.

Chris
HeathcoteAndHerran.com
ChrisAHeathcote
Community Boss

Re: 1.4.3.2 Import Data & Add Formula

Also, are you sure that is the correct code for the combination list?
Chris
HeathcoteAndHerran.com
sydneygouani
New Contributor

Re: 1.4.3.2 Import Data & Add Formula

This is why I asked this question. I am not sure. The code was imported from the CSV file given.

 

I