Automatically translated.View original post

28.3K followers

Follow

Follow

Follow

4 saved

5

Conditional Formatting - Duplicate Values

Practice using simple Conditional Formatting without writing a formula. Follow it. 😎💚# excelsoezy # Exceltricks # exceltips # Excel # Lemon 8 Howtoo

2/10 Edited to

สำหรับใครที่เริ่มต้นใช้ Excel การรู้จักฟังก์ชัน Conditional Formatting ถือเป็นเรื่องสำคัญมากครับ เพราะช่วยให้เราจัดการข้อมูลจำนวนมากได้ง่ายขึ้น โดยเฉพาะอย่างยิ่งกับการตรวจจับค่าที่ซ้ำกันซึ่งอาจส่งผลต่อความถูกต้องของข้อมูล การตั้งค่าแบบ Highlight Cells Rules แล้วเลือก Duplicate Values จะทำให้ค่าที่ซ้ำกันในช่วงข้อมูลที่เลือกโดดเด่นขึ้นทันที ผมแนะนำให้ลองเลือกช่วงข้อมูลที่ต้องการตรวจสอบก่อน จากนั้นคลิกที่เมนู Conditional Formatting เลือก Highlight Cells Rules > Duplicate Values แล้วกำหนดรูปแบบการไฮไลต์ด้วยสีที่ชัดเจน วิธีนี้เหมาะมากสำหรับงานสรุปข้อมูลหรือการตรวจสอบข้อมูลรายงานที่มีความซับซ้อนน้อยลง ทำให้ประหยัดเวลาหลีกเลี่ยงความผิดพลาด บางครั้งถ้าอยากเพิ่มความละเอียดก็สามารถปรับแต่งรูปแบบเลขสีหรือกรอบเพิ่มเติมได้ตามชอบ และเทคนิคนี้ยังใช้ได้ทั้งกับค่าเลขและข้อความ ทำให้เหมาะกับการใช้งานทั่วไปใน Excel ทุกเวอร์ชัน ลองใช้ดูครับ รับรองว่าจะทำงานกับ Excel สนุกและง่ายขึ้นเยอะ!

Related posts

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

1429 likes

Excel conditional formatting

HR & People tool practical Excel application of conditional formatting #tutorials #template #excel #exceltricks #exceltraining

9 likes

Cross off that list

Make check boxes cross off your to do list in excel with this conditional formatting trick. #tutorial #excel #template #projectmanagement #exceltips

7 likes

Excel projects with a Gantt chart

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

11 likes

Notion 101 just in time for back to school 👩🏻‍💻📚 Teamed up with @Notion for this one so you’ll find a link to get started with notion for free in my bio & a FULL deep dive tutorial over on YouTube! I’ve been using Notion for so many years so this was so fun to make - drop your questions,

779 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

5 likes

A laptop screen displays a Notion social media calendar template, with text overlayed: 'Useful NOTION keyboard shortcuts You Didn't Know You Needed!'. The laptop is on a desk with a monitor and plant in the background.

A table titled 'Useful Notion keyboard shortcuts' lists various Notion shortcuts for Mac and Windows, including numbered list, toggle, code block, page, text, comment, move block, expand toggles, use last color, view image fullscreen, duplicate, edit/change, and quick find.

A table titled 'Useful Notion keyboard shortcuts' lists additional Notion shortcuts for Mac and Windows, including new window, new page, new text block, line break, dark mode, link, inline code, inline equation, Heading 1-3, to-do checkbox, and bulleted list.

NOTION Keyboard Shortcuts

The Power of NOTION with Simple Keyboard Shortcuts! 🚀💡 Whether you're on a Mac or Windows, these handy tips will supercharge your productivity without the fuss. Mastering these shortcuts transforms NOTION into your digital ally, seamlessly adapting to your workflow. 🤖💻 Whether you're a t

70 likes

Compare lists using excel

Find the differences between columns in excel #exceltips #learning #excelshortcuts #excelspreadsheets #skillshare

8 likes

Excel formatting does the same thing as many people using Word #tutorial #exceltips #exceltricks #exceltutorial #exceltraining #worktips #alwayslearning

4938 likes

A laptop screen displays "5 FREE MUST HAVE Online RESOURCES FOR STUDENTS" with pink flowers and desk organizers in the foreground. The image highlights essential online tools for students.

5 Free Online Must-Have Resources for Students ✨

Hi, lemons! In your student era, as a student navigating the academic landscape, having the right tools at your disposal can significantly glow up your productivity, creativity, and overall learning experience. In this comprehensive guide, I'll spoil the tea on six free and powerful resources t

337 likes

Excel Custom Formatting

This is my favorite Excel trick 😎 Custom Formatting Custom Formatting is even cooler…allowing you to change the way your cell values appear in a cell. Here...let me show you a few example… but first: ➡️ How do you open up to Custom Formatting dialogue box? A few ways: 1️⃣ Hit CT

