Amazing video sir. Can you please make a video on how to analyse and segregate the transaction in bank account statements. Like if the transaction description contains word "ATM" then this will be sum under cash withdrawal and if the description string has any word as CHG or annual charge. Then this automatically comes under Bank charges head.
@1anamika.chauhan2 жыл бұрын
nice
@ravitrivedi2755Ай бұрын
Subscribe done. Thank you sir..
@pramodchandelpkc Жыл бұрын
Thanks for Sharing.
@qazimtahir Жыл бұрын
Excellent 👍
@zakirabanu53169 ай бұрын
Excellent
@rana10183 жыл бұрын
V nice
@josephsrampickal4308 Жыл бұрын
Ur videos are informative n interesting. i hv downloaded 365 however when i tap Option button it
@mahendrapratapsingh9890 Жыл бұрын
Thanks a lot for the very helpful video. Sir how can we change the case of a letter by using "format" in query pls help
@mallukatabu6193 Жыл бұрын
sir its not easy to learn ,,,,,,,,,it comes only practice thanks
@shivkumar34353 жыл бұрын
Good
@TheVikram1112 ай бұрын
sir hum two dates ke bich me ka datta sum kase kr sakte hai
@prashanttyagi1156 Жыл бұрын
Sir., Mere password 1 google sheets mein alag alag name se kuch sheets hain. , requirement hai ki , ik main sheet banani hai jis mein kisi sheet se kisi bhe colum ki kahin beech beech mein se range chahiye. but lookup karne ke liye koi common value nahi hai, but koi bhi sheet mein koi bhi sheet mein koi data enter karta hai to main sheet mein auto udate ho jaye. Is it possible, please guide kare . sab sheet mein alag alag heading hain kisi sheet se koi colour se range lene hai, kisi se koi. Lekin koi bhi apni apni sheet mein kuch bhe enter ya change kare to mere main sheet automatic update hone chahiye. Bahut jaruri hai. Please
@manishbansal32983 жыл бұрын
Sir, I want to know my net worth and also want to track where the expenditure was made like food, investment and year wise want to know. And also want to track at what rate the networth was increasing per month over a period of time. For this I want to analyse the bank statements, for which if the description of bank statement has particular word then transaction should be classified into particular type and it's amount get added. Example Description contains " micr chg dt 234". Now since it contains the word chg so it should automatically classified as bank charge and it's amount get added into.the bank.charge head .
@shaifulislam67463 жыл бұрын
Please Google sheets ka series tutorial upload.
@pakiatanonlinecoachingcenter4 ай бұрын
If there is blank rowsbin between data how to not show
@BharatKumarModibbm_1113 жыл бұрын
Sir google sheet me selected data ko copy as picture kaise kar sakte hai?
@vaghelavashubha1561 Жыл бұрын
Sir muje stocks market ki google sheet banani he uska formula kayahe batao
@SohelRana-jh7mn5 ай бұрын
Sir order by sum (F) desc Kam kaetehe asce kam nehi kaetehe
@misssomod1942 жыл бұрын
Hi, could you help me with this, I have 4 columns with checkboxes "true or false values", and a columns with text, I want to use Query to count true values on all 4 columns and group them in text column.
@manojprajapati941510 ай бұрын
Google sheet main table main Conrad
@deveshkumarsharma843 Жыл бұрын
query function doesn't retrieve text values between number values
@umeshray34632 жыл бұрын
I like your vedio very mutch ishka dusra vedio lode Karen umesh ray
@euroindiaseafood9647 Жыл бұрын
Hello Sir, how to insert blank row automatically between data in google sheet
@MonojMondol-jf9pk Жыл бұрын
hello sir, Can i use arrayformula with Query formula
@MonojMondol-jf9pk Жыл бұрын
Sir, is it possible ....kindly tell us
@rajajani54943 жыл бұрын
sir query function ko detailed bana sakte ho kya ? pranam
@salenakabobby-flowermen3 жыл бұрын
Boath uttam query ka gyan.
@govindahir8262 жыл бұрын
Sir aek problem aa rahi he please sir help Problem he ki 1 hi call me number & word Ho tab ye formula kar ne par blank call aa jata he to, vu blank call na aye hos ke liye kya kare 🙏 please provide solutions
@ekramhossain7014 Жыл бұрын
I can't able to understand col1 col2 col3, would you write formula on there?
@dipaksingh17512 жыл бұрын
Bhai google sheet mai data copy another sheet mai past value automatic. Pls one video.
@vinodgupta96862 жыл бұрын
try importance formula
@B4ALLB4U2 жыл бұрын
@@vinodgupta9686 Hi.... I think you have entered importance instead of importrange.
@user-dc8bw5cq5j Жыл бұрын
Google Sheet Me Query function 10+ Column not showing.. . any suggestion?
@mohdumarkhan73612 жыл бұрын
Sir Column B aur rate chahiye but jo Rate 500 ke barabar ho ya usse kam ho wo hee haiye wo.query se kaise hoga
@vinodgupta96862 жыл бұрын
"SELECT B, D WHERE D = 500" (note: d is rate column)
@futurekids77832 жыл бұрын
query with match group
@mdkamaluddin3539 Жыл бұрын
यदि एक ही सेल में नंबर और टेक्स्ट कैसे जोड़ा जाए तो कृपया यू अपलोड करने के लिए उपयोगी वीडियो अपलोड करने के लिए अच्छा अच्छा उपयोगी वीडियो बताएं
@MrMayankpasi Жыл бұрын
Agye mughe only one cell ka data lana he to kya krege??
@deveshkumarsharma843 Жыл бұрын
Cell reference 'BY' gives an error,. How could I resolve it
@SunilHYadav8 ай бұрын
sir google sheet me pivot table ke sab row column hindi me show hone lage hai. usko phir se english me kaise kare ?
@ComputerGyanGuruji8 ай бұрын
off the translator
@kdkumar2676 Жыл бұрын
Formula not working
@raghutilakdas99642 жыл бұрын
muje char paanch sheets se data utana hai tab kya karna ?
@B4ALLB4U2 жыл бұрын
You can use importrange function to select the data from multiple sheets.