How to Return Multiple Values in a Single Cell (and never forget)

In this video we will learn and understanding how to return multiple values in a single cell in a way that you will never forget. We will not rely on Excel’s lookup functions but just the TEXTJOIN and IF functions. I use Excel’s formula interface to help you understand how the formulas work and why they are used.

00:00 Introduction
00:08 Data transformation, problem and solution
00:52 Find unique values in a range
01:25 The Formula we need
02:16 IF function demonstration and explanation
03:48 TEXTJOIN function demonstration and explanation
04:44 Combine TEXTJOIN and IF functions
05:17 Recap and conclusion

Functions covered:
- TextJoin – combine multiple values
- Unique – find distinct values
- IF – decide on the values to return