Finding specific patterns of text in data

[MickyT7]

Hi all, new to this forum as looking for a place where real life people can help.

Ok so here goes-

I have a large set of (text) data and in one specific column there is a varying list of different status codes in each row. These status codes are random, but do have a pattern I'd like to be able to mark across all the data where possible.

Eg of status codes and pattern I'd like to be able to identify on mass

Cell A1 = Performance
Cell A2 = Outbound aux
Cell A3 = Outbound call
Cell A4 = Ready
Cell A5 = Outbound aux
Cell A6 = Performance

The pattern I'd like to mark a '1' against whenever it occurs is when Outbound aux is seen and then no Outbound call occurs directly after it in the next cell below.

So in summary- if the pattern is seen between Cells A2-A3 then I'm not interested and do not want to mark this, only when something like A5 occurs and Outbound call is not the next event in the list.

Hope that makes sense all and thanks for any help you send my way.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(AND(A1="Outbound aux",A2<>"Outbound call"),1,"")

 

[Sufiyan97]

Is it what you want?

Book10
	A	B
1	Performance
2	Outbound aux
3	Outbound call
4	Ready
5	Outbound aux	1
6	Performance
Sheet1

Cell Formulas
Range	Formula
B1:B6	B1	=IF(AND(A1="Outbound aux",A2<>"Outbound Call"),1,"")

 

[MickyT7]

Is it what you want?

Book10
	A	B
1	Performance
2	Outbound aux
3	Outbound call
4	Ready
5	Outbound aux	1
6	Performance
Sheet1

Cell Formulas
Range	Formula
B1:B6	B1	=IF(AND(A1="Outbound aux",A2<>"Outbound Call"),1,"")

Thanks for your speedy reply.

Works perfectly

 

[MickyT7]

Hi & welcome to MrExcel.
How about

=IF(AND(A1="Outbound aux",A2<>"Outbound call"),1,"")

Thanks for your speedy reply

This is grand, appreciate it very much

 

[Fluff]

Glad we could help & thanks for the feedback.