Automatically translated.View original post

EazyIT by Patrick

6852 followers

Follow

Follow

Follow

164 saved

159

How to highlight repeated words on Excel

How to highlight repeated words on Excel 🤩🤩

# Excel # Excel formula # Excel the basics # exceltips # Lemon 8 Howtoo

2025/10/29 Edited to

สำหรับคนที่อยากไฮไลต์คำซ้ำใน Excel มากกว่าหนึ่งคอลัมน์ หรือข้อมูลที่มีความซับซ้อนมากขึ้น คุณสามารถใช้สูตรใน Conditional Formatting ร่วมกับฟังก์ชัน COUNTIF เพื่อเน้นแถวหรือเซลล์ที่มีคำซ้ำกันจากข้อมูลหลายคอลัมน์ได้ เช่น สูตร =COUNTIF($A$1:$B$100,A1)>1 จะช่วยตรวจจับคำซ้ำจากช่วงข้อมูล A1 ถึง B100 ซึ่งเหมาะกับงานที่ต้องเปรียบเทียบข้อมูลในหลายช่อง นอกจากนี้ Google Sheet ก็มีเครื่องมือ Conditional Formatting ที่คล้ายกัน ช่วยเน้นข้อมูลซ้ำได้ง่ายๆ เพียงเลือกช่วงข้อมูลและตั้งกฎการเน้นด้วยสูตร COUNTIF เหมือนกับใน Excel สำหรับผู้ที่ทำงานกับข้อมูลรายชื่อหรือรายการสินค้าที่อาจเกิดคำซ้ำบ่อยๆ การใช้เทคนิคนี้ช่วยลดความผิดพลาดในการทำงาน และเพิ่มความรวดเร็วได้มาก เพราะระบบจะเน้นคำซ้ำให้เห็นทันทีโดยไม่ต้องตรวจสอบทีละตัวเอง แนะนำให้ลองเพิ่มสีหรือสัญลักษณ์ที่สื่อความหมายเข้าไปในการตั้งค่า Conditional Formatting เพื่อให้งานดูโดดเด่นและเข้าใจง่ายยิ่งขึ้น นอกจากนี้ยังสามารถใช้ฟีเจอร์ Format as Table เพื่อจัดการข้อมูลให้อยู่ในรูปแบบเรียบร้อยและสะดวกต่อการวิเคราะห์ข้อมูลต่อไป

Related posts

An open Bible with 'GALATIANS' highlighted, displaying the title 'How to do the P.R.A.I.S.E Method Step by step' in pink and white text.

A pink overlay on an open Bible, detailing the 'P - Pray', 'R - Read', and 'A - Analyze' steps of the P.R.A.I.S.E method breakdown.

A pink overlay on an open Bible, detailing the 'I - Interpret', 'S - Summarize', and 'E - Engage' steps of the P.R.A.I.S.E method breakdown.

How to do the P.R.A.I.S.E Method

The P.R.A.I.S.E. method for Bible study stands for Pray, Read, Analyze, Interpret, Summarize, and Engage.. Here’s a breakdown of each step: P.R.A.I.S.E. Method - >*Check the slide for the example I set on Galatians 5:1-6 P – Pray Begin your Bible study with prayer. Ask God to open your he

6040 likes

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

1172 likes

How to Learn a Language Like a Native Speaker!

Learn Phrases and Sentences, Not Just Words Memorizing individual words is inefficient and better suited for exams than real-life use. Words learned in isolation are easily forgotten and lead to "mute language" – you recognize the words but can't use them. Instead, learning phrases and

2083 likes

A partial academic transcript showing nursing course titles like "Introduction to Nursing Practice," "Health Assessment," and "Mental Health Nursing," with corresponding 'A' grades. Overlaid text reads, "Things I did to get all A's in my nursing courses."

A tablet displaying handwritten nursing notes on topics like Pneumococcal Vaccine and airway clearance. Overlaid text advises using color coding, highlighting emphasized points during review, and taking notes on what the professor says, not just what's on the board.

