Filter function को बहुत बढिया समझाया यह data retrieve करने में बहुत लाभदायक है। धन्यवाद।
@MITTALPAPER4 ай бұрын
Bhai.. inventory reorder ke liye agar 2 product ka sum karke reorder karna ho to kaise hoga. 2 product ka 500kg rakhna hai 1 me 100 hai ek me 700 to , re-order dono me na aaye
@rahulthementor48464 ай бұрын
Aapko sum se pehle IF condition lagani hai
@pandurangjadhav77435 ай бұрын
Mobile keyboardमे control, shift जैसे बटनस् के लिए क्या करना चाहिए
@knowledgewithhasu471611 ай бұрын
Sir, ek Google sheet hai us me 4 salesman wise 4 sheet hai har salesman apne Naam Ki sheet me data daily update karke n dusre salesman ki sheet na dekh sake and all salesman sheet manager dekh ske Yeh manage google sheet me kese kare?
@rahulthementor48464 ай бұрын
Protect all sheets and give permission to edit only. Only person with the name should be given access to particular sheet. Aap sheet protect karo or jis person ke name ki sheet hai usko hi edit ki permission do. Better ye hai aap sabko alag workbook de usse ek master create kar le so that manager can see.
@ramanakumar684311 ай бұрын
please share data set to work along with the video
@ramanakumar684311 ай бұрын
please share data set to work along with the video
@ramanakumar684311 ай бұрын
please share data set to work along with the video
@ramanakumar684311 ай бұрын
please share data set to work along with the video
@ramanakumar684311 ай бұрын
please share data set to work along with the video
@RahulKumar-rf6cc Жыл бұрын
Sir ya jo sheets hai in ka link description ma dal dijya taki or help ho jaye
@rahulthementor48464 ай бұрын
Ok
@CprtFM Жыл бұрын
Bhai, thank you for your video help. Ek help kar sakte ho, Multiple selection Data validation list create kar sakte ho ? Matlab end result, ek cell mein saare multiple times selected items (from drop down list) aane chahiye. Thank you!
@rahulthementor4846 Жыл бұрын
Thanks for watching. will be happy agar aap koi example ye koi image ka link de do kaise chaiye aapko. will do that
@muhammadumer4382 Жыл бұрын
Jazakallah
@niluns1579 Жыл бұрын
Sir Mai Roj Ek Hi Sheet Me Daily Data Entry karta Hu But Ek Problem Hai Jab bhi Sheet Open Karta Hu Tab First Column Se Open Hota But Muze jo Last Type Kiya Huwa Column hai Wo Open Huwe Jise Muze Har Bar Nicche Scroll Karke Last Column ko dhundna na pade Plz Sir Help Karo
@nitinsud927 Жыл бұрын
Control down arrow Karo..
@hariomsoni7265 Жыл бұрын
contact num. plzzz
@samvitkhandelwal814 Жыл бұрын
Thank you 😀😀
@NafisaShaikh-kp5hn Жыл бұрын
Sir ji Google sheets me range ko table me convert kese kare 🙏problem ye he ki hare pas crombook he😔
@rahulthementor4846 Жыл бұрын
Show me data. Share link of data in comment.
@NafisaShaikh-kp5hn Жыл бұрын
Thank you so much sir 🙏🙏 kafi time se pareshan ho rahe the sir aap ki is video 21:51pr humari problem ka solution mila hai learn more,innozant kisi bhi channel ne is ka jawab nahi Diya 🙏🙏🙏🙏🙏🙏🙏🙏🙏thank you once again
@rahulthementor4846 Жыл бұрын
Glad you like it
@nitishparmar3698 Жыл бұрын
Well done
@BusinessBananaShikhe Жыл бұрын
Nic,,,
@BusinessBananaShikhe Жыл бұрын
Alg alg colum mai data ha ushe ek kai niche ek mai lana hai
@aslamkhan-px1zs Жыл бұрын
Thank you ❤️
@yusufshah2766 Жыл бұрын
Thank you for making video on this topic
@yusufshah2766 Жыл бұрын
Way of explanation awesome boss 🙏
@indermohan242 жыл бұрын
Truly Hidden Treasure I found... Nobody explains like you on youtube, bohat hi badhiya, great👍👍👍👍.
@rahulthementor48462 жыл бұрын
Thanks for watching. Pls share my channel and keep watching
@indermohan242 жыл бұрын
Kya aap FMS, PMS, IMS bhi bta sakte ho kaise create kiya jata hai, mujhe google sheets automation sikhna hai
@rahulthementor48462 жыл бұрын
Will do it further but pls check my all videos. It will also help you in creating fms
@maheshkumarmandal77982 жыл бұрын
Thank you sir very helpfull videos
@abhishekjha99622 жыл бұрын
But Hume ek column se duplicate hatana ho aur Pura row delete karna ho to Kya karege
@jwalbanker2 жыл бұрын
Is there a formula or script to add data automatically from all sheets? I have 30 sheets
@rahulthementor48462 жыл бұрын
Possible
@rahulthementor4846 Жыл бұрын
I can do for you. Pls share exact sheet. I also build customise project on google sheet. Pls share file [email protected]
@rahulthementor4846 Жыл бұрын
You may send your requirement and i can build project as per your requirement in low cost
@NIKHILSHARMA-jm6gv2 жыл бұрын
Very good explanation on arrays, keep it up.. you will grow
@montubiswas62942 жыл бұрын
How to google sheet front size and colour keyboard shortcuts key please provide new video
@rahulthementor48462 жыл бұрын
You may refer below url for keyboard shortcuts in google sheet kzbin.info/www/bejne/m3rKl3evfblspZo
@NDHANUKAUS2 жыл бұрын
Can you provide the Copy of this sheet for practice.
@rahulthementor48462 жыл бұрын
Thanks for your comment. As of now you have to manage from watching video. Actually because of security reason I have lost my file from email id
@jitendraprajapati53562 жыл бұрын
nice
@ankitsharma62202 жыл бұрын
Thank you so much Sir pls share formula sheet also
@rahulthementor48462 жыл бұрын
Thanks for liking. I will create new one for you. For filter you may use ALT +D+F
@syedarshad69852 жыл бұрын
@@rahulthementor4846 you have not shared yet ?
@rahulthementor48462 жыл бұрын
@@syedarshad6985 pls manage by watching my video as of now. I am busy with other things now a days.
@Jatin-nt3cs2 жыл бұрын
Gjjb
@erl4122 жыл бұрын
Hi, I'm trying to make invoice# every Monday. How does it changes automatically every time I open Google sheet. For example, invoice #001 and then the week after invoice #002. Thanks
@rahulthementor48462 жыл бұрын
It is possible but with App script. I have not started App script yet as my formula Series ongoing but for you I have created a Small script which will help you. function autoIncrement() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var ws = ss.getSheetByName("App"); var cellvalue = ws.getRange("A1").getValue(); cellvalue=cellvalue+1; ws.getRange("A1").setValue(cellvalue); } Copy and paste above code in app script editor and Create Trigger onOpen to run this script automatically when you open sheet next time. Change name of your sheet to App or change name in code. Secondly change Invoice number reside in which cell if it is in A1 that fine otherwise change A1 to desire cell name wherever you invoice number exist.
@gootube78212 жыл бұрын
Thanks for sharing Tricks 👍
@FunWithKids-dr2of2 жыл бұрын
Good sir, nice video
@rahulthementor48462 жыл бұрын
Thanks for watching
@mustakeemmustakeem62822 жыл бұрын
Good 👍
@rahulthementor48462 жыл бұрын
Thanks
@mejabelajar2 жыл бұрын
good mentor
@rahulthementor48462 жыл бұрын
Thanks
@vernavong2 жыл бұрын
Hello , I want to share to my collaborator and after they entering the data for 1 hour, that row will be Lock automatic , would you please write script for us please !
@rahulthementor48462 жыл бұрын
What kind of data you have? If you have some limited columns then you may use google form and share the link with collaborator for data entry purpose and you will find all entries with correct timestamp. Secondly, pls do not share master sheet just import the data from master with limited time frame. Let me know if it fine for you.
@vernavong2 жыл бұрын
@@rahulthementor4846 I am not prefer google form
@rahulthementor48462 жыл бұрын
@@vernavong There are multiple way to do this task but you are not willing to work in google form. I am giving you small idea hope you were asking the same thing. please copy and paste code in script editor of sheet which you want to lock. function prtect() { var sheet = SpreadsheetApp.getActive().getSheetByName("Sheet22"); sheet.protect(); } Instead of Sheet22 you will have to put the sheet name there or you may rename your sheet to Sheet22. After that you will have to set up time trigger on the basis of your requirement. However i have not start app script but for your requirement small code for you.
@vernavong2 жыл бұрын
@@rahulthementor4846 I tried what you suggested, by copying this code and paste to the script editor with changing sheet to "sheet22". After that add trigger , select event source = Time-driven , select type of time base on trigger and select minute ! but when i share to my collaborator after he add for few minutes lather he can edit again ! It doesn't work
@rahulthementor48462 жыл бұрын
@@vernavong I personally tested and tried before sharing to you. Right click on tab and checked is there protection added or not. Secondly, before sharing this sheet to collaborator you must set up all configuration. You might have already given edit permission to collaborator. If you still feel issue share file with me.
@shanesharma31953 жыл бұрын
Thanks sir for one more best video.. I learnt lot of things from your videos
@umasharma66153 жыл бұрын
Thanks it was helpful. It looks complicated but you made it simple to understand. Great video👍
@upendralokhande42973 жыл бұрын
Please provide Formula In Description Always when you make video
@rahulthementor48463 жыл бұрын
Sure. Thanks for watching
@ushakarkeerthi99743 жыл бұрын
Very useful video. Thank you
@rahulthementor48463 жыл бұрын
Thanks for watching. Keep supporting and keep sharing.
@rahulthementor48463 жыл бұрын
@1CALLFix Solutions: you may use ArrayFormula(ROW(B2:B)+2107999) formula to generate numbers like 2108001, 2108002, 2108003, 2108004. Let me know in case of any other query. thanks
@nichcolon17353 жыл бұрын
Subscribed! Thank you
@nichcolon17353 жыл бұрын
do you have any tutorial videos for array constrain and array formula and sumproduct?
@rahulthementor48463 жыл бұрын
@@nichcolon1735 kzbin.info/www/bejne/g4jdaaF-iN-inbM Sumproduct tutorial will create soon. Also you can refer playlist where you may found lot of videos in which I have used array
@sachindhende18033 жыл бұрын
कॉलेज के exam का ledger जो word और pdf मे है क्या वो आप excel मे subject के कोड के अनुसार बना सकते हो क्या?