Hi,
On the Power Query course, video pq_7.03 it talks about cell function and file path. I am referencing to step 2 especifically, see below...
| Step 2: Insert the 'PathTable' table in your workbook as show above. Use the CELL Formula to dynamically generate the path. In the Formula Name Manager rename your table, 'PathTable'. Tip: save this workbook as it already has the Path Table ready to use. |
I know you have a link to explain cell function. But do you have a video go along with it somewhere?
This is new to me, and for some reason, the written explanation, isnt doing the trick for me.
Please advise.
Cele
Hi Cele,
Sorry, I don't have a video tutorial for the CELL function. I wouldn't worry about understanding it too much. You can just re-use the example in the sample file.
However, if you have a question about it I'm happy to try and help.
Mynda
P.S. I've moved this post to the Power Query Members forum. Please post course related questions in the course forum, not the free members forums. Thanks.
Understood. And I apologize for any inconvenience this caused.
I'll view the video again.
Cele
No inconvenience 🙂 Just better to have the Q&A in the members area for other members to benefit from.
Mynda