A screenshot of a Studocu page showing multiple-choice nursing exam questions. Overlaid text recommends using Studocu for practice questions and searching for course-specific exam banks like "(Peds)+nursing+exam."

Here’s how to pass with A’s in all nursing classes

These tips can help with other majors as well, especially other health science majors🫶🏽 #nursing #study #studytok #StudyTips #nursingstudent

316 likes

The cover of the book "How to Be an Adult in Relationships: The Five Keys to Mindful Loving" by David Richo, 20th Anniversary Edition, resting on a white fabric surface with purple lighting.

A book page featuring a chart titled "The Five A's" that compares "How to Love an Introvert" and "How to Love an Extrovert" across categories: Attention, Acceptance, Affection, Appreciation, and Allowing.

A book page with highlighted text discussing how to overcome self-doubt by acting lovingly, focusing on loving intent, and showing the five A's to others to feel loved and lovable.

How to Be an Adult in Relationships

‼️This book revealed something I had ignored for years: that most of our relationship struggles don't begin in the relationship, they begin within us. It helped me understand how my past wounds shaped the way I give and receive love. ✨It doesn't teach tricks to attract someone or fix other

1712 likes

The image displays a person's feet wearing grey and yellow sneakers on a black surface, with the text "75 Soft Fall 2025 Edition" centered above, indicating the start of a wellness program.

This image outlines "Step 1: Diet" for the 75 Soft Fall 2025 Edition, focusing on mindful eating with healthy food swaps, alcohol balance tips, and fall-inspired nourishing meal ideas, set against a background of autumn foliage.

The image details "Step 2: Exercise" (45 minutes daily) with example workouts and active recovery ideas, and "Step 3: Hydration" (3 liters daily) with 10 practical hacks, against a backdrop of fitness gear.

Fall Wellness Blueprint: 75 Soft for Mind & Body 🍁

Diet: Nourish with Flexibility and Intelligence In my fall-edition of 75 Soft, mindful eating is about balance, not deprivation. I encourage you to choose nutrient-dense, satiating alternatives most days—and still enjoy social treats guilt-free. Swap starchy fries for baked sweet potato wedges l

2834 likes

How to Choose Book Categories + Keywords 📚

Categories help readers find your book on the shelf. Keywords help them search for it. Use both strategically and you’ll dramatically improve your discoverability. Save this for your next book upload 📌 #SelfPublishing #IndieAuthor #BookMarketing #WritingTips #AuthorTools

52 likes

A spiral-bound notebook page titled 'Case Endings' details grammatical cases like Nominative, Accusative, Dative, Locative, Ablative, and Genitive, with their definitions and examples. The text 'Language Notes 101' is overlaid on the bottom, illustrating a method for organizing grammar notes.

Language Study Note Taking Method

If you’re new to language learning and want to know how to structure your notes, here’s a guide that I hope helps. Remember the best way will be YOUR way. You’ll find what that is over time. Now, the notes: I like to divide by three main categories: ✏️Grammar 📕Vocab 👓Phrases If yo

474 likes

Study tips to help you excel in your exams 🍋

📝Daily affirmations - Straight A's are not negotiable - GPA reflection of my dedication - Study techniques that changed my life - From average to academic weapon - Transforming my grades completely - Study methods that actually work #StudyTok #studyWithMe #studyMotivation

6 likes

Excel highlighting trick

CTRL+ Shift + arrow to highlight cells. #exceltips #tutorials #exceltraining #exceltutorial #excel #excelpro #onthisday

26 likes

A purple planner, pen, and yellow sticky notes on a desk, with text overlaying "the sticky note method for BEATING ANXIETY."

A purple planner, pen, and yellow sticky notes, with the top note titled "Reasons I feel anxious:". Text explains "STICKY NOTE #1: WRITE DOWN EVERY REASON YOU CAN THINK OF FOR WHY YOU'RE FEELING ANXIOUS OR STRESSED."

A purple planner, pen, and yellow sticky notes, with the top note titled "Affirmations:". Text explains "STICKY NOTE #2: WRITE DOWN AFFIRMATIONS THAT COMBAT WHAT YOU WROTE ON STICKY NOTE #1."

