Query Function in google sheet | Explained Query formula in hindi | Google sheets query function

Поделиться
HTML-код
  • Опубликовано: 6 фев 2025
  • Query Function in google sheet | Explained Query formula in hindi | Google sheets query function tutorial
    #googlesheets #queryingooglesheet #queryfunction #computergyanguruji
    Look the full detail: developers.goo...
    Our second channel
    / computergurujitechnical
    www.amazon.in/shop/computergyanguruji
    Follow us on
    instagram
    / computergyanguruji
    Twitter
    / c_g_guruji
    Facebook
    / computer-gyan-guruji-1...
    MS Excel Videos
    • Hindi English Dictiona...
    MS Excel for Beginners
    • MS Excel Tutorial for ...
    Excel VBA
    • Excel VBA
    MS Word
    • MS Word
    MS PowerPoint
    • MS Power Point
    MS Access
    • MS Access tutorial for...
    MS Paint
    • MS Paint
    MSW Logo
    • MSWLogo
    Notepad & HTML
    • Notepad complete tutor...
    CSS
    • Introduction to CSS | ...
    Computer Education
    • Education
    Other
    • Other video
    Tally
    • Tally ERP.9 Rules of D...
    Internet
    • internet
    Computer GK
    • GK
    Google Sheet
    • google sheet
    Reasoning
    • Reasoning
    Airthmatics
    • Airthmetic

