Automatically translated.View original post

EazyIT by Patrick

7257 followers

Follow

Follow

Follow

10 saved

25

Find the highest-lowest value of 1,2,3...On Excel✅

# Excel formula # Lemon 8 Howtoo # Excel # Excel the basics # Teaching excel

1/31 Edited to

เมื่อคุณต้องการหาค่าสูงสุดหรือต่ำสุดในข้อมูล Excel ไม่ได้หมายถึงแค่การหาค่าที่มากที่สุดหรือน้อยที่สุดเพียงค่าเดียว แต่บางครั้งเราต้องการข้อมูลอันดับที่ 2, 3 หรือมากกว่านั้นด้วย เช่น การหารายได้สูงสุด 3 ลำดับแรกในแต่ละเดือน สูตร =LARGE เป็นตัวช่วยที่ยอดเยี่ยมมาก เพราะสามารถกำหนดอันดับที่ต้องการได้ง่าย เช่น =LARGE($C$3:$C$10, 1) จะเป็นค่าสูงสุดอันดับที่ 1 และ =LARGE($C$3:$C$10, 2) คืออันดับที่ 2 ในทางกลับกัน สูตร =SMALL ช่วยหาค่าที่น้อยที่สุดและค่าที่น้อยที่สุดอันดับถัดไป เช่น =SMALL($C$3:$C$10, 1) คือค่าต่ำสุดอันดับที่ 1 เหมาะกับการวิเคราะห์ข้อมูลรายได้ ลดลงหรือหาขั้นต่ำในช่วงเวลาต่างๆ นอกจากนี้ควรตรวจสอบช่วงข้อมูลให้ครอบคลุมและคงที่ เช่นล็อคเซลล์ช่วงข้อมูลด้วยเครื่องหมาย $ เพื่อป้องกันการเปลี่ยนแปลงเมื่อคัดลอกสูตรไปยังเซลล์อื่น เทคนิคเหล่านี้ช่วยให้การวิเคราะห์ข้อมูลบน Excel ทั้งซับซ้อนและรวดเร็วขึ้นมาก ผมเองมักใช้วิธีนี้เมื่อจัดอันดับข้อมูลทางการเงินหรือสถิติ เพื่อให้ได้ข้อมูลที่ถูกต้องและเข้าใจง่ายขึ้นอย่างมีประสิทธิภาพ

Related posts

A tablet displays an Excel wedding budget spreadsheet on a desk with notes and a planner. The image is titled 'Stop Struggling with Excel Learn These Super Easy Formulas'.

This image details core Excel calculation formulas: SUM, AVERAGE, MIN, and MAX. Each function is explained with an example Excel table showing its application and purpose.

This image explains Excel's reference formulas, VLOOKUP and HLOOKUP. It provides examples with tables demonstrating how to search and retrieve data vertically and horizontally, along with usage tips.

Excel shortcuts every student should know! 👩🏻‍💻

Stop Wasting Time: Master These Excel Formulas for Maximum Efficiency! 🕒 If you’ve ever struggled with Excel, mastering formulas can seriously up your game. Here’s a breakdown of the essentials that’ll make you look like a pro 1.Core Calculation Formulas 🧮 These are the basics you can’t live

1180 likes

Excel Trick:Create an Interactive Project Tracker😎

✨ Welcome to Our Excel Mini-Class! ✨ Hey Excel Pros!😉 Want to take your project management skills to the next level? Want to stay organized and on top of your projects like a true professional? Let's create a super simple yet interactive project tracker in Excel that'll keep you focused

6 likes

100 Excel Tips The best Shortcuts, Formulas, Formatting & Advanced Tips Bookmark this, you'll save 1,000 of hours! A list of tips that all professionals need. Here is a preview: ⌨️ Shortcuts 1. How to hide a column? Ctrl + 0 2. How to hide a row? Ctrl + 9 3. How to

1435 likes

Medial jobs with the lowest stress

#edutok #medstudent #medicalstudent #medschool #nursingschool

28 likes

A vibrant graphic titled 'USEFUL EXCEL FORMULAS' in green, overlaid on a spreadsheet displaying various charts, data tables, and financial figures. The image includes 'Career | Lemon 8' branding and a 'SWIPE' indicator.

A laptop screen showing code, with a text box explaining the 'VLOOKUP' Excel formula. It defines its function for searching large datasets and provides a detailed example. The image is branded 'Career | Lemon 8 | Yun Jung'.

