Excel Magic Trick 1399: Join All Dates Together in a Cell using TEXTJOIN & TEXT Array Formula

preview_player
Показать описание
Download Files:

See how to Join All Dates Together in a Cell using TEXTJOIN & TEXT Array Formula.
Link to get "Insider Edition" from Microsoft:
  1. excelisfun
  2. Excel
  3. Microsoft Excel
  4. Highline College
  5. Mike Girvin
  6. excelisfun
Рекомендации по теме
Excel Magic Trick 0:03:54

Excel Magic Trick 1399: Join All Dates Together in a Cell using TEXTJOIN & TEXT Array Formula

Excel Magic Trick 0:10:51

Excel Magic Trick 1400: Conditionally Format Row in Class Enrollment Table with Complex Criteria

Excel Formula Trick 0:00:31

Excel Formula Trick Short Video =Textjoin formula #short #video #computer #excel

Format painter trick 0:00:33

Format painter trick 🤩 Save your time with tricks

E1H4 - Worksheet 0:11:47

E1H4 - Worksheet Formatting

Non-Formula Approach to 0:01:12

Non-Formula Approach to get Serial Number Groups in Excel

Z fold 3 0:00:16

Z fold 3 Removing old Screen protector#youtubeshorts #shorts

How to use 0:13:47

How to use Index Function Array & Reference

The Magic of 1:01:43

The Magic of Excel: Formulas, PivotTables, Charts, Flash Fill, Sort, Filtering, Functions & more...

E1H3 - Worksheet 0:17:38

E1H3 - Worksheet Structure and Clipboard Tasks

Lookup Items in 0:06:53

Lookup Items in Row Separated by Line Feed [2 Examples]

Export Trackster 3 0:06:49

Export Trackster 3 Data To Excel

TEXT Functions - 0:02:54

TEXT Functions - Tutorial - Excel 2013

Combining / Stacking 0:08:05

Combining / Stacking 3 Monthly Sales Tables - Advanced Table Expansion - Power Query Jumpstarter

AppliancePro Pairing your 0:03:32

AppliancePro Pairing your remote - Auto detect method

Excel Lesson 31 0:11:38

Excel Lesson 31 - Retrieve Data From MySQL Database Using MS Query

How to use 0:02:18

How to use SUMPRODUCT in Excel 🔢 SUMPRODUCT uses in Excel

How to multiple 0:06:29

How to multiple file find, replace in excel? Use advance excel find and replace in excel

assign uniq identifier 0:02:28

assign uniq identifier or serial number to duplicate or uinq values based on any column

Essential MS Excel 2:09:28

Essential MS Excel Learning For Business | JITO in association with Excel in Excel - 2

New Xlookup Function: 0:20:55

New Xlookup Function: A Vlookup Comparison

Dynamic Data Series 0:09:02

Dynamic Data Series Label and Gap percentage on the Actual line in Chart

MSPTDA 09 Power 1:07:27

MSPTDA 09 Power Query Complete M Code Introduction: Values, let, Lookup, Functions, Parameters, More

Making things happen 0:13:05

Making things happen at the right moment with XL-VBA

Комментарии
Автор

Just when I think I know all about this, I learn something new. It's magic, for me.

kiya
Автор

Thank you friend, I am searching this method over than two weeks, thank you🌹

maniestharakula
Автор

Textjoin is not ignoring my empty cells now, instead the text is turning empty cells into 00- jan (the first date). why is that happening?

nandinisharma
Автор

YOU ARE LEGEND. Thank you very much
😄

enesbilir
Автор

WOW!!!! Very clever. You've got me thinking about uses for this.

OzduSoleilDATA
Автор

Hi Mike, Big fan of your work, thank you for all your hard work. I quick question. Can you add vlookup or index match to this formula? ex, If I want to look for certain dates and bring them to one cell, is it possible to do that?

josephlee
Автор

Mike, you don't need to be an Insider to have the TEXTJOIN function but your version and build of Excel has to be Version 1602 (Build 6741.2048) or newer.

brianxyz
Автор

Nice trick. But what can someone do when "TEXTJOIN" is not available? :(

zaighamuddinfarooqui
Автор

What is the meaning of this (=SUM(IF(D:D=I5;J5))). Could some one explain it?

MrXroom
Автор

Looks like I already have TEXTJOIN without being part of the Office Insider program :)

EXDEE