Комментарии • 62

  • @shivamsingh-nq8nz
    @shivamsingh-nq8nz Месяц назад +1

    bahut achha laga , thankyou sir , please full video banao app mujhe or bhi sekhna hai (query)

  • @rajendranawale372
    @rajendranawale372 3 года назад +1

    Very helpful God bless you

  • @GurdevSingh-wg1cs
    @GurdevSingh-wg1cs 2 года назад

    FANTASTIC. Solution of all problems.

  • @MangalKumar-p1i
    @MangalKumar-p1i 24 дня назад

    Thank you Sir

  • @pramodchandelpkc
    @pramodchandelpkc Год назад

    Thanks for Sharing.

  • @sabirhaque5660
    @sabirhaque5660 3 года назад

    Hello sir
    Excellent sir
    Next video...

  • @ekramhossain7014
    @ekramhossain7014 2 года назад

    thank sir, I think this your best performance

  • @SinghDavinder007
    @SinghDavinder007 3 года назад

    Very very nice video sir....thanks

  • @ravitrivedi2755
    @ravitrivedi2755 6 месяцев назад

    Subscribe done. Thank you sir..

  • @rooneychauhan7718
    @rooneychauhan7718 3 года назад

    Amazing video sir 👏👏👏

  • @josephsrampickal4308
    @josephsrampickal4308 Год назад

    Ur videos are informative n interesting. i hv downloaded 365 however when i tap Option button it

  • @snkk656
    @snkk656 3 года назад

    Excellent sir.

  • @zakirabanu5316
    @zakirabanu5316 Год назад

    Excellent

  • @rana1018
    @rana1018 3 года назад +1

    V nice

  • @mallukatabu6193
    @mallukatabu6193 2 года назад

    sir its not easy to learn ,,,,,,,,,it comes only practice thanks

  • @manishbansal3298
    @manishbansal3298 3 года назад +1

    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.

  • @TheVikram111
    @TheVikram111 7 месяцев назад

    sir hum two dates ke bich me ka datta sum kase kr sakte hai

  • @MuhammadImran-ue1uv
    @MuhammadImran-ue1uv 24 дня назад

    bro from where i can download practice sheets for this video.Regard

  • @manjannan3976
    @manjannan3976 4 месяца назад

    sir i cant do some work . p;ease solve my problem . i learnt google sheet work through ur videos ... now my problem is ... i have two sheets destination sheet is 2024-25 and another source sheet is milk2024-25 . i need to fill merged rows (B4,B5,B6,B7 )with sum formula. from the data which is in source sheet same row cells c6,d6,e6,f6,g6,,, i have done this .. i failed when i copied this to next 4 merged cells B8,B9,B10,B12. from the data c7,d7,e7,f7,g7

  • @shivkumar3435
    @shivkumar3435 3 года назад

    Good

  • @prashanttyagi1156
    @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

  • @vaghelavashubha1561
    @vaghelavashubha1561 2 года назад

    Sir muje stocks market ki google sheet banani he uska formula kayahe batao

  • @umeshray3463
    @umeshray3463 3 года назад

    I like your vedio very mutch ishka dusra vedio lode Karen umesh ray

  • @mahendrapratapsingh9890
    @mahendrapratapsingh9890 2 года назад

    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

  • @ImransCreativity
    @ImransCreativity 3 года назад

    nice

  • @pakiatanonlinecoachingcenter
    @pakiatanonlinecoachingcenter 9 месяцев назад

    If there is blank rowsbin between data how to not show

  • @salenakabobby-flowermen
    @salenakabobby-flowermen 3 года назад

    Boath uttam query ka gyan.

  • @SohelRana-jh7mn
    @SohelRana-jh7mn 10 месяцев назад

    Sir order by sum (F) desc
    Kam kaetehe asce kam nehi kaetehe

  • @mdkamaluddin3539
    @mdkamaluddin3539 2 года назад

    यदि एक ही सेल में नंबर और टेक्स्ट कैसे जोड़ा जाए तो कृपया यू अपलोड करने के लिए उपयोगी वीडियो अपलोड करने के लिए अच्छा अच्छा उपयोगी वीडियो बताएं

  • @MonojMondol-jf9pk
    @MonojMondol-jf9pk Год назад

    hello sir,
    Can i use arrayformula with Query formula

  • @manojprajapati9415
    @manojprajapati9415 Год назад

    Google sheet main table main Conrad

  • @coolcalm582
    @coolcalm582 4 месяца назад

    sir leila gherani mam ka video copy paste marte ho....copyright aa jayega

  • @shaifulislam6746
    @shaifulislam6746 3 года назад

    Please Google sheets ka series tutorial upload.

  • @manishbansal3298
    @manishbansal3298 3 года назад

    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 .

  • @JKBright-l9d
    @JKBright-l9d Год назад

    Google Sheet Me Query function 10+ Column not showing.. . any suggestion?

  • @euroindiaseafood9647
    @euroindiaseafood9647 2 года назад

    Hello Sir, how to insert blank row automatically between data in google sheet

  • @dipaksingh1751
    @dipaksingh1751 3 года назад

    Bhai google sheet mai data copy another sheet mai past value automatic. Pls one video.

    • @vinodgupta9686
      @vinodgupta9686 2 года назад

      try importance formula

    • @B4ALLB4U
      @B4ALLB4U 2 года назад +1

      @@vinodgupta9686 Hi.... I think you have entered importance instead of importrange.

  • @deveshkumarsharma843
    @deveshkumarsharma843 Год назад

    query function doesn't retrieve text values between number values

  • @BharatKumarModibbm_111
    @BharatKumarModibbm_111 3 года назад

    Sir google sheet me selected data ko copy as picture kaise kar sakte hai?

  • @futurekids7783
    @futurekids7783 2 года назад

    query with match group

  • @govindahir826
    @govindahir826 2 года назад

    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

  • @SunilHYadav
    @SunilHYadav Год назад

    sir google sheet me pivot table ke sab row column hindi me show hone lage hai. usko phir se english me kaise kare ?

  • @mohdumarkhan7361
    @mohdumarkhan7361 3 года назад

    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

    • @vinodgupta9686
      @vinodgupta9686 2 года назад +1

      "SELECT B, D WHERE D = 500"
      (note: d is rate column)

  • @rajajani5494
    @rajajani5494 3 года назад

    sir query function ko detailed bana sakte ho kya ? pranam

  • @misssomod194
    @misssomod194 2 года назад

    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.

  • @deveshkumarsharma843
    @deveshkumarsharma843 2 года назад

    Cell reference 'BY' gives an error,. How could I resolve it

  • @MrMayankpasi
    @MrMayankpasi 2 года назад

    Agye mughe only one cell ka data lana he to kya krege??

  • @ekramhossain7014
    @ekramhossain7014 2 года назад

    I can't able to understand col1 col2 col3, would you write formula on there?

  • @raghutilakdas9964
    @raghutilakdas9964 3 года назад

    muje char paanch sheets se data utana hai tab kya karna ?

    • @B4ALLB4U
      @B4ALLB4U 2 года назад

      You can use importrange function to select the data from multiple sheets.

  • @inspirestitch6403
    @inspirestitch6403 2 года назад

    Naqal

  • @kdkumar2676
    @kdkumar2676 2 года назад

    Formula not working

  • @1anamika.chauhan
    @1anamika.chauhan 2 года назад +1

    nice

  • @qazimtahir
    @qazimtahir Год назад

    Excellent 👍

  • @focushealth8007
    @focushealth8007 3 года назад +2

    Useful information 😌😇