184 likes

Fast Task Tracking in Excel! 🏃‍♂️✅❌

✨ Welcome to Our Excel Mini-Class! ✨ Hey productivity champs! 🙌 If you’re juggling multiple tasks and need a simple, fast way to track your progress, I’ve got the perfect Excel trick for you! 📊✨ Let’s set up a Done/Not Done Tracker that will keep your tasks organized and help you stay on top

4 likes

A promotional image featuring a woman with text overlay that reads: 'Ultimate office software Cheat Sheet can leverage your career. Get PDF from valder.org'. The image also includes 'lemon8 @wuvalder' branding.

A 'Custom Guide Microsoft® Excel 2021 Basic Quick Reference Guide' cheat sheet, detailing the Excel program screen, keyboard shortcuts, general navigation, getting started, editing, and formatting options.

A 'Custom Guide Microsoft® Excel 2021 Intermediate Quick Reference Guide' cheat sheet, illustrating chart elements, chart options, various chart types, and instructions for creating, modifying, printing, and distributing charts.

my ultimate office software cheatsheet

Let me tell you a little secret: I used to be that person who Googled every single Excel formula, struggled with PowerPoint layouts, and spent way too much time formatting Word documents. Sound familiar? 😅 But then, I decided to take control. I printed out these Ultimate Cheat Sheets for Excel, Po

59 likes

Your worth isn’t conditional. #SoftThoughts #GentleHealing #BedtimeReflections #SelfWorth

26 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

Dynamic border Excel tip

Dynamic border Excel tip #exceltips #excel #exceltricks #exceltraining #tutorials #excel_learning #learn #onthisday

17 likes

Excel tip to remove grid lines

Fill white is NOT the way to remove grid lines in excel. It will take forever and possibly cover other data. Go to the view menu and uncheck the grid line box anytime you have a dashboard or any other reason they aren’t needed. #tutorial #excel #exceltips #exceltricks #exceltraining

11 likes

School Nurse Tool✏️📚

If you want this template visit my L!NK Tr33 (drop down arrow under my name on my profile) #template #schoolnurse #template #linktree #organize

6 likes

A laptop displaying college statistics notes is open on a white desk, with a desktop monitor in the background showing the time and an inspirational quote. The notes on the screen cover probability concepts, including a binomial probability cheat sheet.

Detailed handwritten college statistics notes cover binomial and normal probability distributions. Topics include finding percentiles, calculating probabilities for various scenarios, and understanding sampling error, with examples and TI-84 calculator instructions.

Handwritten college statistics notes explain how to find the mean and standard deviation of random variables, identify distribution of sample means, and apply general addition and multiplication rules for probability, with various examples.

steal my college stats notes! pt. 2 💯📉📊

steal my college stats notes! pt. 2 💯📉📊 hello friends! here are some more notes from my college stats class last semester! because my professor let us bring a cheat sheet to class, i had to make sure my notes were clean. i needed to be able to flip through my notes and find each topic quickl

140 likes

I Made My Own Digital Magazine Using Canva?! 🤯

I had way more fun making this magazine than I expected. There’s something wildly satisfying about taking a bunch of loose ideas in your head and slowly watching them turn into real pages. Picking the vibe, playing with fonts, rearranging layouts, and seeing it all come together felt like creative

8 likes

Excel search bar tutorial

Learn how to add a search bar to excel #tutorial #upskilll #educate #work #excel

9 likes

Excel cheat sheet

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

14 likes

6 Signs Someone Actually Sees You

This kind of recognition might feel uncomfortable at first because it's so different from conditional love. When someone sees your full humanity, not just your function, it can feel vulnerable and foreign. But this is what healthy relationship actually looks like. You deserve to be

113 likes

Separate words in excel

Separating text in excel #exceltricks #exceltips #tutorials #takemyclass #fyp

21 likes

new Goodnotes features 👩🏻‍💻✨👀 what do we think? #goodnotes #ipad #ipadgirlie #digitalplanner

375 likes

Name cells in excel

Customize and store headings in Excel #exceltips #tutorial #exceltraining #exceltricks #exceltutorial #excelforbeginners #learn Takw my Excel class xecutethevision.com#onthisday

31 likes

Excel interview tips

Excel interview tips #exceltips #interviewtips #exceltraining #excel #business

17 likes

Excel org chart

Tab your way to an org chart in excel #exceltricks #tutorial #exceltutorial #excel #exceltraining #fyp #spreadsheet

32 likes

CLAUDE INSANE RESEARCH MODE

have you ever told him to research something, and he goes b*lls to the wall deep in the internet with the most complex research you ever thought possible? me either til just now… my head would explode. always thankful for claude out here doin the d*mn thang. erday. #claude #claudeai

