List all instances where a specific digit is contained in text

**Frumpelmelm** · 09-11-2022, 07:27 AM

Hi,

I've never posted here before but wanted help with this problem. If you could help, I'd be very grateful.

At work I have a list of text and digits that I need to separate into parts. It is a bit like a phonetic dictionary.
Expanded Data.png

What I am trying to do is to find every instance of the highest number.
Highest Number and Data.png

I have been able to find the first instance using INDEX MATCH. This is the specific formula I have used.
INDEX MATCH.png

The problem is that I need this to return every instance of the highest digit. For the word "absolutism". I would need this to return both "uw2" and "ih2"".
absolutism specifically.png

If you know how I could get the formula to give every instance of the highest digit (and return the attached letters), I would be so grateful.

Thanks,

**Pepe Le Mokko** · 09-11-2022, 08:30 AM

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**Frumpelmelm** · 09-11-2022, 10:53 AM

Here is a template workbook,

Example.xlsx

**JohnTopley** · 09-11-2022, 11:14 AM

Try

in H4 and copy down

=IFERROR(INDEX($K4:$U4,AGGREGATE(15,6,(COLUMN($K$1:$U$1)-COLUMN($K$1)+1)/(--RIGHT($K4:$U4,1)=$G4),COLUMN(A$1))),"")

**Frumpelmelm** · 09-13-2022, 12:08 PM

Thanks John!

That's absolutely worked, even for instances with 3+ results to return. Perfect.

Thanks so much,

List all instances where a specific digit is contained in text

LinkBack

Thread Tools

Rate This Thread

Display

List all instances where a specific digit is contained in text

Re: List all instances where a specific digit is contained in text

Re: List all instances where a specific digit is contained in text

Re: List all instances where a specific digit is contained in text

Re: List all instances where a specific digit is contained in text

Thread Information

Users Browsing this Thread

Similar Threads

Return a value if specific text is contained in range.

[SOLVED] Conditional format a list if some of its text is contained in another list

[SOLVED] Search for the first cell that contained a specific text

[SOLVED] Return specific text if a different text is contained anywhere in a range of cells

Entering 5 digit number, where each digit creates a specific result based on a list.

[SOLVED] Countif function for instances of text string contained

[SOLVED] RE: Countif function for instances of text string contained

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions