Thursday, 11 September, 2025г.
russian english deutsch french spanish portuguese czech greek georgian chinese japanese korean indonesian turkish thai uzbek

пример: покупка автомобиля в Запорожье

 

LET Function Second Look: Reusing Variables! 2326

LET Function Second Look: Reusing Variables! 2326У вашего броузера проблема в совместимости с HTML5

The Excel team introduced an amazing new LET function to Office 365 Insiders Fast on March 16, 2020. After the initial introduction video yesterday, today, I tackle a massive 340-character formula to find the second-to-last word in a phrase (aka the penultimate word).
And Yes, this can be done easily with VBA, but today I am taking a 300+ character formula from the MrExcel Message Board circa March 2010 and simplifying it dramatically.

Опубликовано: 18-03-2020
Теги: Microsoft Excel Excel Bill Jelen MrExcel LET function in Excel Using Variables in Excel Formulas Find the Penultimate word in a phrase in Excel Find the next to last word in a phrase in Excel Excel formulas Office 365 Insiders Insiders Fast Calc Engine in Excel microsoft excel tutorial

Похожие видео
First Look Let Function 2325

First Look Let Function 232502:33

LET Speed test in Excel and LET with Arrays 2326.5

LET Speed test in Excel and LET with Arrays 2326.502:48

SUMPRODUCT function in Excel | Sumproduct formula | Hindi

SUMPRODUCT function in Excel | Sumproduct formula | Hindi04:00

Learn Excel 2010 - "Remove Spaces with VBA": Podcast #1465

Learn Excel 2010 - "Remove Spaces with VBA": Podcast #146502:24

Мой аккаунт

Вход / Log In