TEXTJOIN & TEXT Functions working on Multiple Rows or Columns (DOLLAR Function too) EMT 1614

Learn how to join multiple items from different rows and columns into a single cell using an array operation with the Ampersand, the TEXTJOIN Function and the TEXT Function to correctly format the numbers for a single cell text label.
Topics:
1. (00:01) Intro
2. (00:29) Revenue Formula with data from different rows
3. (03:02) Expenses data coming from different columns
4. (03:44) Bonus Formulas
5. (03:30) Summary

[rrrprogram]

Only LEGENDS make these kind of stuff ....thanks mike

[Negi_From_Pauri]

dear mike i really like when u say boop.☺☺☺☺☺☺☺☺☺☺

[thierrybernot]

And I was trying to do this on 12 columns, with a semi column separator using ifs() (Si.condition () in French)! what a shame ... much more convenient and easy to use. Thanks Mr Mike you really made my day today.
If there's an Excel award, you deserve it.

[ogwalfrancis]

Master of function argument array operation, Thanks, Thanks and Thanks Mr. Mike

[chrism]

Thanks again Mike, another great video

[sallyho]

Mike - how to combine two date columns and multioke rows? i.e: 1/1/2000 a1 cell, 1/20/2000 in b1 cell, 1/21/2000 in a2 cell, 4/01/2000 in b2 cell. I wan to combine them into one cell like 1/1/2000 - 4/1/2000. will textjoin work?

[DIGITAL_COOKING]

First I get bored by waiting for Microsoft ...so I did the switch for insider edition
Second I became star where I work just for little knowledge I get from excelisfun channel thumb up for the video mike 👍🙂

[ahmedahmedgoma]

Thank you for the effort and the wonderful explanation

[nsanch]

Thank for the cool text formulas Mike!

[donychen]

F9 to check formula result, Ctrl+Z back to formula, that is really simple and efficient way learn nested formulas, thanks to teacher Mike

[vida]

Great use of Textjoin and Text functions

[rrrprogram]

Awesome Mike .. That was a good one.... whats the winter plan mike ?? Winter is coming :D

[Negi_From_Pauri]

Hey Mike please suggest what is the meaning of X in xlook up like in V/H look up (vertical/horizontal).

[nezarzoneim]

Thanks for you.It's helpful.How can i use textjoin to show group of filtered values in one cell avoiding the duplicate values.

[johnborg]

Thanks mike. The Text function using the # sign for the seperator was great. : ) I need to watch some videos on wildcards to improve.

[wayneedmondson]

Hi Mike.. as always, you outpace the competition with interesting and innovative examples, techniques and solutions. I try to solve first before viewing, but you always add value with bonus formulas, tips and links to more comprehensive videos and playlists. To learn EXCEL, all you need is ExcelIsFun.. one stop shopping :-)) Thanks for the great lesson. Thumbs up!

[drsteele]

Good video, Mike. You showed all the permutations of how to compose those formulas. I've seen all your other excellent videos there that also cover all the permutations.

[katerina]

Great Mike, thank you for all the options

[timmyjan]

How did you paste the formula on line 12 at 2:18