Hi,

Put a 1 in a1 then this formula in a2 and drag down

=IF(B2<"No",MAX($A$1:A1)+1,"")

Mike

"Manos" wrote:

I have an excel where in column A i want to create an auto numbering.
In column B i have some codes and value No.
SO i want to count only the lines that have codes, an no the lines that have
value No.

A B
1 sub1
2 sub2
NO
3 sub3

thanks in advance for your prompt response

Manos