How I use sticky notes to ease my anxiety

When I get anxious, especially if I’m at work, I grab two sticky notes. On one, I write down all the reasons I can think of for why I’m feeling stressed or anxious. On the second sticky note, I write down affirmations that combat the things I wrote on the first note. Example: I am worried about how

3095 likes

How to crochet a circle

There are probably many ways to crochet a circle without creating the octagon look. This is how I do it. I alternate between adding the increase first and adding the increase last. You don't have to start with 11 stitches. You can change the amount to fit your project. However, you might not

127 likes

How to do the Soap Method

Helping you breakdown scripture with the most popular Bible study method called S. O. A. P. S.O.A.P. stands for Scripture, Observation, Application, and Prayer. Here's a breakdown: 1. 📖 Scripture: Start by reading a passage of the Bible. Write down a verse or two that stand out to you. T

796 likes

A screenshot of a nursing student's academic record showing courses like Introduction to Nursing Practice, Health Assessment, and Mental Health Nursing, all with 'A' grades, accompanied by text overlay 'Things I did to get all A's in my nursing courses'.

Handwritten study notes on medical conditions such as Meningitis, Encephalitis, and Reye Syndrome, with advice to focus notes on what professors say that isn't in presentations and to add pictures for difficult concepts.

A list of pharmacology drug categories (Steroids, Beta 2 Agonist, Anticholinergics, Leukotriene Inhibitor, Methylxanthines, Mast Cell Stabilizers) and YouTube video suggestions for pharmacology and diabetes, with text about making separate exam playlists.

How to pass with A’s in all your nursing classes

These tips can help with other majors as well, especially other health science majors🫶🏽 #nursing #study #studytips #nursingstudent #nursingstudytips

85 likes

A definition of 'Incantation' as a verbal spell or chant for desired outcomes, overlaid on a background of ritualistic items like candles, bottles, herbs, and a hand writing in a book.

Sacred Words, Sacred Outcomes 🔮

🌬️ What Is an Incantation? An incantation is a spoken or whispered set of words used to direct energy, intention, or spiritual power. It can be: • A prayer • A chant • A spell • A petition • A poetic affirmation The power isn’t in the “magic words” it’s in inten

32 likes

An artistic painting depicts a woman with long dark hair and a floral crown embracing a man, whose head rests on her shoulder. Their close embrace conveys comfort and deep connection, set against a warm, dramatic sky. A small white butterfly is near the man's arm.

Love Is Not What You Say, It’s What You Stay For These days many people believe love is measured by words. By how often someone says “I love you.” By sweet messages. By promises that sound beautiful in the moment. But real love doesn’t live in words. Real love lives in what people do.

80 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

2586 likes

How to take A+ notes

Taking effective notes is the key to academic success, but not all note-taking methods are created equal. To take A+ notes in any class, start by using a structured method like the Cornell system, mind mapping, or an outline format to keep your notes organized and easy to review. Instead of writing

28 likes

💡Secret Tips that Every A+ Student Uses💯

1️⃣Synthesize and Simplify 📝Synthesis Whether it's a formula, a problem-solving method, or an entire textbook, the key to mastering material is being able to explain it clearly in your own words. That’s when you truly understand something. 📝Simplification To simplify, cut away the fluff and

26 likes

How I study to maintain my 3.8 GPA

Active recall, and this book have been a game changer! I got the book towards the end of my med surg semester and have been getting nothing but As on my exams🤓 All of these below can be found on YouTube! Sources I would recommend that your professors won’t tell you but will definitely use for

44 likes

How to study the Bible and apply it to our lives

Here’s a clear, practical approach to studying the Bible and actually living it out in everyday life: ⸻ 1. Start with the Right Heart • Pray first – Ask God to open your understanding (Psalm 119:18). • Approach with humility, not just to gain knowledge, but to know Him bet

50 likes

A person with dreadlocks, dressed in a simple garment, holds their hands together with blue smoke emanating, illustrating the power of spoken word in magic. The text reads 'THE POWER OF THE SPOKEN WORD IN MAGIC' with 'LucidAndWild' and 'Lemon8 @lucidandwild' branding.