A text box on a wooden desk with a laptop, smartphone, and coffee cup, explaining 'SUMIF & SUMIFS' Excel formulas. It defines their use for adding cells based on conditions and provides a SUMIF example. The image is branded 'Career | Lemon 8 | Yun Jung'.

Useful Excel Formulas to save your time at work!

Hey everyone! Excel formulas are awesome for speeding up calculations and analyzing data. They range from simple math stuff to more complex tasks like searching and matching data. Learning these formulas can make your work easier and help you get more done in less time. Try out online tutorials and

872 likes

#excelspreadsheets #

5 likes

A woman takes a mirror selfie, holding a coffee cup and phone, with text overlay 'EXCEL SHORT CUTS SAVE TIME & FRUSTRATION PART 1'. Abstract shapes frame the image.

A beige graphic slide explains the Excel shortcut 'SHIFT + END + DOWN' for selecting an entire column or section of data, with a 'SWIPE' indicator.

A brown graphic slide details the Excel shortcut 'CTRL + A' which selects all data in a worksheet, accompanied by a 'SWIPE' instruction.

EXCEL SHORTCUTS

These excel short-cuts are just a few that have made my excel work take a fraction of the time and genuinely changed my work life!! Working in excel can be extremely frustrating when not using the tool efficiently. Here are some crucial shortcuts to enhance your experience with Excel. CTRL + A

2583 likes

Best Times to Book Flights for the Lowest Prices

Flight prices change constantly, but these general timing guidelines can help you avoid overpaying. I use this as a starting point, then stay flexible depending on the trip. Save this before your next flight search 🛫 #TravelTips #FlightDeals #TravelPlanning #BudgetTravel #TravelInspo

274 likes

Excel check box

#onthisday check boxes in excel are way easier than they used to be #tutorial #tutorials #excel #excelpro #exceltricks #spreadsheet

17 likes

✨⛽️ Apps To SAVE MONEY On Gas + Get CASH BACK 🚗✨

✨ Gas prices usually have me STRESSED, so I made it my mission to start saving where I could at the pump 🛑⛽ Here’s what I use to consistently cut down my gas expenses and keep more cash in my wallet! ⬇️ 📱 My go-to gas-saving and cash back apps: ✔️ GasBuddy ✔️ Fuel Rewards & Cash Back Progr

880 likes

Excel dot trick

Do you know the DOT?? Excel trick using the dot to remove extra zeroes #exceltraining #excel #exceltricks #exceltraining #exceltutorial #business #businesstips

103 likes

Excel pdf button

Add a PDF button right to your Excel file #excel #tutorial #exceltips #exceltricks #spreadsheet xecutethevision dot com

43 likes

Lowest Prices I’ve Seen On Amazon For Thursday!!!

#amazon #amazonfinds #amazontopsellers #amazondeals #discounts

161 likes

PRESS ON UPDATE

I love them & you can’t tell me I didn’t go to the nailshop🥰 The length, the shape, the French tips….🔥 Edit: these and some of my favorites are linked in my bio under the “for my press on gworls” #Lemon8 #press ons #dailyinspo #budgetfriendlyoptions

742 likes

Good morning even at my lowest 🌸🫶

#morningblessings #godisgood #godlovesyou 💜

2308 likes

I’m making a simmer pot from whatever I can find

I love making my house smell good using things I already have. Cranberries from the fridge. Citrus. Cinnamon from the pantry. Fresh cedar, rosemary and pine from outside. It's simple and it feels grounding. This little glass simmer pot is perfect for it. You can see everything insid

45 likes

Secure Your Excel Data Like a Pro: Set Password 🔒✨

💥 Welcome to Our Excel Mini-Class! 📈 Today's session is all about how to secure your excel data. Do you deal with sensitive data in Excel and want to keep it safe from prying eyes? 🔍 Whether you're a student, professional, or just love staying organized, learning how to set passwords o

7 likes

Unlock Excel Secrets: Use AVERAGE Like a Pro!

✨ Welcome to Our Excel Mini-Class! 💫 Need to quickly find the average of a range of numbers in Excel? It's easier than you think! Let’s dive into the simple formula to get that mean value in no time. 🙌 Whether you’re crunching data for a project or just organizing your personal stats, th

8 likes

Canada & Mexico's Dollar Value Drops

