Как отобрать нужные строки по условию | Формулы и Power Query
📌 Power Query from Scratch - https://school.andreysukhov.ru/powerq... In Excel, you often need to keep only one row out of several—for example, a record with the maximum amount or the latest date for each client. In this video, we'll cover three working methods for doing this: ✪ CONTENTS ✪ 00:00 | Introduction 00:27 | Array Formulas 03:03 | Dynamic Arrays 03:33 | Power Query 📊 Example File: https://disk.yandex.ru/i/xLqGrWIYD5VQ4A ★ Telegram: https://t.me/excelmate ★ MAX: https://max.ru/andreysukhov ★ Rutube: https://rutube.ru/channel/24729660/ #Excel
▶︎
How to Expand a Table in Excel: 3 Methods (Formulas, New Functions, and Power Query)
▶︎
Power Query: Benefits and Use Cases
▶︎
How to Split Text in a Cell | 5 WAYS
▶︎
Database Normalization for Beginners | How to Normalize Data w/ Power Query (full tutorial!)
▶︎
5 WAYS to find differences between two lists in Excel – quickly and without errors
▶︎
Power Query для Excel и Power BI. ПОЛНЫЙ БАЗОВЫЙ КУРС
▶︎
8 Tiny Excel Symbols That Replace Messy Formulas
▶︎
Топ-10 формул в Excel, которые должен знать КАЖДЫЙ! Они сделают из вас профессионала
▶︎
How to use Microsoft Power Query
▶︎
Создание таблицы в Excel простыми словами / Урок excel для начинающих
▶︎
Power Query Tricks for Volatile Data | When Standard Splits Don't Work
▶︎
Running total in Excel
▶︎
How to Count Cells of a Specific Color in Excel
▶︎
5 Excel TIPS That Really Save Time
▶︎
Параметризация путей к данным в Power Query
▶︎
Power Query was HARD until I learned these 7 Tips
▶︎
10 Images | Coastal Citrus Floral Summer Paintings Screensaver l Frame TV ART |
▶︎
3 WAYS to turn a list into a table
▶︎
Физику ведёт физрук: что происходит в школах? САВВАТЕЕВ | КОПАНЦЕВ
▶︎