Demystifying the Lookup Function - Part 2 (Microsoft Excel)

preview_player
Показать описание
In this video, I show the actual use case for the Lookup function. Finding the last non-blank cell in a row vector or in a row. breaking down the Lookup(2,1/(A1:C1 NEQ ""),A1:C1) formula construct

Exercise file can be found here:
Рекомендации по теме
Комментарии
Автор

Nice video, well explained. Thanks for sharing

nonoobott