Download Files:

Start File: [ Ссылка ]

Finish File: [ Ссылка ]

ee how to:
1. (00:01) How to Navigate to sections of this video
2. (00:46) Introduction
3. (01:32) What is an OR Logical Test using OR Criteria
4. (02:30) Fundamental Problem with an OR Logical Test on Two Columns
5. (03:23) Conditional Formatting
6. (09:15) SUMIFS Helper Column
7. (13:35) DSUM Helper Column
8. (16:40) Array Formula No Helper Column. Functions: VLOOKUP, T, IF, SUMPRODUCT & LOOKUP.
9. (26:23) Power Query. Function: List.AnyTrue
10. (42:00) DAX Formula. DAX Functions: CALCULATE, FILTER, OR & VALUES.
11. (54:08) Summary

свернуть