Hi,

My report is based on certain search criteria's. I filter data if the cell begins with "BB","CU","SNEAK", hence have used LEFT formula as the position of these letters is fixed in the cell. The only problem i encounter is when i have to filter the data for cell containing the letter "xco", so here i cannot use the left formula.

eg.1 PR : OPPO:FTOT:MOTM:INDEPENDENCE DAY RESURGENCE : TEASER - 2 OSP):XCO:SD15TH AUG 1 PM & 9 PM)
eg.2 HOTSTAR X-(GOT PAGER):XCO:SDGENERIC)

If you see the letters XCO are in middle & the position is also not constant. Hence i wanted to combine the above 2 formulas. The resulting condition column, should either return TRUE, FALSE or numbers 1 to 8 as per the condition in the formula. Any other like TRUE-FALSE will not work for the macro i have recorded. If I use the the formula

=IF(LEFT(A2,2)="BB",1,IF(LEFT(A2,2)="CU",2,IF(LEFT(A2,3)="PR:",3,IF(LEFT(A2 ,5)="SNEAK",4,IF(LEFT(A2,6)="PRECAP",5,IF(LEFT(A2,5)="RECAP",5,IF(LEFT(C3,1 )="L",6,IF(LEFT(A2,7)="Segment",7,IF(LEFT(A2,2)="NA",8,ISTEXT(D3))))))))) ) & " - " & IF(COUNT(SEARCH({"xco","cross"},A2)),"8").......it returns result FALSE-FALSE which will not work with my macro.

P.S.The smileys are brackets