Mind Blowing GROUPBY Function Reporting Trick with BYROW & LAMBDA eta AND. Excel Magic Trick 1911
From excelisfun · · 8 min

The player loads from YouTube only when you click. It uses YouTube's privacy-enhanced mode.
If the video does not play, the owner may have turned off embedding. Watch it on YouTube instead.
Description
Download Excel File: https://excelisfun.net/files/EMT1909-1911.xlsx Buy excelisfun’s Excel Books: https://www.amazon.com/stores/Mike-excelisfun-Girvin/author/B009Q5T4P2?ref=ap_rdr&ccs_id=6f8ce877-462f-447e-b825-7ede1f72a9d3 Free Excel Class from excelisfun: https://www.youtube.com/playlist?list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo Learn how to create a single cell worksheet formula to produce a summary report with a complex AND Logical Test, OR Logical Test and ALL Criteria. This complex report uses multiple formula inputs and allows the user to change inputs and have the report instantly update. But the complex nature of the logical tests is made easy by using the BYROW & AND functions in the filter_array argument of the GROUPBY function. Learn about AND Logical Test, OR Logical Test, and how math operators convert Boolean TRUE & FALSE values to ones and zeroes. Topics: 1. (00:00) Introduction. 2. (00:51) Review of next three videos: 1909, 1910, 1911. 3. (01:24) Look at GROUPBY Function. 4. (02:56) Compare GROUPBY with full logical test and the BYROW option. 5. (03:46) Build Logical Test that we use in array argument of the BYROW function. 6. (06:25) BYROW Array Function. 7. (07:01) GROUPBY Array Function. 8. (07:36) Test. 9. (07:59) Summary 10. (08:32) Closing
#excel #microsoft #excelisfun #excelcourse #mikegirvin #excel365 #lambda #excellambda #byrow #etaLamda #AND #Excellogical #logicaltest #Groupby #groupbyfunction, groupbyarrayfunction #Excelgroupby #dynamicspilledarrayformulas #singlecell reports
#excel #excel365 #excelisfun #highlinecollege #mikegirvin #freeexcellessons #excelformulas #excelfunctions
This video has subtitles or audio translations in these languages:: Afrikaans, Amharic, Arabic (experimental), Bangla (experimental), Chinese, Danish, Dutch, Dutch (Netherlands) (experimental), Filipino, Finnish, French, French (France), German, German (Germany), Hebrew (experimental), Hindi, Icelandic, Indonesian, Irish, Italian, Japanese, Khmer, Korean (experimental), Macedonian, Maithili, Malagasy, Malay, Malayalam, Mongolian, Nepali, Norwegian, Pashto, Persian, Persian (Afghanistan), Persian (Iran), Polish, Portuguese, Portuguese (Brazil), Punjabi (experimental), Romanian, Russian (experimental), Sanskrit, Scottish Gaelic, Serbian, Sicilian, Slovak, Spanish, Spanish (United States), Swahili, Tajik, Tamil (experimental), Tatar, Telugu (experimental), Thai, Tibetan, Turkish, Turkmen, Ukrainian, Urdu, Vietnamese, Welsh, Zulu. Click gear icon below video to set subtitles, audio and language.