ADVANCE FORMULE SE AUTOMATIC SHEET BANAYE IN EXCEL

Advance Formule Ka Automatic  Function

Dosto Mere Pas Ek Table Hai Aur Ye Table Bahut Bada Hai Mujhe Isme Party Wise Sale Dekhni Hai Aur Ye Dekhna He Ki Kitni Bar Is Party Ko Sale Hua  Hai Aur Ye Party Ka Town Aur District Kya Hai Aur Kya Ye Part Closed Ho Gayi Hai Ya Non Billing Hai  To Chalye Shuru Karte Hai

( Dosto Dhyan Dena Hamara Data P2 Name Ke Sheet Pe Hai Waha Se Hum Dusri Sheet Pe Formula Laga Rahe Hai)

  

To Dosto Sabse Pahle Hum Jo Heading Chahiye Use Copy Karke Paste Kar Lete Hai                                                                                        

Asm

Ss Name

So/ Tsi

District

Town

Distributor   Firm Name

Moth Name

Billing Period

 Ab Is Heading Ke Niche Formulas Lagayenge Jaise Ki Only Party Ke Name Se Sabhi Ki Information  A Jaye Aur Ye Bhi Pata Chal Jaye Ki Party Closed Ha Runing Hai Ya Kitni Billing Hui Hai To Kese Wo Me Aj Sikhaunga To Chalye Shuru Karte (Dosto Formulas Laga Dya Hai)

(Sabhi Formulas Ki Shuruat = Se Hi Hoti He)

 

Result Is Parkar Aya Sabhi Details A Gayi Aur Dosto District Aur Month Wale Cell Me Data Validation Laga Hai Usme Hum List Me Se Koi Sa Bhi Option Choose Karenge  Aur Result Payenge 

District	Distributor Firm Name	1apr 30 Apr	Billing Period
Ghaziabad	Vijay Kumar	0	3

 

 Billing Period Kese Nikala Dosto Iska Jugad Kya Hai Humne Ek Alag Table Banaya Aur Usme Formule Se Sabhi Month Wise Billing Nikali Aur Fir Billing Ko Count Karke Billing Period Me Dala Formula Wise Is Tarah Se

DISTRIBUTOR FIRM NAME	APR P2	MAY P2	JUNE P2	JULY P2	AUGP2   1-15.	16 AUG - 15 SEP P2.	16 SEP-15 OCT P2.	16 OCT-15   NOV P2.	16 NOV-15 DEC P2.	16 DEC-15 JAN P2	16 -31 JAN
VIJAY KUMAR	65728	RAM	19889	0	51100	0	0	C	C	C	C

To Dosto Agli Bar Aur Bhi Advance Formule Ki Jankari Dunga

DOSTO YE CLASS CONTINUE JOIN KARTE RAHO AUR SABHI KO YE FREE CLASS KE BARE ME BATAO TAKI SABHI  SIKH SAKE AUR KOI PROBLEM ATI HE TO MUJHE COMMENT JARUR KARNA  (PLS 🙏🙏SHARE KARNA AUR MUJHE FOLLOW JARUR KARNA )

APKA MERE PAGE PE ANE KE LYE DHANYAWAD 🙏🙏🙏🙏 

LINK :- ADVANCEBANO.BLOGSPOT.COM

BY-AAKASH