Filter Extract a text from excel sheet having similar values

0 votes

I have data in the cell in this format saved in the A column in Excel.

[Amber,Maria,Marian,Mar]

[Maria]

[Marian,Amber,Maria]

[Maria,Marian]

I want a filter for Maria and Marian.

How can I use some regex formula filtering Maria and Marian separately?

Jan 9, 2023 in Others by Kithuzzz
• 38,020 points
337 views

1 answer to this question.

0 votes
ISNUMBER(SEARCH("Maria,",SUBSTITUTE(A1:A4,"]",",")))

 shows TRUE if Maria is found and false if it would only be Marian, not Maria. 

enter image description here

answered Jan 9, 2023 by narikkadan
• 63,720 points

Related Questions In Others

0 votes
1 answer

Stop Excel from automatically converting certain text values to dates

I've discovered that getting the desired result ...READ MORE

answered Dec 29, 2022 in Others by narikkadan
• 63,720 points
458 views
0 votes
1 answer

Converting Textboxes Link and/or Formula to Values in a Copied Sheet using Excel VBA

Copy the values using Range and Value2 With ActiveSheet.UsedRange ...READ MORE

answered Jan 31, 2023 in Others by narikkadan
• 63,720 points
548 views
0 votes
1 answer

Extract Text after Second Underscore in Excel from right side

The UDF to use. The default separator is ...READ MORE

answered Feb 3, 2023 in Others by narikkadan
• 63,720 points
1,108 views
0 votes
1 answer

Google Spreadsheet/ Excel - how to find matching values in column A, having necessary values in column M

Try this: =COUNTIF($M$2:$M$5;A2) If the product is present in ...READ MORE

answered Feb 10, 2023 in Others by narikkadan
• 63,720 points
372 views
0 votes
1 answer

How to split text values by a delimiter?

The Split function is what you are looking for: =Split(A1, ...READ MORE

answered Oct 11, 2022 in Others by narikkadan
• 63,720 points
615 views
0 votes
1 answer

Currency conversion:number to words excel

Try looking for javascript solutions to use ...READ MORE

answered Oct 28, 2022 in Others by narikkadan
• 63,720 points
574 views
+1 vote
1 answer

Excel or Google formula to count occurrences of an 8-digit number within a text string

To match an eight-digit number, you may ...READ MORE

answered Dec 24, 2022 in Others by narikkadan
• 63,720 points
909 views
+1 vote
1 answer

Automatically move an entire row of reference cell when one cell is moved or manipulated

You are describing how manually entered data ...READ MORE

answered Jan 15, 2023 in Others by narikkadan
• 63,720 points
314 views
0 votes
1 answer

Excel: VLOOKUP from a different Sheet

The worksheet name must be included in ...READ MORE

answered Dec 10, 2022 in Others by narikkadan
• 63,720 points
720 views
0 votes
1 answer

How do you populate a google sheets/excel column with cells from a column in another sheet in the same document?

You have two options on chronology: sheet-by-sheet =QUERY({Sheet1!X:Z; Sheet2!X:Z; ...READ MORE

answered Dec 19, 2022 in Others by narikkadan
• 63,720 points
1,507 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP