Automatically translated.View original post

📊 Shining 2024 vs 2025 stock 🔍

2025/8/11 Edited to

... Read moreถ้าคุณกำลังหา “สถิติหวยย้อนหลัง 30 ปี excel” แนะนำให้เริ่มจากจัดข้อมูลให้เป็นโครงสร้างที่ Excel ทำงานง่ายก่อน แล้วค่อยคำนวณสถิติ (นับความถี่/ช่วงที่ไม่ออก/แนวโน้ม) เราลองทำตามนี้แล้วใช้งานสะดวกมากค่ะ 1) เตรียมตารางข้อมูลหวยให้เป็นระเบียบ ใน Sheet1 ทำหัวตารางประมาณนี้: วันที่ | งวด | รางวัลที่ 1 | เลขหน้า 3 | เลขท้าย 3 | เลขท้าย 2 ถ้าคุณมีข้อมูลเป็นข้อความยาว ๆ ให้แยกคอลัมน์ด้วย Data > Text to Columns (เลือกตัวคั่น เช่น เว้นวรรค/เครื่องหมายจุลภาค) แล้วค่อยจัดรูปแบบวันที่ให้เป็น Date 2) แปลงเลขให้เป็น “2 หลัก / 3 หลัก” แบบมาตรฐาน เวลาเก็บเลขท้าย 2 หลัก ควรเป็นข้อความ (Text) เพื่อไม่ให้เลข 0 นำหน้าหาย เช่น 01, 09 วิธีง่าย ๆ: ใส่สูตร =TEXT(A2,"00") สำหรับ 2 หลัก หรือ =TEXT(A2,"000") สำหรับ 3 หลัก แล้วคัดลอกวางเป็นค่า (Paste Values) 3) ทำตารางความถี่เลขท้าย 2 หลัก (00–99) ใน Sheet2 สร้างคอลัมน์ “เลข” ไล่จาก 00 ถึง 99 แล้วคอลัมน์ “จำนวนครั้งที่ออก” สูตรที่ใช้บ่อย: - นับความถี่: =COUNTIF(Sheet1!$F:$F, A2) โดย A2 คือเลข 00–99 และคอลัมน์ F คือ “เลขท้าย 2” จากนั้นเรียงจากมากไปน้อยเพื่อดูเลขที่ออกบ่อยที่สุด 4) ดู “เลขที่นาน ๆ ไม่ออก” (เช็คงวดล่าสุดที่เคยออก) เพิ่มคอลัมน์ “งวดล่าสุดที่ออก” แล้วใช้ XLOOKUP เพื่อหาวันที่ล่าสุดจากท้ายตาราง เช่น =LOOKUP(2,1/(Sheet1!$F:$F=A2),Sheet1!$A:$A) สูตรนี้จะคืน “วันที่ล่าสุด” ที่เลขนั้นเคยออก (ถ้าข้อมูลเรียงตามเวลา) แล้วค่อยทำคอลัมน์ “ห่างกี่งวด/กี่วัน” เพื่อดูเลขที่หายไปนาน 5) สรุปภาพรวมให้อ่านง่ายด้วย PivotTable ถ้าคุณมีหลายประเภท (รางวัลที่ 1, เลขท้าย 2, เลขหน้า 3) แนะนำ Insert > PivotTable แล้วลาก “เลข” ไปที่ Rows และลาก “เลข” ไปที่ Values (Count) จะได้สรุปความถี่เร็วมาก ทิปเล็ก ๆ ที่ทำแล้วเวิร์ก: ตั้งชื่อช่วงข้อมูลเป็น Table (Ctrl+T) เวลาเพิ่มงวดใหม่ สูตร/พิวอตจะอัปเดตง่ายขึ้น และถ้าจะเทียบ “ปีต่อปี” ให้เพิ่มคอลัมน์ “ปี” ด้วยสูตร =YEAR(วันที่) แล้วทำพิวอตแยกปีได้เลยค่ะ

Related posts

A lavender stock tank pool with a flamingo float, surrounded by a wooden deck and lush green lawn. A playset is visible in the background, illustrating the backyard transformation over six years.
A collage showing the initial setup of the stock tank pool, including its delivery, a person inside the 8ft wide tank, the pool filter installation, and the tank freshly painted salmon pink with a unicorn float.
A collage depicting the backyard's scenery improvements, featuring hammock swings, cedar boards being installed around the salmon pink pool, and black slats added to the wooden structure, creating a cohesive look.
Six Years of the Stock Tank Pool ☀️
The evolution of the Stock Tank Pool & our backyard oasis! Swipe & tell me which color is your favorite! 💦🌺🍉 What a transformation our backyard has been through. The stock tank will ALWAYS be my favorite & I’m always trying to convince everyone that they need one! ☀️ 2020, year
Ally Rae Thread Co.

Ally Rae Thread Co.

7580 likes

Top five shows 2024/2025
These are my top five shows of 2024/2025 in January Favorite TV Show 📺Name: 9-1-1 What's the show about: 9-1-1 is a fast-paced drama that follows the lives of first responders in Los Angeles, including firefighters, paramedics, police officers, and 9-1-1 dispatchers. The series explores t
Leah

Leah

41 likes

What’s in my backpack 2024-2025
This school year is creeping up on us and here is what’s in my bag. #whatsinmyschoolbag #packbagforschool #schoolbackpack #backpack of school supplies #schoolbagessential #Lemon8
Averyk2024user

Averyk2024user

67 likes

Unique Baby Boy Names 2024-2025
Hey new and expecting moms! My son was born in October 2024 and I went with the name Adonis! I plan on expanding my family in a couple years (trying for another boy lol) and was wondering what are some unique baby names that you guys contemplated or decided on? Let me know in the comments below
Liv

Liv

750 likes

A comparison of AI IQ test results for 2024 and 2025, showing bell curves with specific AI models and their scores. The 2024 curve shows Vision AIs at 70-80 and Verbal AIs at 100-110. The 2025 curve details various AI models scoring from 70 to 150.
Text outlining the 2024 AI IQ Test Results, indicating an average IQ of 100, with Vision AIs scoring 70-80 and Verbal AIs scoring 100-110, based on weekly tests of 9 AIs.
Text detailing the 2025 AI IQ Test Results, showing an average IQ of 100. It lists top performers like Claude-3 Opus (70), Mistral (80), Gemini Advanced (Vision) (90), Grok-3 (100), and Llama-3.2 (Vision) (110).
🤖 AI IQ Test Results: 2024 vs 2025 📈
Hey everyone! 👋 Today, we're diving into the fascinating world of AI IQ tests. Let's explore how different AI models performed in 2024 and 2025. 🧠 ---- 📅 2024 AI IQ Test Results In 2024, the site quizzes 9 AIs every week. The scores reflect the average of the last 7 tests given. Here'
Valder

Valder

32 likes

Allstar cheer 2024-2025
Another amazing season is in the books. Baby girl did amazing this year. I am so proud of her hard work and determination to the sport. 🩷🖤 #cheer #cheerleading #cheermom #cheerislife #allstar
Brittney Vickers- decor & more

Brittney Vickers- decor & more

512 likes

A light purple background with the text 'Book journal 2024 VS 2025' in black, indicating a comparison between two years.
A bullet journal page titled 'BOOKS READ' for 2024, featuring a bookshelf illustration filled with various book titles and a count of '12' books read.
A bullet journal page titled 'Books Read' for 2025, showing an empty bookshelf illustration with a globe, a framed picture, and cacti, ready to be filled.
Reading Journal 2024 vs 2025
I recently finished my 2025 reading journal! I still need to print out some book covers for my 2025 releases page but besides that it’s done! Here are some of my pages that I redid from last year and I like them a lot more! I’m excited to read this year and fill these pages out! #2025books
Marin 🫶🏻

Marin 🫶🏻

42 likes

✨Eras of the Stock Tank Pool ✨
Swipe to see the six different years of our Stock Tank Pool 💦🍉🌿☀️🌺 • 2025: Lavender Haze ☔️ • 2024: Lavender Haze ☔️ • 2023: Aqua Marine 💦 • 2022: Sunny Mandarin ☀️ • 2021: Sunny Mandarin ☀️ • 2020: Peach Mimosa 🍑 Should I paint it again this year? What color should I try!? #stoc
Ally Rae Thread Co.

Ally Rae Thread Co.

65 likes

2024 VS 2025 Vision Board
It’s already a few months into the year, but I sooo needed to make a new ✨Vision Board✨ With it being the end of the first quarter, it’s important to set or reevaluate my goals for this year. It’s interesting to see how my goals have shifted in the past year! One thing I noticed is that I’ve got
Dema

Dema

9 likes

Food I Ate late 2024- early 2025
Def a foodie lol
minnieash35

minnieash35

