Formula for showing the number in A Column

[JamesLT]

Hi Experts,



Is there any way that I could use a single formula to loop the C column instead of placing the same formula with different Cell A values for cell C4, C11 & C17?

Million Thanks!

Best Regards,
James

 

[steve the fish]

Try this is C4 and drag down:

=IF(B4="","",IF(AND(C3="",ISNUMBER(SEARCH("(",A3))),MID(A3,FIND("(",A3)+1,FIND(")",A3)-FIND("(",A3)-1),C3))

 

[gaz_chops]

Or try

=IF(B4="","",IF(AND(ISTEXT(A3),ISNUMBER(A4)),LEFT(RIGHT($A3,7),6),C3))

Again in C4 and copy down.

Gaz

 

[Phuoc]

One way:

=IF(B4="","",LEFT(RIGHT(LOOKUP("zzzzzzz",$A$3:A3),7),6))

 

[JamesLT]

Thank you Steve, Gaz and Phuoc. You guys save my day.

I get your idea now. The key part is if(And(condition 1, condition 2)...

Appreciate your help!
James