Excel MVP Blog Roundup

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.