5 likes

What does clean data actually mean? #tutorials #exceltraining #exceltricks #excel #work

8 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

mildly requested blurry pink background tutorial! pink blurry circle editing tutorial #tutorial #editing #wonyoungism #editingtutorial #pink #beauty #makeup #capcut #wonyoung #kpopfyp #pinkmakeup #pinkskincare

650 likes

Excel list comparison 🌸

Excel list comparison went viral save this for when you need it #exceltraining #excel #exceltutorial #exceltips #exceltricks

128 likes

Excel percent format issue trick

Excel percent format issue trick. Fix percentage issues. #tutorial #exceltips #excel #excelpro #exceltricks #exceltutorial #exceltraining

12 likes

Excel data cleaning tools

🧹🧼 Clean it up with these 3 excel data cleaning tricks #tutorial #exceltips #exceltricks #exceltutorial #excel #business

22 likes

Auto Rows Highlighter

📊 Welcome to Our Excel Mini-Class! 🚀 In today’s session of the Boost Your Excel Skills series, we’re introducing the Auto Rows Highlighter—the ultimate trick to visually organize your data like a pro! 👀✨ With just a few clicks, you’ll be able to highlight entire rows automatically, making your s

1 like

Separate tab for excel notes

Keep your notes to yourself with excel camera #tutorial #excel #exceltraining #exceltricks #business #exceltutorial #exceltips

33 likes

A graphic titled 'Canva Keyboard Shortcuts' by Draven Royce, presenting a comprehensive list of shortcuts for basic actions, text formatting, element management, layering, tools, page, and presentation features in Canva.

Canva Keyboard Shortcuts List! Check It Out! ✨

This graphic outlines essential Canva keyboard shortcuts for efficiency and creativity. Here's a clear breakdown of its content: --- Canva Keyboard Shortcuts Basic Actions Add a line: L Add a rectangle: R Add a circle: C Zoom in: Command + (+) Zoom out: Command + (-)

6 likes

The Shadow of Deserving

🌑 THE SHADOW OF DESERVING “Where do I believe I have to earn what should simply be allowed?” The Shadow of Deserving hides in a quiet belief many of us carry without realizing it. That good things must be earned. Love must be proven. Rest must be justified. Success must be worked for e

37 likes

Conditional vs. Unconditional Love

We talk about love like it is a feeling; soft, instinctual, inevitable. But most of us were taught love as a transaction long before we ever learned it as a choice. Behave, and you are loved. Perform, and you are praised. Comply, and you are kept close. That is conditional love. It wears the

2 likes

cheat sheet 13/20: ultimate power point guide

Hey there， What's your go-to trick for making a presentation stand out? Share your tips in the comments below! 🔥 PowerPoint Tips and Tricks: Elevate Your Presentation Game 1. Slay with Slides: Need a new slide? Hit the Home tab and New Slide button, or go old school with Ctrl+M. 📑 2. Note-W

21 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

105 likes

Replying to @olga.matuszewska part 4 to how i made my notion closet template! #notion #notiontutorial

63 likes

A laptop screen displays a Google Sheet calendar, with overlay text "my plan for a 4.0 Semester," illustrating a digital academic planner.

A tablet shows a Google Sheet tab titled "My Courses," listing various course codes and names, with an arrow indicating where to add classes.

The "My Courses" tab on a tablet highlights course progress sections, explaining that boxes turn green when progress exceeds 50%, and notes the user is taking two classes.

How I Set Up My Google Sheet Assignment Masterlist

How’s everyone’s semester going? I know my semester is moderately busy with work and 2 classes so I always check my Google sheets Assignment #masterlist I have 3 tabs in it: - first tab -> all my classes, schedule, & course progress - second tab -> my masterlist for all assi

65 likes

A red fringed lamp and a yellow velvet chair in a room, with text asking if family drains energy and stating that understanding narcissistic family dynamics is the first step to breaking free.

An ornate fireplace with blue and gold mosaic details, displaying text defining a narcissistic family as described by Dr. Karyl McBride, focusing on parental narcissism and neglected children's needs.

A room with patterned wallpaper and a bed, featuring text listing signs of a narcissistic family: Golden Child vs. Scapegoat, Conditional Love, Gaslighting, and Lack of Boundaries.

Breaking Free: Understanding Narcissistic Families

Growing up in a narcissistic family can leave invisible wounds. But healing is possible. Start by recognizing the patterns and reclaiming your worth. You’re not alone. 🧠💪✨ #NarcissisticAbuse #FamilyHealing #MentalHealthAwareness #MentalHealthMatters #NarcissisticFamily

18 likes

Excel tips and tricks #exceltricks #exceltips

Excel tips and tricks #exceltricks #exceltips

11 likes

Excel class #excelmastery #class #education #excel

31 likes

See more