#presidenttrump #usa #mexico #canada #tariff #bordercrisis #news

7 likes

A blurred image of a person with curly hair holding a phone, with warm lights in the background. Overlay text reads: "What My HEALING ERA with God looked like GOD MET ME IN THE MIDDLE OF MY MESS."

A cozy, dimly lit scene with a window showing rain, a lit candle, and an open notebook. Overlay text describes crying during prayer and letting God see true pain, stating "HEALING STARTS WHEN YOU STOP PRETENDING."

A cozy, dimly lit scene with a window showing rain, a lit candle, and an open notebook. Overlay text discusses healing through honesty, not having it all together, and being real with God, stating "HEALING IS TRUTH."

God Met Me At My Lowest

Healing with God for me wasn’t waking up one day magically happy and healed 😭 It was crying during prayer. Having hard conversations with myself. Outgrowing people. Learning how to be alone. Starting over. Messing up and still going back to God anyway. Some days I felt close to Him and s

122 likes

Excel cheat sheet

Excel cheat sheet #excel #exceltips #exceltricks #exceltraining #tutorials #excel_learning

14 likes

Excel scannable barcode

Scannable barcode using excel to create them! Download the libre 39 font by just googling it. #tutorial #excel #exceltraining #worktips #elearning #fyp #edu

8 likes

Don't worry about going viral, provide value!🫶🍋

Don't worry about going viral, worry about providing value. When selling digital products, your clients are your tribe, the people you relate to. Don't sell them a product, solve their problem. #onlinebusinessforbeginners #stayathomemom #onlineincome #makemoneyonline #digitalm

0 likes

6 states with lowest Property Taxes

6 states with lowest Property Taxes

6 likes

How to read stocks? Pt 2

Stocks can seem overwhelming when you first start, and that's completely normal. I'm here to breakdown the basics so you can begin your stock investing journey. I will use Microsoft for this example: ✨ Market cap: The market cap is like the overall value tag of a company in the stock

78 likes

Excel time stamps

Yes, I said permanent time stamps #exceltips #excel #tutorial #worktips #exceltraining #exceltricks

54 likes

Lowest calorie starbucks drinks ✨☕️

💌 Brand: Starbucks These might not taste as good as pink drink but they definitely are better for you! Next up: food to eat at Starbucks while on a diet #lowcaloriestarbucks #starbuckrecipes #starbuckideas #starbuckreccomendation #bodytransformation

94 likes

Highest 2 Lowest Red Carpet Best Looks

These are my picks for highest 2 lowest red carpet best looks at the Cannes Film Festival. Look for a surprise. #red carpet #cannesfilmfestival

28 likes

Excel tips and tricks

Who is in both columns? Find out which items are on both lists. #exceltips #excel #tutorial #exceltricks #templates

38 likes

helping people find clarity before reaction

The shot was missed. The coach challenged him. But what he heard wasn't what was said. Sometimes pressure, fear, and self-doubt create a different message than the one being delivered. This episode explores the space between what happened and what we think it means. Observation ≠ Conclus

1 like

Excel IF Function

How to use IF Function in Excel #excel #exceltips #exceltraining #exceltricks #exceltutorial

0 likes

A green and white graphic titled 'Master Simple Excel Operations', listing five basic Excel tasks: creating a workbook, entering data, adjusting column/row size, inserting/deleting cells, and using functions.

A graphic titled 'Keyboard Function Key Identification' showing a white keyboard layout and a table identifying common keys like Esc, Tab, Caps Lock, Shift, Ctrl, Alt, Enter, Backspace, Sleep, and Wake Up.

Getting Started with Excel: It's Really Simple!

We'll start with the basics, learning about Excel's interface, toolbar, cells, and other fundamental operations. Then, we'll move on to common office shortcuts, as well as some frequently used functions and formulas. #ExcelBasics #ProductivityTips #SpreadsheetSkills #Exce

40 likes

Excel Hacks: 4 Quick Ways to Fill Serial!

📈 Welcome to Our Excel Mini-Class! 💫 In this session, we're unveiling the magic of fill serial! Ready to save time on your Excel spreadsheets? Here's 4 super fast ways to fill serial numbers like a pro! 💼✨ Get ready to level up your Excel skills! 🙌 #wps #fillserial #exceltips

7 likes

Level Up Your Excel Game with VLOOKUP Function! 📈🌟