66 likes

Apple Stock: when should you buy?! Read here 🫶💵
If you are wondering all about the Apple stock, then this post is for you. Should you buy apple stock before or after new product launches. I am by no means giving any advice and I am reporting from Investopedia. Typically Apple releases their iPhones in the fall of each year. They released one
Kylie 💸🫶🏻

Kylie 💸🫶🏻

172 likes

A graphic titled "2024 BEST GAMES I've Played This year" in purple and pink, set against a light blue grid background with gaming doodles. It features a calendar-like design with cloud shapes and a pink pushpin, indicating a year-end game review.
The game cover for "Wuthering Waves" shows two main characters in a futuristic, post-apocalyptic setting. Text below lists platforms (Windows, iOS, Android), genre (Gacha, action-adventure), and describes the game's world of Solaris-3 and protagonist, Rover.
The game cover for "Persona 3 Reload" depicts a male character with blue hair holding a device to his head amidst blue energy. Text below lists platforms (Windows, PS4, PS5, Xbox), genre (Turn-based, JRPG, Adventure), and describes the game's premise of a transfer student and the "Dark Hour".
2024 Wrap Up: Best Games I’ve Played
Hello, hello! 🙌🏻 I can’t believe the year is almost over! Honestly, I found a lot of releases from this year to be quite disappointing - most of the games nominated at the Game Awards just didn’t live up to the hype for me. It wasn’t all bad though. So, before we head into 2025, I thought I
Miroak

Miroak

19 likes

Goodbye 2024…Cheers to 2025
Here’s a look back at my vision board for 2024. I realized I didn’t give myself enough credit, but by God’s grace and your incredible support, I achieved most of my goals. This year, I’m aiming even higher and trusting God to guide me every step of the way. Thank you to everyone who loves and suppo
Nira🎀

Nira🎀

7 likes

Good by 2024 nail Hello 2025 Nails🌸
Random Thoughts 💭What's on my mind: I needed switch them quick this is why I love press on Current Mood: Fabulous Darling ⭐Rate:10/10 #2025nails #lemon8nails #lemon8challenge #kenneithG #florencextension
Florencextension press on nail

Florencextension press on nail

223 likes

2024 good by! Hello 2025
#lemon8foodcoupon #lemon8food #lemon8challenge @Lemon8 Food
Tim Clowers

Tim Clowers

353 likes

2024 Beauty Recap 🍋 2025 Goals 💛 + I Hit 15k 🎉
Thank you so so much my Lemon Drops 💖 My 2024 was all over the place but we made it. 🎉Cheers to a happy, healthy & successful 2025. My 2025 Goals will be consistency & routines that make sense. I post all things beauty related. From hair care, skincare, makeup, perfume, body care &
KAREN💄POSTS BEAUTY

KAREN💄POSTS BEAUTY

113 likes

2024 vs 2025
#2025willbeouryear #gardening #gardenmakeover
Annaline Acres 𑁍

Annaline Acres 𑁍

11 likes

2025 goals for my non-toxic household journey 🪴✨
🌿✨ 2024 goals were a success. ☺️ I’ve learned so much & am continuing to learn every day. I feel healthier and happier. It’s amazing what a few changes can do to your body and environment around you. With that being said, here’s to 2025! This year, I’m continuing my non-toxic, self-sustainab
kimberlyxct

kimberlyxct

45 likes

My 2024 through early 2025 travel plans
#lemon8diarychallenge not all of these are planned for sure, so this list is tentative
Hannah Fink

Hannah Fink

6 likes

My hair Jan 2024 vs Jan 2025
Freshly reattached locs at the beginning of the year till now and I’m very surprised and grateful they look this good and didn’t fall out since I reattached them myself (I do not recommend unless you want puncture wounds on the tips of your fingers 😩). Really didn’t do much and definitely need to t
Ragelling

Ragelling

6 likes

growing in 2024, ready to tackle 2025
#my2024
Dragon Queen

Dragon Queen

176 likes

may 8th 2024 vs. march 8th 2025
the growth is insane 😆 i remember when i couldn’t fit them in a ponytail now look at them 🥹 may 7th makes a year with my locs and im so proud of my hair. they fluffed up exactly how i wanted them to. i posted my loc inspo here already so on my 1 year loc anniversary im going to get some highlights
Ray

Ray

21 likes

