FREQUENCY function - Google Sheets

แชร์
ฝัง
  • เผยแพร่เมื่อ 25 ธ.ค. 2024

ความคิดเห็น • 29

  • @lapneto
    @lapneto 3 ปีที่แล้ว +1

    Best teacher on YT. Very clear and also very helpful. Keep it up!

  • @LongTimeTTFan
    @LongTimeTTFan 3 ปีที่แล้ว +2

    Great tip on this Frequency function. Well explained and clearly demonstrated. Thanks a lot.

  • @ManojGuptahome
    @ManojGuptahome 2 ปีที่แล้ว

    Thanks a lot. Great explanation. Your videos are very informative and keep me to come back and learn more of these tips.

  • @shadowthehedgehog9190
    @shadowthehedgehog9190 11 หลายเดือนก่อน

    this was helpful, thanks! i'm trying to make a frequency chart for letters, but i want digraphs to count separately. so t and th are separate, and words that have th don't count for the frequency of t. any ideas on how i could accomplish this?

  • @tsamaraluthfia
    @tsamaraluthfia 3 ปีที่แล้ว +3

    thank you for this! really save some time than using multiple countif 😂

  • @kevinferrabelo4920
    @kevinferrabelo4920 3 ปีที่แล้ว +1

    Can you do a tutorial video on how to auto send response data from a form to an email and have it email to a specific email?

    • @KrisS602
      @KrisS602 3 ปีที่แล้ว

      formMule or other email merge utilities will be your friend here, highly recommended as an add-on for automating custom email responses.

  • @jcheng1981
    @jcheng1981 3 ปีที่แล้ว

    can this be done with hours or date? I am breaking my head thinking how to create a function for a calendar and multiples teachers, that will give me a notice if the teacher is available at certain hour and certain date , kind of an appointment system.

    • @ExcelGoogleSheets
      @ExcelGoogleSheets  3 ปีที่แล้ว

      "can this be done with hours or date?" I don't see why not.

  • @travisgainey7062
    @travisgainey7062 3 ปีที่แล้ว

    I like this a lot! If you were ever looking just for the return of 24 and not 0-24, I’m assuming you would instead use countif?

  • @ai_dividend_daily_1
    @ai_dividend_daily_1 3 ปีที่แล้ว

    great video

  • @SaintHanappi
    @SaintHanappi 3 ปีที่แล้ว

    Weeeee. Very nice 👍

  • @bruno_veloso
    @bruno_veloso 3 ปีที่แล้ว +2

    Cool how it ignores the blank condition and the output for the last value is every data entry that doesn't match any of the classes given.

  • @nature8137
    @nature8137 3 ปีที่แล้ว

    Hello Sir! Please let me know how can i protect my data in sheets , I want no user to copy data from my sheets,, which formulas will be useful please help

  • @dumacco5083
    @dumacco5083 3 ปีที่แล้ว +1

    Thank you, your videos are great.
    I know this is out of the topic regarding your videos above. But how could I delete columns with blank cells, using a formula or app script? I've been following your codes, and it worked well. Thank you again!

    • @ExcelGoogleSheets
      @ExcelGoogleSheets  3 ปีที่แล้ว

      Use Every or Some methods in JavaScript th-cam.com/video/gaC290XzPX4/w-d-xo.html

  • @chanthisarattkaweenan6457
    @chanthisarattkaweenan6457 ปีที่แล้ว

    Thank you, your video is great. //ทำงานส่งครูได้เพราะคลิปนี้เลยฮือออออ😘

  • @joshuaallen2986
    @joshuaallen2986 11 หลายเดือนก่อน

    the frequency function only spits out a single 0 for me :(

  • @mikailar3443
    @mikailar3443 2 ปีที่แล้ว

    still confused don't listen to people who say you're helpful

  • @ixcinematography
    @ixcinematography 3 ปีที่แล้ว

    So tempted to be the first to dislike.

    • @ExcelGoogleSheets
      @ExcelGoogleSheets  3 ปีที่แล้ว

      Well ... did you? :)

    • @ixcinematography
      @ixcinematography 3 ปีที่แล้ว

      @@ExcelGoogleSheets No, bro. I didn't. I really appreciate your videos. Thank you.