Excel Magic Trick 1326: Conditionally Format Text Modes: PivotTable, Array Formula or Power Query?

Download Excel Files:

See how to Conditionally Format Text Modes with: PivotTable, Array Formula or Power Query:
1. (00:17) Introduction
2. (01:52) PivotTable & MATCH formula.
3. (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.
4. (18:05) Power Query (Get & Transform) including List.Modes function and Convert List to Table.
5. (24:27) Summary

[mohamedchakroun]

Thank you mike i am very soory for the inconviniene. thank you for being so kind with me. my apologizes for reapeating the question 3 times. now it is clear for me :-)

[sharon]

You are the best, Mr Mike
many thanks

[josebetancourt]

Hey another great video! I found a great function that maybe you can show to handle multiple workbooks. The CELL function for example can provide you the workbook filepath and nested with HYPERLINK function, the sky is the limit. Thanks again!

[Sal_A]

Why do you have to convert the PQ table to a list? I know you entered list.mode in the formula bar but what's the reason for converting it to a list in the first place? Why couldn't you do it on the table instead of drilling down, it looks like the same thing? Thanks!

[mohamedchakroun]

Hello Great Mike
Can we use with formula the countifs and max function to do the conditionnal formatting with

[LauraGonzalez-jowh]

Mr. Mike, I have an issue that I can not resolve. I have a list of cells with data and color applied (teacher names with assigned a color code), how I can take this list to apply to a conditional format, (calendar). So if I change de color in the list it modified the conditional format already applied to another. I will appreciate your help.

[mohamedchakroun]

Can we use with formula the countifs and max function to do the conditionnal formatting with