Sir, एक doubt भी है, कि sumproduct ने क्या array 1 में ही सारी range ले ली? Len के ज़रीये? कृपया इसका logic समझाए | और क्या हम len() में सारी range देकर ctrl+shift+enter कर सकते हैं जिससे वह range एक मानी जाए?
@TeachToEach7 жыл бұрын
Ha ye sab ek hi ban jaegi sumproduct ke liye
@Khushi-bk87q7 жыл бұрын
Awesome
@TeachToEach7 жыл бұрын
Thanks Jitendra Ji
@Radhadaas-yj9hd7 жыл бұрын
Thanks for this new topic
@TeachToEach7 жыл бұрын
Welcome
@amitthesinger7 жыл бұрын
Always coming with a new question !! Good Job !!
@savitarawat49687 жыл бұрын
Gazab
@TeachToEach7 жыл бұрын
Please check your inbox Akshay ji has been sent to you. Dont forget to Like, Comment and Subscribe our channel with bell icon and get new videos notification on your mobile
@satishchaurasia84ya7 жыл бұрын
Superb Ashish sir U r very clear and complete teach us . Keep it up sir thanks
@TeachToEach7 жыл бұрын
Thanks for the comment Satish Ji.
@Wasimsir77 жыл бұрын
#Masha_Allah
@TeachToEach7 жыл бұрын
Thanks for the comment.
@nayacterajeev6 жыл бұрын
Ok
@pankajkamble82167 жыл бұрын
It's good Ashish. Pls suggest any tricks to blank spaces from bulky SAP downloaded data. You have made any video for the pls share it.
agar sir mujhe pta karna ho is array mai sabhi value ki len same hai ya nahi hai wo kaise pta karenge ??
@pankajkamble82167 жыл бұрын
Blank spaces removal from bulky SAP data. Suggest tricks.
@TeachToEach7 жыл бұрын
Have not knowledge about SAP.
@sujitbnr7 жыл бұрын
when i type date like 12.02.2018, i get the answer in next column as February, same as 14.01.2018, answer is January
@SanviPatil20197 жыл бұрын
Ashish sir ap koi bhi formula jo batate ho wo galat nahi batate.. mujhe ap par pura bharaoda he ki ap jo bhi hume sikhayengs wo galat nahi sikhayenge... Yeh formula sikh kar mujhe bahot bahot acha laga..per apse ek meri request he ki mujhe 2 bank statements tally karane he excel ki sahaytase.. mujhe har month bank tally karana hota he... Aur use manually ek ek entries check karneko kafi waqt lagta he .to me apko 2 Bank statment bhejta hu.. usmese kon konsi entries baki he..aur konsi 2 no hi taraf li huvi he wo samjh aye. aur jo entries lena baki he wo highlight ho jaye.. usse wo entries leneke bat meri bank tally ho jayengi.. plz ashish sir yeh formuka sikhao mujhe...
@avinashjadhav24367 жыл бұрын
Hey you!!! its taking the spaces count as well, your formula is not up-to-mark.... not worthy, disappointed,
@TeachToEach7 жыл бұрын
I make it as per question which i defined in this video.. What you want you can customize your formula.. Really sorry if you are disappointed.