How to Auto Adjust Column Width in Excel

[@EndlessKnowledge]

Stay Connected: instagram.com/end_less_knowledge facebook.com/enlessknowledge whatsapp.com/channel/0029Va5iya9Lo4hbtSeVie3Z twitter.com/EndlessKnowled1 www.threads.net/@end_less_knowledge

[@nktrendings816]

Super Bro 👌

[@sivachanthuruarunakirinath1935]

Thank you 😊 From jaffna 😊

[@HariharanN-t4v]

Thank you, sir. Will you please make one video for the SUMIF function in a set of visible filtered data? (With using subtotal function)

[@syedmohamed7421]

Hello Endless Team ,lot of thanks 🎉🎉 pls post the Inventory video

[@shreehari8501]

Tally prime couse upload pannuga

[@VIGNESHCTECH]

Nice sir❤

[@manikandan.s2016]

Bro, different types of duplicate values ku different colours kuduka mudiyumaa.. Using conditional formatting...

[@EndlessKnowledge]

Yes brother, you can assign different colors for different duplicate values in Excel using Conditional Formatting. Here's how to do it step-by-step: Steps to Apply Different Colors for Different Duplicates: 1. **Select the Data Range**: - Highlight the range of cells where you want to check for duplicates. 2. **Open Conditional Formatting**: - Go to the **Home** tab in Excel. - Click on **Conditional Formatting** in the ribbon. 3. **Use a Formula for Conditional Formatting**: - Select **New Rule** from the dropdown. - In the "New Formatting Rule" window, select **"Use a formula to determine which cells to format."** 4. **Enter a Formula for Each Duplicate Set**: - To identify duplicates for specific values, use the following formula: =COUNTIF($A$1:$A$10, A1) > 1 Replace `$A$1:$A$10` with your data range and `A1` as the first cell in your range. - If you want to color only a **specific value** (e.g., "Apple"), use: =AND(COUNTIF($A$1:$A$10, A1) > 1, A1="Apple") 5. **Set Formatting**: - Click **Format** and choose the **Fill Color** (e.g., Green, Blue, Yellow, etc.). - Click **OK** to confirm the formatting. 6. **Repeat the Steps for Different Duplicate Values**: - For each specific duplicate value (e.g., "Apple," "Orange," "Banana"), create a **new rule** with the same approach. - Change the formula to target the desired value and apply a different fill color. 7. **Apply the Rules**: - Once all rules are created, click **OK** to apply Conditional Formatting. - Excel will now highlight each duplicate set with different colors. Example: Suppose your data range is **A1:A10** and contains the following values: Apple Banana Apple Orange Banana Orange Grapes Apple - **Rule 1**: For "Apple" duplicates → Formula: `=AND(COUNTIF($A$1:$A$10, A1) > 1, A1="Apple")` → Set **Red** color. - **Rule 2**: For "Banana" duplicates → Formula: `=AND(COUNTIF($A$1:$A$10, A1) > 1, A1="Banana")` → Set **Green** color. - **Rule 3**: For "Orange" duplicates → Formula: `=AND(COUNTIF($A$1:$A$10, A1) > 1, A1="Orange")` → Set **Blue** color. After applying these rules: - Duplicate "Apple" will be highlighted in **Red**. - Duplicate "Banana" will be highlighted in **Green**. - Duplicate "Orange" will be highlighted in **Blue**. --- Important Notes brother: - You need to create a separate **Conditional Formatting Rule** for each value to apply unique colors. - If you have many duplicate values and want an automated approach for different colors, **VBA (macros)** would be required. Let me know if you need help with VBA for automating this process! 😊

[@ajithkumarp04]

Any online course available?

[@Anandhan.18]

He already make more excel video, go check excel playlist

[@bigbull.202_]

Ajitheyy 💯

[@kalisuji2917]

Select all Alt O,C,A Undo also working

[@Anandhan.18]

Bro data analytics course conduct panna mudiuma , yenna ugala vida clear yaralaum soli kuduka mudiyathu please

[@periyasamy4345]

Google sheet'la Row and Column Adjustment pannuvathu eppati sir

[@S.kamaleshwaran]

Anna excel a enakku oru data multiple row la fill series a entry aganum sollunga anna ❤

[@lazyreviewssupport9811]

Default ஆ 😮every time excel open ஆகும் போது இந்த auto fit work ஆக வைக்க முடியுமா? 🤔

[@seduraman5061]

Bro period mark eppadi kuduppathu

[@hasanmeeran5]

பழைய verson இந்த formula use பண்ணலாமா ?

[@lazyreviewssupport9811]

கண்டிப்பாக 😊🎉

[@m.mathesh2288]

❤

[@rajeshkannanpn]

SIR SMALL DOUBT....=AVERAGE(D2:F2) ENTER PANNITTEAN ANA NEXT COLUMLA ENAKKU =AVERAGE(D2:F3) VARAUNAM ENNA PANNERTHU SIR.NUMBER 1 FIXED NUBER 2 CHENGE HOW

[@PrKJTECH]

hi bro in my mac i got error, Variable uses an Automation type not supported in Visual Basic...... please give me a solution

[@Nisha25_20]

Power BI session podunga bro

[@Aseerjeyaseelan]

Sir Plz Conduct Excel Class

[@KaRthi10]

Bro excel la programming language pani vids potunga bro

[@Factify-life-fu]

Excel using ai tools video podunga

[@saaralmusic5211]

wow🦢🥀🌴🌴

[@jasoolmohamed5835]

Centralise pannuruthu empady

[@Rajeshkannan-j2f]

Hi anna

[@Iss48]

hi sir

[@venkatraman2011]

Bro take python excel classes