Excel stating not a valid formula when the same formula is working in another spreadsheet...

[willow1985]

Hello,

I was hoping someone would be able to help me with the below formula:

="CC "&AGGREGATE(14,6,MID(A3:A1000000,4,9)/(LEFT(A3:A1000000,3)="CC",1)+1

I have the same formula in another sheet:

="IAR "&AGGREGATE(14,6,MID(A$4:A$999952,4,9)/(LEFT(A$4:A$999952,3)="IAR"),1)+1

and it works just fine. I wanted to adapt the new one to find the next number sequence in one that starts with CC however excel is giving me the error when you are missing a bracket or the like. The number sequences look like: CC 1234

I hope someone can see what I am missing.

Thank you

Carla

 

[Fluff]

You need to change the MID function to look at the 3rd character, rather than the 4th

 

[willow1985]

Ah now I see, thank you so much!!

 

[Fluff]

You're welcome & thanks for the feedback