Actually, this is better:
=IFERROR(LEFT(INDEX(A:A,SMALL(IF(RIGHT($A$2:$A$33,3)="nfo",ROW($A$2:$A$33)),ROWS(D$2:D2))),LEN(INDEX(A:A,SMALL(IF(RIGHT($A$2:$A$33,3)="nfo",ROW($A$2:$A$33)),ROWS(D$2:D2))))-4),"")
Actually, this is better:
=IFERROR(LEFT(INDEX(A:A,SMALL(IF(RIGHT($A$2:$A$33,3)="nfo",ROW($A$2:$A$33)),ROWS(D$2:D2))),LEN(INDEX(A:A,SMALL(IF(RIGHT($A$2:$A$33,3)="nfo",ROW($A$2:$A$33)),ROWS(D$2:D2))))-4),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks