Excel Formula Challenge: List repeated Alphabets from text string

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

In this video, we breakdown the formula to extract a unique list of repeated aalphabets from a Text string.

00:00 Introduction
00:30 Problem description
01:50 Concept/Solution description
04:45 Solution
09:30 Make formula Spill

Link to Challenge:

Link to Excel Workbook:

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

Комментарии

Thanks for the video, Excelmoments. Great explanation sir. Blessings and keep the good work!

JohnVergaraD

It is certainly a very elegant formula. It has overwhelming logic. Thank you Victor.

IvanCortinas_ES

Another great video Victor, so well explained.

stevereed

Elegant? No kidding. I think I finally learned how to take a column of lookup formulas and write it in one cell using Map. I didn’t really understand Map before. I can’t wait to give it a try tomorrow morning…Thank you Sir! 👍

KevinPGA

Thank you for the explanation sir,
The logic and the use of functions are well explained....great learning from your videos.

sunnybaggu

Nice train of thought Victor... love this video... Will practice it tomorrow morning. Keep these one single cell solution challenges coming. Take care

jazzista

Very very explicit video. Great approach. I definitely would've approached it a different way. But I like this especially cos you used the map and lambda. Thanks for sharing

nonoobott

Great video and I like your explanation of map at the end 👍. My approach would be to stack the unique and distinct values, then get the unique of the stack, then use textjoin and map.

martyc

Dear Momoh,
A harder way to get the same result:
=IFERROR(MAP(A2:A10, LAMBDA(x, LET(a, MID(x, SEQUENCE(LEN(x)), 1), TEXTJOIN(", 🤗

JoseAntonioMorato

Dear Victor, I really love your formula it's working fine, In between I have two small additional queries: <1> For example if my data says "Sunil Anil" I want to find the duplicate of "nil" (Here 3 characters). How can I find it?
<2>How to find the above duplicate of 3 characters from the entire data set (All cell range $A$1:$D$50)
Kindly help me, Thanks

sunilpinto

can you help me, why is this formula not working please...

=MAP(A2:A10, LAMBDA(x,
LET(a, MID(x, SEQUENCE(LEN(x)), 1),
b, FILTER(a, COUNTIF(a, a)>1),
c, CONCAT(UNIQUE(b)&", "), c)))

sunnybaggu

Excel Formula Challenge: List repeated Alphabets from text string

Excel Formula Challenge: List repeated Alphabets from text string

How to Create a Dynamic REPEATED Numbered List in Excel #shorts

How to Combine and Repeat Blocks of Text n Times in Excel (NO Copy Paste and NO Formulas)

Excel Formula Challenge: Find The First Transaction For Each Month

Get common words between Sentences - Excel formula Challenge

Excel Rank Function with different ranks for same values

5 Tricks to Become an Excel Wizard

Create Unique & Random List Dependent Multiple Criteria from Database - Excel Formula Challenge!

Excel Formula Challenge

Find Multiple Match Results in Excel (Easier Solution For ALL Excel versions)

Excel formula Challenge: Count Consecutive 1s in a string

Excel Formula Challenge - Reduce function to Align Cities

Excel How To Compare Two Columns (3 ways) | Excel Formula Hacks

Excel formula challenges - Isograms

Compare Two Columns with Microsoft Excel Power Query | Excel Formula Hacks

Excel formula challenge: Valid IP excel formula

Excel Formula Challenge: missing alphabets

Excel formula challenges - Isograms with MMULT

Excel formula challenge - Top 2 Runners up (No wins)

🧙‍♂️ 5 BEST Excel Shortcuts

Conditional Formatting in Excel | Highlight Marks Pass/Fail #shorts #excel

Use Of Flash Fill In Excel | Split First Name And Last Name Flash Fill @BrainUpp

Excel formula challenge: Words with all vowels (MMULT)

Merge Duplicate Rows in Excel Combining Unique Values in One Cell