how can i find a particular word in a cell of array?

January 10, 2018 at 11:13:51
Specs: Windows 10
i have the data like in excel file in one row

Ve
Mo
Sa
Me
La Su Ve
Sa
Ju


i have to find the cell which starts with La in an array


See More: how can i find a particular word in a cell of array?

Reply ↓  Report •

#1
January 10, 2018 at 11:38:25
You say that your data is "in one Row" yet you posted it as if it is in a Column. Does it actually look something like like this?


      A       B       C       D         E         F       G
1     Ve      Mo      Sa      Me     La Su Ve     Sa      Ju


Then you said:

i have to find the cell which starts with La in an array

What do mean by "find the cell"?

Are you looking for the Column letter? e.g. "E"

The cell address? e.g. E1

The position with in the array? e.g. 5

Please clarify your layout and requirements.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code

message edited by DerbyDad03


Reply ↓  Report •

#2
January 11, 2018 at 02:55:49
sorry for the incnveninence,, I need Column wise

i have the data like in excel file in one column.

		  A	B	C	D
		Raasi	Planet		
1		Aries			
2		Taurus	Ve		
3		Gemini			
4		Cancer	Mo		
5		Leo	Sa		
6		Virgo	Me		
7		Libra			
8		Scorp			
9		Sagit	La Su Ju Me		
10		Capri	Sa		
11		Aqua			
12		Pisc	Ju		
					
					
					
15		ANSWER SHOULD BE BELOW			
					
16		PLANET	లగ్నం		
					
17		Su	S		If Su is with La the answer should be S Else N
18		Mo	N		
19		Me	S		If Me is with La the answer should be S Else N
20		Ma	N		
21		Ju	S		If Ju is with La the answer should be S

Thanks in advance
Sankar

message edited by srsr


Reply ↓  Report •

#3
January 11, 2018 at 03:57:30
Please click on the How-To link at the end of this post and read the instructions on how to format example data so that it is easier for us to read. Then edit/repost your data so that the columns line up correctly. Don't forget to use Column letters and Row numbers as shown in the example.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •

Related Solutions

#4
January 11, 2018 at 23:32:25

		  A	B	C	D
		Raasi	Planet		
1		Aries			
2		Taurus	Ve		
3		Gemini			
4		Cancer	Mo		
5		Leo	Sa		
6		Virgo	Me		
7		Libra			
8		Scorp			
9		Sagit	La Su Ju Me		
10		Capri	Sa		
11		Aqua			
12		Pisc	Ju		
					
					
					
15		ANSWER SHOULD BE BELOW			
					
16		PLANET	LAGNAM		
					
17		Su	S		If PLANET(Su) is with La the answer should be (LAGNAM) S Else N
18		Mo	N		
19		Me	S		If Me is with La the answer should be S Else N
20		Ma	N		
21		Ju	S		If Ju is with La the answer should be S


Thank you for the information

Reply ↓  Report •

Ask Question