Printable View
Looking for the last number to begin (* 1) (* 2)
Hi Couple of wys.. =LOOKUP(2,1/(LEFT(C4:C16,2)="1*"),C4:C16) =LOOKUP(9.999E+307,FIND("1*",C4:C16),C4:C16)
very good thank you