The Power of the Spoken Word - Magic / Witchcraft

Why Spoken Word is Powerful in Magic I kind of want to go over speech in your practice. The voice is a powerful tool. You can cast spells with your mind or your mouth, without any help from candles, oils, crystals or other spiritual tools. People really underestimate the focus of the voice when yo

133 likes

How to strengthen your relationship with God💓

#christian #christianmotivation #christianlifestyle #Jesus

39 likes

The Inspo 🏹 The Markers 🏹 The Page!

Swipe for the final result! | How To: 🏹 Start with a page you’re drawn to! 🏹Go to Pinterest and search key words that resonate with your mood and what you want your page to look like :) I searched up ‘Shabby Chic Bedroom’ for this page. 🏹 Pull 3-5 main colors that you see repeated in you

186 likes

What’s the phrase most repeated in the Bible

#biblicalinsights #biblicaltruths #howtounderstandthebible #

29 likes

Compare lists using excel

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

8 likes

A belief is a thought repeated✨

You are in control of your own thoughts! Everything is exactly how it should be! What you feel and think, you create.🪄 You are made of crystalline ✨💖🔮 You can change your perspective with your beliefs.

3 likes

How to schedule repeated events in Apple Calendar

For those who don’t know, scheduling repeated events on Apple Calendar is such an underrated feature. Not only does it save you time so you’re not manually re-entering the same tasks every week, but it also helps you stay consistent and avoid forgetting. For example, let’s say there’s something you

13 likes

How to Stop Hyperpigmentation & Ingrown Hairs

Dark spots and ingrown hairs aren’t caused by dirty skin — they’re caused by inflammation, friction, and repeated irritation. Shaving, waxing, tight clothing, and over-exfoliating damage the skin barrier and trigger pigment changes, especially in intimate areas and underarms. The solution isn

35 likes

A laptop screen displays business ethics study materials, including legal definitions and a Volkswagen scandal case study. A notebook shows handwritten notes on corporate social responsibility. Overlays read "STUDY WITH ME" and "Motivation."

•skim the material first, jot down any vocabulary words or words/phrases you see repeated.. •I take notes both in one note and handwritten (just depends on how I’m feeling) •I don’t actually “study” I write my notes as I go over the material, but I normally don’t read back over it before an ass

19 likes

HOW I CREATE SPARK-LINES IN EXCEL

What is a sparkline? A sparkline is a small, simple, data-intense graphical representation typically used in line with text to show trends, variations, or patterns in data at a glance. Creating a sparkline in excel is pretty simple. I highlight a range of horizontally organized data and go into

319 likes

How I stay organized in collegeADHD Addition

Try some of these!! I've never had better grades in my life. I know everything is digital now but actually writing on paper/ white board MAKES A DIFFERENCE! Wish I had tried this sooner!!! Lmk if this works for y'all! ⭐️Overall rating: 10/10 💰Price:<$30 🛍Brand: Post it notes, Amazon

39 likes

Much of what we experience begins with the way we speak to ourselves, even when no one else is listening. When we speak a word, we release a great amount of energy that connects to a certain frequency. Our thoughts also are powerful, and repeated thoughts build an inner language that dir

1 like

Brazil is BLACK Black, for real. #VisitBrazilPartner Like… I knew this intellectually, but seeing it with my own eyes was still eye-opening. I had the chance to experience some of Brazil’s Black history as one of the first creators to take part in their new Afro Tourism guide, designed to high

2143 likes

I literally could not figure out how to learn the Quran in Arabic... I tried the apps, the videos, the tutors, nothing worked. The words just wouldn't stick, and I felt so disconnected from my prayers and from the Quran itself. I was reciting the same handful of Surahs every day, but I still had n

10 likes

How I turned my low-effort boyfriend into a high-e

