Excel Magic Trick 1326

Conditionally Format Text Modes: PivotTable, Array Formula or Power Query?

DESCRIPTION

See how to Conditionally Format Text Modes with: PivotTable, Array Formula or Power Query:
(00:17) Introduction
(01:52) PivotTable & MATCH formula.
(08:23) Array Formula with the functions: MATCH, IF, ISTEXT, MODE.MULT, N, N(IF,1 formula element trick to get INDEX function to return multiple items simultaneously.
(18:05) Power Query (Get & Transform) including List.Modes function and Convert List to Table.
(24:27) Summary

WORKBOOKS

Download “Excel Magic Trick 1321-1340” Excel-Magic-Trick-1321-1340.zip – Downloaded 259 times – 98 MB




Be the first to comment

Leave a Reply