Thread: Returning row # using match or index of repeated text in a complex table
View Single Post
  #10   Report Post  
DOR
 
Posts: n/a
Default Returning row # using match or index of repeated text in a complex table
An alternative simple formula, for putting the company name in column
B, which treats everything that is not in the format "Qnnn" as a
company name is

=IF(AND(LEFT(A2)="Q",ISNUMBER(VALUE(RIGHT(A2,3)))) ,B1,A2)

Reply With QuoteReply With Quote