Lookup and return multiple comma-separated values in Excel

No video

Lookup and return multiple comma-separated values in Excel

Рет қаралды 10,634

3 жыл бұрын

Lookup and return multiple comma-separated values in Excel
Link to downloadable file:
drive.google.c...
In this video, we will learn how to lookup a single value or a set of values and return a comma-separated list of matching values in a single cell in Excel. We will use the UNIQUE, IF, and TEXTJOIN functions to accomplish this.
Join my Telegram channel: t.me/ExcelatWo...
Check out my OneNote course: www.udemy.com/...
Check out my Excel certification course: www.udemy.com/...
This channel focuses on the mindset and tools you require to excel at your work, be it in the workplace or in your life. We have over 100 videos on Excel and 30 on Power Query. Please check out the playlists.
Do subscribe to the channel. And hit that Bell notification icon.
Please subscribe to my KZfaq channel and click the BELL icon to get the tips the moment I post them!
I recommend that you start with my playlists.
I make videos on:
Excel: • Microsoft Excel
Google Sheets: • Google Sheets
Japanese and Language Learning: • Playlist
Microsoft Office (Word, Excel, PowerPoint, Outlook, and OneNote): • Microsoft Office
If you like my video(s), encourage me by buying me a coffee:
www.buymeacoff...
Image credits: Pixabay.Com
Consider supporting me on Patreon: / unleashyourproductivity
"Copyright Disclaimer Under Section 107 of the Copyright Act 1976, the allowance was made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a copyright law that will otherwise be infringing. Non-profit, educational or personal use"

Пікірлер: 21

@convergencenellore2901 9 ай бұрын

Useful program and you had explanation is Excellent 🤝

@nomadmathematician400 5 ай бұрын

Exactly what I was looking for, thanks heaps.

@ExcelatWork55 3 ай бұрын

Glad I could help

@user-pu3fg3gd4d Жыл бұрын

This was great and exactly what I was looking for. Good job!

@ExcelatWork55 Жыл бұрын

Thanks a lot for your kind words.

@mkkaul2008 6 ай бұрын

This is good for small dataset probably under 100 but not for big dataset like ~4K records

@edwinyulianto3660 Жыл бұрын

Thanks YOU... very useful for me.

@ExcelatWork55 Жыл бұрын

Glad you found the information useful. :)

@aravindarajc Жыл бұрын

Super. Thanks.

@ExcelatWork55 Жыл бұрын

Welcome 😊

@jamesleleji9470 Жыл бұрын

I think this can also be used to check for duplicate names if the first name and last name were reversed using partial match Eg John Snow, Snow John

@ExcelatWork55 Жыл бұрын

Yes, that's why I found it's often useful to return multiple values in a single list.

@diegoxrivera Жыл бұрын

Thank you!!!

@ExcelatWork55 Жыл бұрын

You're welcome!

@swagata_piu 10 ай бұрын

This is awesome 👍

@ExcelatWork55 10 ай бұрын

Thank you.

@likithnagesh1437 2 жыл бұрын

Helped my req. Thanks a ton

@ExcelatWork55 2 жыл бұрын

Thank you for your kind comment, you’re most welcome.

@pulkitkhanna8387 Жыл бұрын

How to use newline character instead of a comma delimiter?

@ExcelatWork55 Жыл бұрын

Sorry for the delayed response. In the delimiter section, you can put the ASCII code of the symbol you want to use as the delimiter. For example, you can use something like: TEXTJOIN(CHAR(13),TRUE,A1,B1). Note that it does not always work for some characters (especially newline character). :(