Become her in 2025 ✨
Happy New Year ✨🥂 Listen my loves, this year… it’s time to execute. No more excuses, no more fear, and no more doubt. I genuinely want to step into all the Lord has in store for me, but I know it requires intention, effort, discipline, commitment, and determination. However, I accept the chal
Kambria ❀

Kambria ❀

580 likes

A woman in a light athletic outfit stands with her back to a large rock formation, framed by a white polaroid with 'Hello 2025' and a flower. The scene is a vast, rocky landscape in Utah.
A woman in a light athletic outfit stands with her back to the camera, looking up at a massive, layered rock formation in a desert landscape under a blue sky.
A woman in a light athletic outfit stands in a desert landscape, looking up at a towering, layered rock formation under a blue sky with a contrail.
Goodbye 2024, hello 2025
Mi primer post en este lugar hermoso que la verdad me encantó y le recomiendo a todo el que le guste la naturaleza que lo visite las fotos no hacen justicia de lo hermoso que es 🥰 📍City/Country: Utah 🌄 Location: Springdale
Rosiii Molina

Rosiii Molina

22 likes

Stock Market Crash 2025 📉
Here’s how ⤵️ It all boils down to three things: time, mindset & strategy. First things first, the market will always go through cycles of ups and downs. This is not new! BUT the best investors are able to withstand the test of TIME ⏰ & with the right mindset & strate
Destini ✨ WealthyHer Mentor

Destini ✨ WealthyHer Mentor

19 likes

Goodbye 2024… hello 2025
Yes, I’m living with 2 rare disease, 2 auto immune diseases, multiple mental disorders…. So what? I got shit to do in 2025. 💪🏽 #2025goals #nmo #gastroparesis #mentalhealthawareness #fyp
TheNMO_Truthspeaker

TheNMO_Truthspeaker

8 likes

2024 vs. 2025
It all starts with a look in the past with lessons learned so thwy can serve in the future . I hope to connect with many women that believe in themselves and their potential to fulfill their dreams. #my2024 #lemon8 #contest #2024vs2025 #2025glowup
MomGlamFun

MomGlamFun

2 likes

Goodbye 2024… hello 2025
#newyear2025 #blessings #growthjourney #2025vibes #2025success
M2fsss

M2fsss

142 likes

What I’m Leaving in 2024 for a Better 2025
1️⃣ Limiting Beliefs—I carried a list of reasons why I’m not good enough, I cant do this, basically a list of reasons to limit myself. And I carried this with me everywhere, subconsciously. 2️⃣ ‘The Chase’—I struggle with feeling like my goals are too far out of my reach and this idea and attit
Cici Iongi

Cici Iongi

21 likes

A thick, colorful 2024 journal is shown next to a thin, new 2025 journal on a knitted background. A 'January' sticker and three silver stars are also visible, highlighting the start of a new journaling year.
My 2024 journal VS my 2025 journal
so excited to start this new journal! #2025journal #journaling #artwork #2024journalsetup
ally

ally

10 likes

Growth was made in 2024, now on to 2025 👀😌
#growth #lowerbodyworkout #postpartumfitness #csectionfitness #core
emilykaitlinfit

emilykaitlinfit

76 likes

A hand holds a dark green academic planner with 'academic planner' and 'FULL YEAR IN ONE PLACE' printed on the cover. The image has overlay text 'My New Planner From Amazon'.
An open planner page lists features like 'SEMESTER GOALS', 'CALENDAR', 'MONTH OVERVIEW', 'HABIT TRACKER', and 'WEEKLY PLAN' with brief descriptions.
An open planner page lists features like 'CLASS SCHEDULE', 'PROJECT PLAN', 'INSPIRATION BOARD', 'GRADE TRACKER', and 'NOTES' with brief descriptions.
Academic Planner for 2024-2025 School Year!
I purchased this academic planner for college students off Amazon, and I am super excited to use it! This is an undated planner that has yearly, monthly, and weekly calendar pages. The planner also includes academic and personal goals, a class schedule, monthly goals and habit trackers, inspiration
cas

cas

41 likes

Rest of 2024/2025 Goals
#lemon8diarychallenge #2024goals #2024intentions #Lemon8Diary #healthylifestyle2024 #manifestation #skincareroutine Pls comment good skincare stuff 🥺
Bri 🦇🥀✨🩸⛓

Bri 🦇🥀✨🩸⛓

7 likes

Goodbye 2024. Hello 2025!
#gettoknowme
EASELAnimalRescueLeague

EASELAnimalRescueLeague

7 likes

See more