Page 174 - Finanancial Management_2022
P. 174

Excel: How to





                      reference a row






                              dynamically





       IMAGES BY RALF HIEMISCH/GETTY IMAGES  Excel MVP Liam Bastick explains the OFFSET(COUNTA)








                             function combination, used for dynamic lookups.





          16  I  FM MAGAZINE  I  October 2022  By Liam Bastick, FCMA, CGMA
   169   170   171   172   173   174   175   176   177   178   179