Formula Reqd for Writing SL no after blanks

[rush2rajen]

Hi Excel Gurus,

Please help ....



Thanks & Regards
Raj

 

[Somendra Misra]

Hi Raj,

Try below formula in C2 and copy down:

=IF(D2="","",MAX(C$1:C1)+1)

Regards,

 

[rush2rajen]

Thanks Misraji

 

[Khalid NGO]

Hi Rajen,

see the attached file:
=IF(ISTEXT(D2),LARGE($C$2:C2,1),"")

 

[Somendra Misra]

You are Welcome Raj.

@Khalid NGO ... can you review your method and OP requirement..

Regards,

 

[Khalid NGO]

You are Welcome Raj.

@Khalid NGO ... can you review your method and OP requirement..

Regards,

Oops... I tried my formula in col F
SM Sir thats the difference between normal and Ninja's eye...

I should wrote like this:
=IF(ISTEXT(D2),MAX($C$1:C1)+1,"")

But your formula is much better and easy to understand.
Thanking you as always.