Excel: When Should You Use the Hash Sign (#) in a Formula?

[@graemegourlay2850]

I hadn't noticed the CHOOSECOLS function before, I have use case where this is needed. Thanks for the clarity, conciseness and examples.

[@MikeThomas67]

@graemegourlay2850 You're very welcome

[@krzysztofporadzinski9183]

Great video! Thank you

[@MikeThomas67]

You are welcome!

[@alastairharris1866]

slightly annoying that dynamics arrays don't work in tables. Not perhaps as bad as pivot charts that don't work with pivot tables!