Excel Union Operator For Aggregate, Statistical & Finance Functions - Excel Magic Trick 1569

preview_player
Показать описание
In this video learn about how to use the Union Operator in standard Aggregate functions, like SUM and AVERAGE and how to use it inside of parentheses inside Statistical and Finance Functions.
Related Videos:
Excel Union Operator For Aggregate, Statistical & Finance Functions - Excel Magic Trick 1569
Excel Intersection Operator, An Excel Party Trick - Excel Magic Trick 1570
  1. excelisfun
  2. Excel
  3. Highline College
  4. Mike Girvin
  5. excelisfun
  6. EMT
Рекомендации по теме
Excel Union Operator 0:02:40

Excel Union Operator For Aggregate, Statistical & Finance Functions - Excel Magic Trick 1569

Excel Intersection Operator, 0:01:10

Excel Intersection Operator, An Excel Party Trick? - Excel Magic Trick 1570

Union and Intersect 0:03:22

Union and Intersect Operators in Excel

Excel Union and 0:00:58

Excel Union and Intersect - How To Use Sum Ranges or Intersection

Excel Union and 0:00:58

Excel Union and Intersect - How To Use Sum Ranges or Intersection

Excel Union and 0:01:39

Excel Union and Intersect - example sum ranges or intersection

Excel Intersection (space) 0:01:01

Excel Intersection (space) and Union (,) Operator #excel #exceltutorial #excelsolutions

The Most Powerful 0:01:32

The Most Powerful Function in Excel - AGGREGATE

Excel Reference Operator 0:07:19

Excel Reference Operator Range Operator Union Operator Intersection Operator in Operator Precedence

Set operations in 0:05:45

Set operations in Microsoft excel | Set intersection and Set difference in excel

Microsoft Excel - 0:05:13

Microsoft Excel - Intersection Operator

Excel Tutorial - 0:08:48

Excel Tutorial - Using Sum, Subtotal & Aggregate

Fibonacci Sequence, Union 0:06:31

Fibonacci Sequence, Union and Intersection, Transpose in MS Excel

Intermediate SQL Tutorial 0:05:25

Intermediate SQL Tutorial | Unions | Union Operator

Ex3 Reference 0:02:58

Ex3 Reference Operators

Subtotal vs Aggregate 0:10:32

Subtotal vs Aggregate function in MS Excel.

Union Method In 0:01:02

Union Method In VBA Macros || VBA Shorts || VBA Basics

Excel performance improvements 0:10:24

Excel performance improvements now take seconds running Aggregation functions

How to Use 0:00:51

How to Use COUNTIF Formula in microsoft Excel | COUNTIF function in Excel

EXCEL VBA 2020 0:08:30

EXCEL VBA 2020 UNION

Excel Range Operator 0:00:16

Excel Range Operator #excel #exceltutorial #exceltips #shorts #youtubeshorts #computer

how to union 0:02:15

how to union a Excel file with many sheets to one sheet

Excel VBA - 0:02:10

Excel VBA - Use string variable as input to Union Method

Order of Operations 0:08:35

Order of Operations in Excel

Комментарии
Автор

Probably worth mentioning that this depends on locale. The union operator is ; for my excel.

AtanasNenov
Автор

Everything is Available of excel with this channel .Wow

simfinso
Автор

Another great trick, union operator, thanks you

ogwalfrancis
Автор

Good vid, Mike. The power of this concept is rarely exploited. It's remarkable that the arguments in those functions that accept union operators do not need to be of the same size, be it the number of row, columns or both.

drsteele
Автор

Hi Mike.. great tip. Thanks for the parenthesis trick when only one array argument in the function.. never thought of that for joining different ranges into a single virtual range (i.e. array) using the comma union operator (or semi-colon depending on location per your comments below with Nenor).. excellent!! Always something new to learn from ExcelIsFun. Thumbs up!!

wayneedmondson
Автор

Nice vid. Thumbs up. Just an FYI, the black line demarcating the 75-percentile is one row too high (4.575 is sitting over 4.7 in picture).

mr.brownstone
Автор

Nice of you to bring our attention to this seemingly small thing with large implications.
We all use it more often than we think — implicitly. It’s good to become aware of it and use it more actively.
BTW: in countries that use the comma as a decimal separator, the union operator symbol (which is the same as the argument separator symbol) is the semicolon (“;”).

PS: in this video you put the bar a little too high ;-) —on that percentile, that is. One record to be precise. The number you added doesn’t fit there in the sequence, which is a hint.

GeertDelmulle
Автор

Great mike please give us a tricks of using indirect function mike :-)

mohamedchakroun
Автор

Unfortunately this does not work with array formulas such as UNIQUE or SORT. any ideas on who we could have this work with UNIQUE?

chronis