Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAI had to add a 'Factorial' column to the original text input that was the same values as the 'Number' column to set up my macro:
Rather odd, it's such a simple form it doesn't need an iterative macro, so it took me a minute to figure out how to force one. Momentary hiccup on data format (hint). Good exercise to work through however.
Only going to bother with the macro since the other is just input/macro/browse per requirements.
Took me forever to figure out how to get the Factorial field in there to begin.
I've previously always initialized the field being calculated to pass into the macro, so this was a challenge! Looks like a union with a Text Input to ensure the field is the way to go.
My macro attached