Find the Position of String in a comma separated cell

**Praveenk** · 12-15-2015, 05:40 AM

Hi,

Is there a way to count the position of a string in a comma separated cell.

For Ex: 1. Sun, Mon, Tue.
2. Mon, Tue, Sun, Wed.

Here I want to find the position of the String "Sun" ------> In the first case Answer should be "1" and in the 2nd case answer should be "3".

Thanks

**Tony Valko** · 12-15-2015, 05:47 AM

Try this...

Data Range

	A	B	C	D
4	Data		Find	Position
5	Sun, Mon, Tue		Sun	1
6	Mon, Tue, Sun, Wed			3
7	Wed, Thu, Fri, Sun			4
8	------	------	------	------

This formula entered in D5 and copied down:

=LEN(LEFT(A5,SEARCH(C$5,A5)))-LEN(SUBSTITUTE(LEFT(A5,SEARCH(C$5,A5)),",",""))+1

**samba_ravi** · 12-15-2015, 05:56 AM

if exactly the above is the case try below formula
=IFERROR(INT((SEARCH("Tue",A1)+5)/5),"")

Please Login or Register  to view this content.

**Praveenk** · 12-15-2015, 06:19 AM

@nflsales
Thanks

**Praveenk** · 12-15-2015, 06:20 AM

@Tony Valko

Thanks this solved the problem

**Tony Valko** · 12-15-2015, 07:27 AM

You're welcome. Thanks for the feedback!

Find the Position of String in a comma separated cell

LinkBack

Thread Tools

Rate This Thread

Display

Find the Position of String in a comma separated cell

Re: Find the Position of String in a comma separated cell

Re: Find the Position of String in a comma separated cell

Re: Find the Position of String in a comma separated cell

Re: Find the Position of String in a comma separated cell

Re: Find the Position of String in a comma separated cell

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Dynamic COUNTIF function looking for text value in comma-separated string

[SOLVED] Comma separated string element count

[SOLVED] Report position within a comma separated cell

Find the earliest date within comma-separated values

Formula help on comma separated String data?

Formula help on comma separated String data?

Comma separated string

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions