Lemon8Lifestyle community

Automatically translated.View original post

ใช้ Mac ก็เทพ EXCEL ได้
ใช้ Mac ก็เทพ EXCEL ได้

1835 followers

Follow
Follow
Follow

25 saved
21

Know GROUPBY Function

2025/10/6 Edited to

... Read moreถ้าคุณกำลังหาวิธี “การ group column ใน Excel” แบบไม่ต้องทำ PivotTable ทุกครั้ง ฟังก์ชัน GROUPBY (ใน Microsoft 365) คือทางลัดที่ฉันใช้บ่อยมาก โดยเฉพาะงานสรุปยอดขายแยก Division/Region เพราะมันเป็น Dynamic Array พอข้อมูลต้นทางเพิ่มแถว ผลลัพธ์จะขยายและอัปเดตให้เอง 1) เตรียมข้อมูลให้อยู่ในรูปตาราง - ควรมีหัวตารางชัดเจน เช่น Name | Division | Sales - แนะนำกด Ctrl+T ทำเป็น Table เพื่อให้ช่วงข้อมูลยืดหยุ่น (เพิ่มข้อมูลแล้วสูตรอ้างอิงตาม) 2) แนวคิดของการ “Group Column” ด้วย GROUPBY - row_fields = คอลัมน์ที่อยากจัดกลุ่ม (เช่น Division) - values = คอลัมน์ตัวเลขที่อยากสรุป (เช่น Sales) - function = วิธีสรุป เช่น SUM, AVERAGE, COUNT ตัวอย่างที่ฉันใช้สรุป “ยอดขายรวมในแต่ละ Division” - ถ้า Division อยู่ที่ C4:C33 และ Sales อยู่ที่ D4:D33 =GROUPBY(C4:C33, D4:D33, SUM) ผลลัพธ์จะได้ตาราง 2 คอลัมน์: Division | Sum of Sales (รวมยอดขาย) 3) อยาก group มากกว่า 1 คอลัมน์ทำได้ไหม? ทำได้ เช่นอยากสรุปยอดขายตาม Division และ Name (จัดกลุ่มซ้อน) =GROUPBY(C4:C33, D4:D33, SUM,, , , TRUE) ทิป: หลายไฟล์จะตั้งค่าพารามิเตอร์ต่างกันตามเวอร์ชัน ถ้าพิมพ์ =GROUPBY( แล้วดู tooltip จะเห็นลำดับอาร์กิวเมนต์ในเครื่องคุณ ช่วยกันพิมพ์ผิดตำแหน่งได้ดีมาก 4) ทำให้ผลลัพธ์อ่านง่ายขึ้น - จัดรูปแบบตัวเลข Sales เป็น Currency/Number - เพิ่มหัวตารางให้ผลลัพธ์ด้วยการต่อข้อความ เช่น ใช้ VSTACK/HSTACK (ถ้ามี) เพื่อใส่ Header ก่อนผลลัพธ์ 5) ปัญหาที่เจอบ่อย (และวิธีแก้) - ข้อมูล Sales เป็นข้อความ: ลองแปลงเป็นตัวเลข (VALUE) หรือเช็กว่ามีช่องว่าง/สัญลักษณ์แปลก - มีช่องว่างใน Division ทำให้กลุ่มแตก: ใช้ TRIM ทำความสะอาดคอลัมน์ Division ก่อน - เพิ่มแถวแล้วสูตรไม่อัปเดต: ถ้าไม่ได้ทำเป็น Table ให้ขยายช่วงอ้างอิง หรือเปลี่ยนมาอ้างอิงคอลัมน์ของ Table เช่น Table1[Division], Table1[Sales] สรุปคือ ถ้าโจทย์คือ “การ group column ใน excel” เพื่อสรุปยอดขายแยกแผนก/Division แบบไว ๆ และให้อัปเดตตามข้อมูลต้นทางอัตโนมัติ ฉันแนะนำให้ลอง GROUPBY ก่อนเลย โดยเฉพาะคนที่ใช้ Microsoft 365 บน Mac/Windows จะสะดวกมาก

Related posts

Learning app all students should know 🥰🫶
This is an application that has helped me a lot. 📝📝When I first studied abroad, I wasn’t really good at English 🥹🥹 but luckily I had it, I could listen attentively to the lecture and it would take notes for me. I can study any time and any where I want. 💻💻 Later when I went to work, I used
Vera love study

Vera love study

99 likes

A woman with curly hair and glasses, holding a microphone, with text overlays 'SQL Windows Function Explained' and 'Mad Key'.
A bookshelf background with 'SQL Windows Function Explained' and a quote defining a window function as viewing a 'slice' of data while seeing the bigger picture.
A SQL code example using a window function (RANK() OVER) to rank sales, showing output with individual sales records and their ranks, maintaining detail.
SQL: Windows Function Explained
One thing I've discovered is that when working with data, Normal SQL (GROUP BY) helps summarize data but sacrifices row-level detail in the process. On the other hand, Window Functions allow you to perform calculations across rows while maintaining each row’s detail. This key difference m
NeLo

NeLo

58 likes

Pediatric Endocrine Disorders & Must Know!🩺👶
The endocrine system plays a HUGE role in growth, metabolism, and hormone regulation in kids! Here are the key disorders, signs, and management tips you need to know for Peds Endocrine 🏥📚 ⸻ 🛑 1. Type 1 Diabetes (T1D) - “Insulin-Dependent Diabetes” ✅ Cause: Autoimmune destruction of pancrea
Nurse Radiance

Nurse Radiance

94 likes

This is my function🖤
This is my function (aka an everything shower, clean room, dark romance book) #relatab #girlhood #girlproblems #girltherapy #aestheticvibes
lexa smith ⋆˙⟡♡

lexa smith ⋆˙⟡♡

1892 likes

Know the difference 💭
Maximus, Medius, Minimus Cable Kickbacks: Perfecting Glute Activation! 🏋️‍♂️ ••• 🧠Understand the Difference🧠 ✏️Medius: A 45-degree angle kickback mainly targets the gluteus medius by engaging both hip extension and abduction. This exercise helps to strengthen and stabilize the gluteus medius,
trina

trina

7 likes

Canva Shortcuts You Should Know
I could not function without @canva! I've used this platform for the last 4 years to create: 🍒Content for social media marketing clients 🍒ebooks 🍒Portfolios 🍒Presentations 🍒Thumbnails 🍒Planners 🍒Business cards 🍒Flyers 🍒Templates You name it , and I probably have it in my projects!
Bria | Social Media Marketing

Bria | Social Media Marketing

1791 likes

A graphic titled "Steal My Group Therapy" with "Session Outline: Healthy Coping Skills & Traumatization." It features an illustration of six diverse individuals sitting in a circle, engaged in discussion, representing a group therapy session. The background is a blue-to-yellow gradient.
A text document outlining a group therapy session on "Healthy Coping Skills and Traumatization." It details objectives, an icebreaker, session overview, and psychoeducation on trauma types (acute, chronic, complex) and its effects on the brain (amygdala, hippocampus, prefrontal cortex) and body.
A continuation of the group therapy session outline, detailing common reactions to trauma, identifying unhealthy coping mechanisms, and introducing healthy coping skills like grounding, breathing, and journaling. It includes a "Coping Toolbox" activity, a grounding exercise, and closing reflection questions.
steal my group therapy session outline! 🤍
use these for a group therapy session, or apply them to yourself lovebugs! 💌🤍 please share your thoughts! this outline provides much more psycho education that i utilized to reassure my participants that trauma is not something we can literally “just get over”, it can literally affect your brain an
nicole noelle

nicole noelle

69 likes

A handwritten nursing note titled "STEAL MY VITAMINS & MINERALS Nutrition Notes" on lined paper. It details antioxidants, Vitamin A's impact on vision, deficiency symptoms like night blindness, and its roles in disease prevention, skin health, immunity, growth, and reproduction.
A handwritten nursing note on lined paper detailing Vitamin A sources (preformed and provitamin A carotenoids), toxicity risks (3000 micrograms daily), and the initial information on Vitamin D, including its nature as a hormone and its forms.
A handwritten nursing note on lined paper discussing Vitamin D. It covers dietary and sun sources, its primary functions in calcium regulation and bone metabolism, and deficiency conditions like rickets in children and osteomalacia in adults.
Steal my Nursing Notes: Vitamins You Need to Know
Breaking down vitamins and minerals one note at a time! ✨ Understanding micronutrients is essential for nursing—especially when it comes to patient education and overall health. Clear, organized notes make it so much easier to remember key functions, sources, and deficiencies! Extra points for thos
Stella Studies

Stella Studies

37 likes

Relieve back pain and enhance kidney function
#taichi #chineseculture #exercises #healthylifestyle #backpain
Lijun kungfu

Lijun kungfu

2126 likes

Function Of Beauty Restock!✨🌸
Had to stop by Sephora and do a little restock before traveling this summer!🤍🤭 #lemon8diary #organizedbeauty #makeuprestock #lemon8hair #lemon8haircare #Hair #haircare #haircareroutine #travel @
Gens.finds

Gens.finds

792 likes

A pair of white sneakers, black dumbbells, and a water bottle on a dark surface, framed by flames and snowflakes. The title "How to Properly WarmUp & Cool Down" is prominently displayed with a lemon icon.
Text outlines warm-up and cool-down routines for walking, including dynamic and static stretches. A smartwatch displays a "Time to Walk Dolly Parton" workout, indicating a 25-minute duration.
Text details warm-up and cool-down routines for running, listing dynamic and static stretches. A smartwatch shows "Outdoor Walk" and "Outdoor Run" workout options with open goals.
Get the MOST Out of Your Workouts by Warming Up❤️‍🔥❄️
If you're looking to get the most out of your workouts and avoid unnecessary injuries, you've got to nail your warm-up and cool-down routines. Trust me, these steps are non-negotiable if you want to stay in the game and feel great. Let me break it down for you in a simple, no-BS way. ‼️W
Chalie_Baker

Chalie_Baker

854 likes

A modern kitchen with white and grey cabinets, stainless steel appliances, and a kitchen island. A laptop, a white tumbler, and a vase with green flowers are on the island. The image has a text overlay that reads "CLEAN GIRL KITCHEN AESTHETIC."
A close-up of a kitchen counter featuring a black electric stove with a stainless steel kettle. To the left, a wooden cutting board, wooden utensils, and salt and pepper shakers are visible. Text overlays indicate "Salt & Pepper" and "kettle."
A kitchen sink area with a stainless steel sink, a faucet, and a white soap dispenser. A small green plant and a black bowl filled with green decorative balls are on the counter. Text asks, "What's one kitchen item you can't function without?"
What’s one kitchen item U can’t function without?🤔
Ladies let’s chat. There are some items in my kitchen that I use everything single day. As for me I love a clean kitchen so I make sure to have all my cleaning essentials ready to go at all time. Some items I can’t go without including my air fryer because I use it almost every single day. I al
BEAUTY + LIFESTYLE

BEAUTY + LIFESTYLE

173 likes

come to a college date function with me!
hi everyone! one thing i love about greek life is the date functions- recently i went to my boyfriends and it was oktoberfest themed. this was so much fun and so many of my close friends also came so it was the perfect night. i got my dress off amazon a week in advance and it was absolutely perfect
presleigh green 🩵🩵

presleigh green 🩵🩵

5 likes

EPITHELIAL TISSUE: Classification & Function
~Epithelial tissue is characterized according to the shape of its cells and number of layers. ~Squamous cells are thin, flat cells that look like fish scales and are found in the tissue that forms the surface of the skin, the lining of the hollow organs of the body, and the lining of the respira
Hannah

Hannah

50 likes

A person takes a mirror selfie in a gym, with text overlay stating "YOUR GYM CHOICE CAN MAKE OR BREAK YOUR GAINZ" and arrows pointing to their glutes.
White text on a purple background discusses the importance of gym hygiene and safety, citing studies on bacteria on equipment and the risk of infections.
White text on a purple background explains how gym atmosphere, motivation, and psychology impact workout consistency and self-efficacy, with a Reddit anecdote.
How to MAXIMIZE Ur GAINZ by Choosing the RIGHT Gym
Ranking 10 Popular Gyms by What Really Matters We’ve all heard it: “It doesn’t matter what gym you go to, it’s about how you work out.” But after training in garage gyms, budget chains, bougie studios, and everything in between, I can confidently say: the gym you choose matters more than you thi
Chalie_Baker

Chalie_Baker

29 likes

