Excel MVP Blog Roundup

True.  For me the good thing about prompting a response from someone who knows their subject, is that I might actually learn something new!

As a presenter, I prefer receiving praise or to be challenged to justify ideas to simple disinterest.

PeterBartholomew1 , another point majority of MVP:s are trainers, they demonstrate different ways to perform this or that operation. If for some demo they selected one way that doesn't mean they don't know about other one. 

SergeiBaklan 

Good point.  I had only thought of the limitations in terms of how I might select 38 columns (say) out of 50; CHOOSE might lose its appeal somewhere along the line.  Performance issues might dominate for large tables of data, as you say.

PeterBartholomew1 , didn't test, but it's interesting if there is difference in performance, at least on half sheet long range, between CHOOSE and FILTER to select columns. Perhaps CHOOSE() wins. Will try one day.

It is interesting comparing styles once in a while, especially given access to the work of experts.  I have noticed that I am noticeably more verbose than other developers.  For me a formula is something beginning with '= LET(', e.g. from Bill Jelen formula

= LET(
   periodsRequested, SEQUENCE(12,1,7),
   payments, IPMT(APR/12, periodsRequested, term, principal),
   SUM(payments) )

Good or bad, who knows; perhaps just different.  At worst, on a road to nowhere!

I also noticed Leila Gharani 's use of FILTER to remove unwanted columns.  I have always tackled the issue from the opposite end, selecting the columns I want.

= LET(
   array, CHOOSE({1,2}, TSal[Department],TSal[Position]),
   SORT(UNIQUE(array)) )

I may not change my approach, but to have a choice is good and one day ... 

cuong Thanks for bringing this together.

Thanks cuong for including me on this week's blog roundup! It's a great pleasure to be featured among Leila Gharani and Bill Jelen! 🙏🏽