core.noscript.text
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
See my solution below 🙂
Same approach as solution
See solutions attached.
I wasn't able to do it without altering the XLS files (included name of the xls within the book).Also, because I've used Transpose function, my "Row 2" was different than "Row 2" from the solution.I think I've overcomplicated this...
My solution:
Here is my solution for this one: (similar to the approach by everyone else)
Still unable to understand this :
IF [FileName]=[Row-1:FileName] THEN [Row-1:Row]+1 ELSE 1 ENDIF
Can anyone tell me what exactly are we doing in this IF statement?
Here it is
Proposed solution
Hello.Attached is my solution.
My solution to challenge 19!