A desk setup with a laptop, smartphone, drink, and notebooks, featuring the title 'How I Built My Second Brain,' indicating a guide to personal knowledge management.
An open notebook page illustrating five digital note-taking apps: Notion, Apple Notes, Obsidian, Evernote, and CollaNote, with brief descriptions of their key features for building a 'digital home.'
An open notebook page detailing the P.A.R.A. method for organizing information into four categories: Projects, Areas, Resources, and Archive, with examples and small illustrative photos.
My Step-by-Step Guide to Building a Second Brain
1. Pick Your Digital Home Base 🏡 First, commit to one single app so you aren't searching for notes everywhere. The "best" app is the one you'll actually use, but here are my takes on five popular choices: ● Notion: My personal favorite; it's like digital LEGOs for building
emilie.studygram

emilie.studygram

277 likes

Organized by function, but still pretty!
#100bucketlistideas #organizeappsbycolor #appsilove #asthetic #shareyourthoughts #mylist
Lia Smith

Lia Smith

3 likes

Enhance kidney function and boost energy! 🥰
#taichi #exercises #practice #healthylifestyle #kidney
Kungfu.LIjun

Kungfu.LIjun

27 likes

How do you function as a mom with ADHD?🤔
Learning to work with my brain and not against it has helped me shift my mindset about obstacles! They are not obstacles anymore, but opportunities for growth!!! #sundayreset #momlife #adhd #adhdinwomen #adhdweightloss #healthyfood #fy #foryou #foryoupage
CynSin✨

CynSin✨

13 likes

A hand holds a black bottle of creatine gummies with a pink label. The label describes it as a creatine monohydrate supplement in pink lemonade flavor, supporting muscle growth, strength, and recovery.
Creatine Helps with Cognitive Function
Creatine is essential for cognitive function of the brain. It has also been shown to help with traumatic brain injuries. That is enough for me to take 5 mg daily of Creatine. I take Legion Creatine gummies because I am still a kid at heart. I am not getting paid by them for this post. I am just
Counting Calories with Crystal

Counting Calories with Crystal

0 likes

Financial Freedom is a function of your mindset
A day in the life of a trader (my side hustle) and a fashion brand owner 😎 If you know how to use your time and money properly, you’ll eventually never trade again #fashiontips #Lemon8Diary #moneymanagement #financetips #letschat
Jasmine | Day Trader

Jasmine | Day Trader

0 likes

Four smiling young women in yellow dresses pose together at a sorority date function with a "My Tie" theme. They are standing in a line at an indoor event with dim lighting, ready for a fun night out.
A young woman in an off-the-shoulder yellow dress takes a mirror selfie in her dorm room. Text overlays indicate the "My Tie" theme, a yellow, orange, and pink color palette, and an energy drink for the road.
Two smiling young women, one wearing a black tie and the other a white tie, pose closely for a selfie. Both are dressed in yellow/cream tops, embracing the "My Tie" theme at the sorority function.
come to a college sorority date function with me!
let’s recap my college sororities date function! This date function had the theme of “My Tie” which was both a play on words for Mai Tais (sunset colored drink) and an encouragement to wear your dates suit tie as an accessory. As someone who loves the color yellow, I was super happy that I got to w
presleigh green 🩵🩵

presleigh green 🩵🩵

15 likes

A set of Function of Beauty hair care products for curly hair, including pink bottles of shampoo with chia extract and conditioner with shea butter, alongside yellow and pink boxes of #HAIRGOAL BOOSTER SHOTS for strengthen and curl definition.
Function of beauty hair care
So I picked up the function of beauty hair care for curly hair line and I’m excited to use them. I have curly hair and right now it definitely needs some tlc so I’m hoping this will help. If anyone has any experiences with this brand I’d love to hear it! I’m definitely interested on how these will
Cynthia

Cynthia

16 likes

A person outlined in pink takes a selfie outdoors, holding a cup. Text overlay reads: 'signs and symptoms that you're not eating enough for your body to function optimally'.
for your body to function optimally
jas

jas

214 likes

Where tf the function?
Twitch: Midnightbre YT: brelawrence #fortnite #gaming #gamer #fyp #viral
Bre 🦋🤍

Bre 🦋🤍

41 likes

function of beauty
my hair is a major part of my outfits, and I’m changing it all the time. This means I need hair care that changes with me! That’s why I go to target and grab what I need from function of beauty to make custom hair care on a budget! I love that it’s at target because I don’t have to wait for it to b
sadiebryn

sadiebryn

10 likes

the vibes i bring to the function
mags | booktok📖🦋🏹

mags | booktok📖🦋🏹

17 likes

See more