Automatically insert serial number if adjacent cell non blank in excel.

This video to related to appear serial number for only non blank cell.
Sometimes we need to insert serial number automatically according to adjacent cell and only for non blank cell( Means where any data available).
insert serial number
insert serial number automatically in worksheet excel vba
insert serial number in excel
insert serial number only for non blank cell
show count only for non blank cell in excel
insert serial number in excel column
automatically insert serial number in excel
serial number in excel automatic
serial number in excel
how to type serial number in excel automatically
how to get automatically serial number in excel for non blank cell only

[@user-ro3sm5ci3n]

Simple and proper explanation. Thanks❤❤❤

[@webtechpool]

My Pleasure

[@dilipsanjay1074]

thanks for posting this video, this very useful to me

[@webtechpool]

Thank you for your valuable feedback

[@anandkumarprajapati4806]

i was wondering for this solution for my office work. Thanks bro..

[@webtechpool]

Thank you for your valuable feedback

[@AslamShaikh-abd]

Simple and proper explanation. Thanks

[@rj_lab]

Thank you Bhai, from Manila!

[@webtechpool]

Thanks for your feedback..please support to share🙂

[@sanaajaz6327]

Excellent video.
Highly recommend

[@arifshama718]

Great information brother,,thanx

[@webtechpool]

Thank you for your valuable feedback. Please support to share tge channel link

[@sureshv7724]

Thanks Baiya

[@kaushikvishwas9060]

thank you

[@biswajitkaran89]

Amezing , very very informative and useful for Excel user.

[@webtechpool]

Glad it was helpful!

[@satyajitchatterjee3713]

Thankyou

[@loverlynarciete3965]

Thanks

[@ta20111996]

Excellent 👍

[@aqeelahtsham4695]

Good

[@user-gf1er2bp8k]

so good brother

[@webtechpool]

Thank you

[@VijaySharma-do8lj]

Lekin sir agar same name repeat ho to uski jgh 2 likh ana chaiye matlab same value jitni bar enter ho uske repeat no show hone chaiye btao sir plz

[@webtechpool]

By this formula its not possible for that need to take different approach, I will update soon.

[@abitajain1462]

Very well done ✅

[@webtechpool]

Thank you for your comment

[@basantkumarchandola2897]

Excellent. परन्तु मेरा एक प्रश्न है कि यदि कॉलम C में formula लगा हो और कुछ cells ब्लैंक हों तो कॉलम B में क्या फॉर्मूला लगेगा। कृपया
मदद करें।

[@webtechpool]

Thanks for ask question ---No change require same formula rhega only COUNTA ke place pe COUNT use kr skte hai agr required ho to

[@AvinashPahade]

FORMULA PUT KRNE K BAAD ...(0.00 ) LIKHA H USKO BHI COUNT KR RHA H ... me chahta hu ki zero count me nahi aaye

[@webtechpool]

Ap if formula aur add krskte hai if(A1=0,"",here your previous formula)

[@allahbakhsh4270]

GooD 👍

[@webtechpool]

Thanks for your feedback

[@jyotirmoysamaddar409]

Thank u❤

[@webtechpool]

Always welcome

[@imkarrajput5286]

Nice sir

[@jayachitraj5559]

Can we update serial number with in brackets. example [1]

[@webtechpool]

Yes we can update by adding concatenate formula as per below
*IF(G2="","",CONCATENATE("[",COUNTA($G$2:G2),"]"))*

[@ajayameher1076]

Sir aur ek column pe 10-20 tak auto serial number ke liye formula kya he

[@webtechpool]

Thanks for asking
Please mention your question in detial

[@muhammadmujtaba5593]

Kia ye data filter karne se auto update hota h?

[@webtechpool]

Yes

[@moodkn]

Nice

[@webtechpool]

Thanks

[@ibrahimshaikh1765]

To enter double inverted, which key

[@webtechpool]

Shift + '

[@anuj_jain7]

agar hm beach me koi row insert krte hai or uss cell me kuch likhte hai to sr number kyu nhi aata

[@webtechpool]

Please drag formula also to inserted row

[@webtechpool]

Still any problem please comment

[@itsmetherock]

please answer sir me is formula ko laga rha hu to ye C colum me Formula ko bhi count kar rha hai me chata hu kebal value to count kare formula ko nahi

[@webtechpool]

Please watch this video still any query then comment us and thanks for your query
ruclips.net/video/3FDp31USXc8/видео.html

[@subhamburnwal5037]

Only C3 ko hi lock kyu kiya gya hai

[@webtechpool]

Row Count started from C3 so it is fixed next C3 is Variable it shows where till it Expanded.

[@deepakthodaha8060]

nahi ho raha hai sar deepak

[@webtechpool]

Please share exactly where you get stuck

[@pawandawade961]

मेरे पास nhi hua ye

[@webtechpool]

Please Try once definitely it work