Wednesday, December 23, 2020

EXCEL KE KAMAL KE FORMULE


ISME LAST KE 4 DIGIT KA SUM HO

 JAYEGA AUTOMATIC 

=SUM(OFFSET(B4,4,COUNTA(B4:G4)-4,2,4))

AB ISME AUTOMATIC LAST 3 DIGIT SUM HO😊 JAYNGE
=SUM(OFFSET(B4,4,COUNTA(B4:G4)-3,2,3))

=SUM(OFFSET(B4,MATCH(I8,B4:G10,0),COUNTA(B4:G4)-3,1,3))
-

No comments:

Post a Comment

THANKS FOR YOUR SUPPORT

Subscribe to: Post Comments (Atom)

Data copy paste on two another sheet with add row in google sheet by script

 function copyDataWithinWorkbook() {   var sourceSheetName = "Dashbord"; // Replace with the name of the source sheet   var target...