👉 Welcome to Our Excel Mini-Class! 💡 Today's session is all about VLOOKUP Function in Excel! Ever feel like searching for specific data in a huge spreadsheet is like finding a needle in a haystack? 🧐 VLOOKUP is here to help! With a simple setup, you can make it simple to locate exactly what

8 likes

Excel projects with a Gantt chart

Auto populate the Gantt style chart with name and color #template #excel #tutorial #friday #exceltips

11 likes

ppl think they’ve seen me at my lowest but…

not my bf or sister, fr no one #idk #depressed #depressedanddelusional

7 likes

How to use IF Function in Excel

How to use IF Function in Excel #excel #exceltips #iffunction #exceltutorial #microsoftexcel

0 likes

Excel permanent timestamp

Time stamps DO NOT update when you close and reopen #excel #exceltips #templates #tutorial #exceltraining

23 likes

A person's shadow, outlined in orange, falls on an asphalt road with orange and white lines. The person's feet, wearing checkered shoes, are visible. Text overlays read 'THE SHADOW' and 'WALK THE LINE', along with 'lemon8 @brandonkenyon'.

A close-up of a person's orange-outlined shadow on asphalt with an orange line. One foot, wearing a checkered slip-on shoe, is visible in the foreground, positioned near the shadow's foot. 'lemon8 @brandonkenyon' is in the corner.

A person's orange-outlined shadow stands on an asphalt road with orange and white lines. One foot, wearing a checkered slip-on shoe, is visible in the foreground, positioned near the shadow's foot. 'lemon8 @brandonkenyon' is in the corner.

Lost to the “Lost Boys” chapter of my life.

the𝐒⃥⃒̸𝐇⃥⃒̸𝐀⃥⃒̸𝐃⃥⃒̸𝐎⃥⃒̸𝐖⃥⃒̸ Our 𝘀⃥𝗵⃥𝗮⃥𝗱⃥𝗼⃥𝘄⃥ self is like the darkness, the mysterious side of this adventure called life. It represents the parts of self that we all have hidden or neglected. The parts of ourselves that hold deep emotion, fear, and our true desires. While our conscious

26 likes

An image with a dark sky showing reddish-purple and green light, possibly an aurora, above a dark tree line. A white text box reads 'Bible quotes that kept me going when I was at my lowest.' The bottom right has 'SWIPE' with an arrow, and the bottom left shows 'Lemon8 @elainaa.christmas'.

for when you feel like you're at your lowest✝️💛.

let God take his time to heal you. always have faith in the Lord, never give up. he will never fail you even when things get tough🤍. #trustgod🙌🏽 #bible #quotes #MentalHealth #love #jesus #transformationjourney #breakup #breakuprecovery #lemon8diarychallenge

44 likes

Excel tip to create a search function

Excel search function #tutorials #excel #exceltraining #exceltricks #exceltips

13 likes

A page with the title 'The 6 Most Famous Laws in The World.' highlighted in yellow, on a textured background.

A page explaining Hick's Law, stating more choices take longer to decide, and Kidlin's Law, about writing down problems for 85% progress.

A page detailing Falkland's Law, suggesting avoiding decisions, and Wilson's Law, linking knowledge to earning money, highlighted in yellow.

6 UNIVERSAL LAWS TO BE AWARE OF:

1. Hick's law states that the time it takes for a person to make a decision increases with the number of choices available to them. Get it done fast! 2. Kidlin's law is a principle in physics that states that the sum of the incoming fluxes into a system is always equal to the sum of the

27 likes

#excel #exceltips #technology #miami

#technologyineducation #excel #teacher #computer #office

1 like

Thunder star player lowest first half points

4 likes

Even at my lowest, I still pick people up.

Even when I’m exhausted. Even when I’m hurting. Even when I’m barely holding myself together. I still show up with kindness. I still listen. I still try to be light for someone else’s darkness. Not because I’m okay... but because I know what it feels like to feel alone. And I never want to be t

14 likes

Excel Trick: Color-Coded List Menu 💫 📊

✨ Welcome to Our Excel Mini-Class! ✨ Hey productivity pros! 👋 Want to make your Excel sheets not just functional but also visually stunning? Let me show you how to create a color-coded list menu that’s perfect for tracking tasks, organizing data, or making your spreadsheets pop! 💼✨ Using a co

2 likes

See more