For those asking - I use “groundly app”, just Google it. It was a game changer to regulate my nervous system! Part 3 of what actually shifted: I stopped over-explaining, got painfully specific about needs, and held boundaries long enough for actions to match words. (And yes—Groundly helped me stay

214 likes

The image displays a laptop, a lit candle, and a lamp on a bedside table, with a mirror reflecting a bed. Overlay text reads "Changing Axis Colors in Excel" and "SWIPE," indicating a tutorial.

This image presents an Excel bar chart titled "Actual" showing monthly data from May to September. The Y-axis, representing percentages, has the "5%" label highlighted in red, demonstrating a custom axis color. Text asks how to achieve this effect.

The image shows a screenshot of the Excel "Format Axis" pane, focusing on the "Number" section. It illustrates selecting "Custom" category and entering a format code like "[Red][=0.05]0%;0%;0%" to color a specific percentage value on the axis.

HOW I CHANGE AXIS COLORS IN EXCEL

In my search for more dynamic and visually impactful data representation, I found a powerful feature in Excel – the Format Axis Number Custom Format Code option. This tool allows me to not only present numerical data but also customize the display to highlight specific values. The ability to chang

64 likes

A woman in a black sports bra and shorts takes a mirror selfie in a gym, showcasing her physique and headphones.

A woman in a black crop top and track pants takes a mirror selfie in a gym, with text overlay 'Acknowledge Your starting point And set a goal'.

A woman in a light-colored sports bra and shorts takes a mirror selfie in a gym, with text overlay 'Catch negative thoughts immediately & Practice daily SOFT self talk'.

How I stop comparing my body to others at the gym

I’ve always been stick thin. (No. Really. Just tiny) my entire life. Nothing to me. (Just look at the second picture) with zero muscle mass and zero energy. (We all have our own battles 🤺) and then when I GOT to the gym I was constantly comparing myself to every other woman I seen there. 🙄 I was ob

7 likes

Success is the sum of small efforts repeated 👏🏻

1. Consistency Over Intensity: Success isn’t about a one-time intense effort but rather about sustained, steady efforts over time. Small daily actions, like studying a bit each day or working out regularly, build up to significant results. 2. Building Habits: By focusing on small, manageable tasks

27 likes

An illustration of a woman with closed eyes, featuring visible internal organs like kidneys and fiery energy in her abdomen, set against a golden geometric pattern. The image is titled '20 Hidden Truths the FBI Didn't Want You to Know: Secrets of the Human Body and Spirit' and includes Lemon8 branding.

20 Hidden Truths the FBI Didn’t Want You to Know

20 Hidden Truths the FBI Didn’t Want You to Know: Secrets of the Human Body and Spirit These cover deep spiritual findings, experimental tests, and the conclusions they supposedly came to about the human body and spirit. Let’s get into it: 1. The Pineal Gland Ain’t Just a Gland Girl, the

1927 likes

How I made $6k in 1 month

I put together a simple roadmap you can copy — it’s the same process I used to hit my first $10K month. Click the link in my bio to grab it !! From zero to $10K/month — no fancy degree, no magic trick. Just 3 steps I repeated until it worked. This is your sign to start your side hustle now

15 likes

A person with a head wrap sits at a wooden table with lit candles, a glass of water, and a bowl of salt, illustrating methods to detect spirits. The title "Signs You Ain't Alone: How to test if a Spirit is Creepin' Around You" is overlaid.

👀 You Ain’t Alone: How to test if a Spirit is near

Look—before you brush off that cold chill, that shadow in the corner, or them dreams that got you wakin’ up breathin’ heavy, let me tell you this: you ain’t crazy, and you sure ain’t alone. Spirits are real. Some just passin’ through, and some tryin’ to stay. So here’s how to test if a spir

571 likes

Repeated Cycles: Getting Free From The Past

Breaking Free & Finding Peace” We don’t talk enough about how exhausting it is to keep repeating the same emotional cycles, the same lessons, the same hurts, the same patterns dressed in different people or situations. But at some point, healing whispers: “It’s time to get free.” This i

0 likes

How to create 3D Fonts with Ai

#aitemplate #aiimagegenerator #aicreated #aihack

3 likes

See more