Search results for query: *

  1. R

    numbering rows, but skipping blanks

    My test case id in excel is something like this "TPTP(5.9.9)4.1_140 " .[This Is derived from lookup formula =(LOOKUP(2,1/((A4:A153<>"")*(A4:A153<>"-")),A4:A153)) . ] How can I increment TPTP(5.9.9)4.1_140 to TPTP(5.9.9)4.1_141? please help
Top