Create auto numbering
Hi,
Really not much of an improvement, but a tiny bit shorter:
=IF(B2="No","",MAX(A$1:A1)+1)
--
Thanks,
Shane Devenshire
"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
|