Excel Magic Trick 1302: List Text Modes in Single Cell with TEXTJOIN, HLOOKUP, MATCH & MODE.MULT

Показать описание

Download Excel Files:

Learn how to create an Array Formula to list multiple text modes in a single cell using the functions, MATCH, MODE.MULT, HLOOKUP and the wildcard for “any text” asterisk, “*”, and the new Excel 2016 function TEXTJOIN.

Рекомендации по теме

Комментарии

HLOOKUP to get multiple items - super cool!
Wow!

pmsocho

Really helpful,
thanks for uploading

Nareshkumar-jxog

Thanks Mike for this great video.
I have one doubt, how can this possible without textjoin function. If there any video pls give me url

mehthabt

Mike, I loved this video. Your nested formula is sublime.
Incidentally, I did a search in the dictionary against Genius + Guru, and each time your name pops up! hmm ;-)

kjvstats

Hi. Can you help me pls. I have one scenario with calculating the number of stores. From Jan-June All data are given with stores names. I used pivot table with a slicer. So when I choose one month like Jan it's fine it gives me the total stores correctly but if I choose 2 months or 6 months it multiple all the number of stores. Do you have any suggestion to fix it? Thanks man in advance.

EmilPaje

i know you can help me. Pls try to solve this:
"If A2(6) is greater than A1(5)"

i need the answer should be number(1).

Please try to understand what i Mean and I hope you can give me the answer asap.
Thank you

nfranz

grreat video
you should change your chanel name to XL shaman :) ;)

lazalazarevic

Excel Magic Trick 1302: List Text Modes in Single Cell with TEXTJOIN, HLOOKUP, MATCH & MODE.MULT

Excel Magic Trick 1302: List Text Modes in Single Cell with TEXTJOIN, HLOOKUP, MATCH & MODE.MULT

Excel Magic Trick 1300: List All Modes in Single Cell with TEXTJOIN & MODE.MULT

Excel Magic Trick 1301: Sorted List of Modes in Single Cell with TEXTJOIN Array Formula

Excel Magic Trick 1377: Lookup Formula To List All Incomplete Assignments: INDEX, TEXTJOIN & Mor...

Excel Magic Trick 1111: Item In Both Lists? Extract With Better Array Formula

Excel Magic Trick 1305: Adding Multiple Two-Way Lookups INDEX function & N(IF(1,Array) Trick

Excel Magic Trick 1304: List Text Modes in Single Cell TEXTJOIN, INDEX, N, IF, MATCH & MODE.MULT

Excel Magic Trick 1309: Extract Unique List and List in Single Cell: TEXTJOIN Array Formula

Excel Magic Trick 1303: Minimum Value Greater Than Zero (3 Examples)

Excel Magic Trick 1313: Array Formula to Create Sorted Unique List in Cell. HUGE Formula. TEXTJOIN.

Excel Magic Trick 1315: Create A Unique Sorted List with Power Query

Excel Magic Trick 1306: Simulate VLOOKUP Helper Column In Array Formula using T(IF({1},Array) Trick

Excel Magic Trick 1307: Conditionally Format Multiple Non-Adjacent Cells in Cross Tabulated Table

Excel Magic Trick 1308: Concatenate Items in Rows & Columns from Two-Way Table with TEXTJOIN

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

Excel Magic Trick 1285: OR Criteria & AND Criteria for Max & Min Calculations (5 Examples)

Excel Magic Trick 1276: Impossible: Excel Online Absolute Cell References?

Excel Magic Trick 1317: Formulas for Total Insulin Units… And Excel’s Golden Rule & MAX Replaces...

Excel Magic Trick 1310: Minimum Value Greater Than Zero with: 1) SMALL & COUNTIFS, 2) LARGE?

Excel Magic Trick 1266: NETWORKDAYS.INTL: Each Employee has Different Weekend Schedule?

Multiple Mode (MODE.MULT) Function in Excel

Merry Christmas Tree Fun In Excel RAND Function and Conditional Formatting (Excel Magic Trick 1245)

Excel Lesson 18 - Build Your Own Custom Lists

English: Symbols drop-down menu Excel