TrumpExcel
TrumpExcel
  • Видео 429
  • Просмотров 43 191 011
Remove Duplicates Within a Cell in Excel (2 Easy Ways)
In this video, I will show you how to remove duplicates from a cell in Excel using formulas.
While removing duplicates from a range of cells where each value is in a different cell is quite easy, when it comes to removing duplicate items within a cell, you need to somehow analyze the entire content of the cell and then remove the duplicate values.
Thankfully, this can quickly be done using new Excel functions such as TEXTSPLIT, UNIQUE, and TEXTJOIN.
And if you do not have access to these new functions, you can create your own function using a simple VBA code.
VBA code available here - trumpexcel.com/remove-duplicates-from-cell-excel/#VBA-Custom-Function-to-Remove-Duplicates-Within-a-Cell
00:0...
Просмотров: 2 076

Видео

VLOOKUP vs XLOOKUP - Detailed Comparison with Examples
Просмотров 5 тыс.21 день назад
XLOOKUP is a new and improved version of the VLOOKUP and HLOOKUP functions. It addresses many of the shortcomings of the VLOOKUP function. In this video, I will give you a detailed view of the differences between the XLOOKUP and the VLOOKUP function. The video covers multiple examples that will make it easy for you to understand the difference between these two functions with practical use case...
3 Simple Ways to Copy Column Widths Perfectly
Просмотров 6 тыс.21 день назад
When you copy and paste data in Excel, it copies everything except the column width. In this video, I will show you three simple methods you can use to copy column bits in Excel. Read the article - trumpexcel.com/copy-column-width-excel/ 00:00 Intro 00:12 Using Paste Icon options 01:00 Using the Paste Option in the Ribbon 01:20 Using Paste options in Right-click Menu 01:36 Using Keyboard Shortc...
✋ Stop Using NESTED IF Formulas in Excel, Use SWITCH Function Instead
Просмотров 11 тыс.28 дней назад
In this video, I cover how to use the SWITCH function in Excel, which can be used as a replacement for Nested IF formulas. The video will show you a detailed introduction to the SWITCH function and some examples of its practical use-cases. I also compare it with other similar functions, such as IF and IFS. ⬇️ Download Example File - www.dropbox.com/scl/fi/94rlv9a5atf3qz00y4wsg/SWITCH-Function.x...
Easy Trick to Sort Dates by Month in Excel (Formulas)
Просмотров 6 тыс.Месяц назад
In this video, I will show you two simple formulas to sort dates by months in Excel. While sorting dates is easy in Excel (as dates are stored as numbers in the backend), what if you want to sort dates by month (irrespective of the year value)? This can be done using a simple formula. In today's video, I will show you two simple ways to sort dates by month in Excel (using the SORTBY function an...
🔓 Unprotect Excel Sheets in Seconds (When You Don't have the Password)
Просмотров 69 тыс.Месяц назад
In this video, I will show you a simple way to unprotect worksheets in any Excel file without the need for any software or website. It's pretty easy and takes less than a minute. Download the example file - www.dropbox.com/scl/fi/1zvawx0zpvi4jn9dk3i4j/Call-Center-Dashboard.xlsx?rlkey=n2u8rp8h2vil4r3gboh4yzo42&dl=1 Read the article here - trumpexcel.com/unprotect-excel-sheets-without-password/ ☕...
🤖 NEW AI Function in Excel - LABS.GENERATIVEAI (CHATGPT inside Excel Formulas)
Просмотров 6 тыс.Месяц назад
Excel has a new AI function that allows you to use prompts and get the result right within a cell using simple formulas. It's like having CHATGPT inside a cell in Excel. In this video, I will show you how to get this new function (LABS.GENERATIVEAI) Into Excel, how to configure it, and then how to properly use it to get some meaningful work done from it. While you can use it to generate text li...
Scrape Data From Multiple Web Pages into Excel (with Power Query)
Просмотров 6 тыс.Месяц назад
In today's video, I will show you how to use Power Query to connect to multiple pages in one go, get all the data into the Power Query editor, clean the data, and get it in Excel. 00:00 Intro 00:27 Scrape Data from One WebPage with Power Query 04:19 Changing URL to Get Data from New Page 05:38 Import Data from Multiple Web Pages using Power Query Download the Excel file: www.dropbox.com/s/v1pd0...
⚡NEW Excel Functions - TAKE and DROP
Просмотров 7 тыс.2 месяца назад
TAKE and DROP are two new Excel functions that can be used to extract data from a dataset. TAKE function allows you to Extract a specific number of rows or columns from the beginning or end of the data set. And, the DROP function allows you to extract everything after dropping the specified number of rows or columns from the beginning or end of the data set. While these functions are useful, in...
#️⃣ Dynamic Arrays in Excel - This Changes Everything!
Просмотров 9 тыс.2 месяца назад
Dynamic Arrays are a game changer that completely changes how you use formulas in Excel. Prior to Dynamic Arrays, a formula was used to return one single value, but with Dynamic Arrays, you can return an entire array and spill the results to fill multiple rows and columns in one go. This has also allowed Excel to introduce many amazing useful functions. In this video, I will cover everything yo...
Import Data from PDF to Excel Tables Using Power Query (Quick and Easy)
Просмотров 8 тыс.2 месяца назад
In this video, I will show you how to convert PDF files to Excel using Power Query. You can connect Excel with any PDF file using Power Query and then import the data from the PDF into Excel (without the need for any software or website). One great thing about using Power Query to import data from pdf to Excel is that you can transform the data in Power Query before getting it in Excel. This vi...
Excel Lambda Function (Examples) - All You Need to Know!
Просмотров 9 тыс.2 месяца назад
In this video, I show you how to use the LAMBDA function in Excel (with multiple examples). Lambda function allows you to create your own functions and use them in Excel without using any programming such as VBA or JavaScript. I will start with some basic examples showing you how to create a Lambda function and then use it in Excel, and then cover some advanced examples. As the last example, I ...
Searchable Drop Down Lists in Excel (No VBA) 🔥
Просмотров 6 тыс.3 месяца назад
Searchable Drop Down Lists in Excel (No VBA) 🔥
Genius Hack to Rename Multiple Files in a Folder in Seconds (Quick and Easy)
Просмотров 10 тыс.3 месяца назад
Genius Hack to Rename Multiple Files in a Folder in Seconds (Quick and Easy)
Paste Data into Filtered Columns in Excel (Clever Tricks)
Просмотров 20 тыс.3 месяца назад
Paste Data into Filtered Columns in Excel (Clever Tricks)
Easy Shortcuts to Copy Visible Cells Only in Excel
Просмотров 3,8 тыс.3 месяца назад
Easy Shortcuts to Copy Visible Cells Only in Excel
SUM Cells Based on Partial Text Match (Easy Formulas)
Просмотров 4,2 тыс.3 месяца назад
SUM Cells Based on Partial Text Match (Easy Formulas)
Count Filtered Rows With this Easy Formula
Просмотров 5 тыс.3 месяца назад
Count Filtered Rows With this Easy Formula
8 Things Excel Should Copy from Google Sheets
Просмотров 4,7 тыс.3 месяца назад
8 Things Excel Should Copy from Google Sheets
Excel Showing Formula instead of Results - Quick Fix!
Просмотров 3,1 тыс.4 месяца назад
Excel Showing Formula instead of Results - Quick Fix!
Excel Quick Analysis Tool is Definitely Worth Checking Out🔥
Просмотров 6 тыс.4 месяца назад
Excel Quick Analysis Tool is Definitely Worth Checking Out🔥
Did You Know this Excel Quick Access Toolbar Hack? 🔥
Просмотров 6 тыс.4 месяца назад
Did You Know this Excel Quick Access Toolbar Hack? 🔥
4 Simple Methods To Convert Scientific Notation Into Numbers
Просмотров 6 тыс.4 месяца назад
4 Simple Methods To Convert Scientific Notation Into Numbers
5 Clever Name Box Tricks in Excel 🤯
Просмотров 12 тыс.4 месяца назад
5 Clever Name Box Tricks in Excel 🤯
3 Easy Ways to Highlight Cells with Formulas in Excel
Просмотров 6 тыс.4 месяца назад
3 Easy Ways to Highlight Cells with Formulas in Excel
Prevent Duplicate Entries in Excel (2 Simple Ways)
Просмотров 9 тыс.5 месяцев назад
Prevent Duplicate Entries in Excel (2 Simple Ways)
NEW Check Box in Excel (it's Awesome)✅
Просмотров 7 тыс.5 месяцев назад
NEW Check Box in Excel (it's Awesome)✅
Extract URLs from Hyperlinks in Excel (2 Easy Ways)
Просмотров 4,5 тыс.5 месяцев назад
Extract URLs from Hyperlinks in Excel (2 Easy Ways)
Split Text to Rows in Excel (3 Easy Ways)
Просмотров 11 тыс.5 месяцев назад
Split Text to Rows in Excel (3 Easy Ways)
New Shortcut in Excel - CONTROL + SHIFT + V
Просмотров 7 тыс.5 месяцев назад
New Shortcut in Excel - CONTROL SHIFT V

Комментарии

  • @sauravnath83
    @sauravnath83 День назад

    @Trump Excel can we also get the desired results by using Power Query

  • @user-ky6lu8xx4z
    @user-ky6lu8xx4z День назад

    thank you sumit for sharing valuable content.

  • @mandy34061
    @mandy34061 День назад

    I read many posts and videos to fix my vlookup problems but all are not helpful. Your video saved my time! Thank you so much for your sharing!

  • @thesscastaneda1179
    @thesscastaneda1179 День назад

    Thank you for this video. Supposed you have a template. How do you convert each row into pdf?

  • @lloydasiedu5870
    @lloydasiedu5870 День назад

    Thanks so much

  • @Azhar_Khan383
    @Azhar_Khan383 День назад

    Awesome and amazing, Thanks Sir

  • @PaulEBrownbill
    @PaulEBrownbill 2 дня назад

    Thanks for the video, very useful

  • @muhammadfuadmulla6102
    @muhammadfuadmulla6102 2 дня назад

    Not showing this formula in excel 2021. Please give me suggest from your end. thank you

    • @trumpexcel
      @trumpexcel 2 дня назад

      The formula I showed will work only if you have the new functions (I think all are available on Excel with M365 only). You can use the VBA method though which works in all the versions of Excel

    • @muhammadfuadmulla6102
      @muhammadfuadmulla6102 2 дня назад

      @@trumpexcel Thank you so much for giving suggest.

  • @soundaryasuresh1845
    @soundaryasuresh1845 2 дня назад

    Sir can't access dashboard excel file link sir

  • @telugu-malayalamlearning8032
    @telugu-malayalamlearning8032 2 дня назад

    Excellent Fantastic marvellous super

  • @xeeshanahmad8757
    @xeeshanahmad8757 2 дня назад

    excellent 👍

  • @chakralamurali
    @chakralamurali 2 дня назад

    Excellent sir

  • @RudraEatingShow
    @RudraEatingShow 2 дня назад

    First comment ❤❤

  • @Aksh-co6pt
    @Aksh-co6pt 2 дня назад

    Thanks a lot 🙏🙏

  • @ianretallick8242
    @ianretallick8242 2 дня назад

    Amazing! Thank you Sumit. Just saved me loads of time. It looks complicated but I just paused each step and then applied each action. Worked like a dream!!!

  • @schandrapraveen1198
    @schandrapraveen1198 2 дня назад

    Formate cell custom for lakh convert like 4325679 like it will change 43.25 how to do this please

  • @PayalKewlani-i8p
    @PayalKewlani-i8p 2 дня назад

    I am unable to understand what happened in the last part of INDEX function

  • @BolasDear
    @BolasDear 2 дня назад

    fantastic.

  • @Jay-gy1ii
    @Jay-gy1ii 2 дня назад

    thank you big sexy

  • @mohsenshafighi2960
    @mohsenshafighi2960 2 дня назад

    What about the "undo" function? its not working...

  • @kansiwa
    @kansiwa 2 дня назад

    Hi, the video is great and all, but when Isum it up, it deosn't sum to the dot. It will auto round up. How do I sum it up to the decimal point?

  • @Sky_Soar
    @Sky_Soar 2 дня назад

    Hi what if you have right table data and you need map to left side

  • @AbdulRahman-21965
    @AbdulRahman-21965 3 дня назад

    Lots of thanks Great explanation. Very well. Useful.

  • @Sidharth.Pratap
    @Sidharth.Pratap 3 дня назад

    This is superb.. thanks a ton :)

  • @cashewABCD
    @cashewABCD 3 дня назад

    Good thing a city like Frankfort isn't in the names list, else it would become Francerankfort.

  • @mikegardner8450
    @mikegardner8450 3 дня назад

    Is there a way to change the group box name or make the group box invisible and only show the option buttons?

  • @SAIDARIFSYAL
    @SAIDARIFSYAL 3 дня назад

    thanks a lot, dear sir

  • @comedianbrother9994
    @comedianbrother9994 4 дня назад

    Very Useful 👍👍

  • @timesavertricks
    @timesavertricks 4 дня назад

    Hello Sumit Sir, Can we use power Query to combine data either from several workbooks Or several sheets from several workbooks. Also the important scenario is all data Has no relation with each other's. Actually I'm looking to import data from a total of 5 workbooks and approx more than 30 sheets. If there is a way to connect with you I can explain the requirement in more detail

  • @pvs243432
    @pvs243432 4 дня назад

    Thank you for sharing

  • @rajeshrijhonia
    @rajeshrijhonia 5 дней назад

    thanks for Filter rhtough Vba Code in excel because i was also finding Ulternate of Filter Function.

  • @nagarjunasanigala7661
    @nagarjunasanigala7661 5 дней назад

    How to create code, please can you explain

  • @andreastjahja6895
    @andreastjahja6895 6 дней назад

    Thank you, so clear..how if the table in the page is using a dropdown to control the data view (default is 10 data), i want to transport "all" view

  • @shanmugam1098
    @shanmugam1098 6 дней назад

    very special morning

  • @mrva
    @mrva 6 дней назад

    You are an absolute legend, big thanks!

  • @kshitijm9
    @kshitijm9 7 дней назад

    i am unable to extract data from website to excel. I am getting the error access to the website is forbidden

  • @titomachete69
    @titomachete69 7 дней назад

    Thanks

  • @barnabas_adeto
    @barnabas_adeto 7 дней назад

    Very Useful Clear and Simple Thanks

  • @IceTobSmoKeo
    @IceTobSmoKeo 7 дней назад

    Why is mine .dat instead of .xml?

  • @NaveenKumar-tr6xo
    @NaveenKumar-tr6xo 7 дней назад

    You are clicking on entire colum,and saying entire row in vedio

  • @nataliakucys495
    @nataliakucys495 7 дней назад

    How can I do the same thing in Microsoft word?

  • @vuquangminh4891
    @vuquangminh4891 8 дней назад

    Man. I just love Indian people

  • @lalitkumarkashyap
    @lalitkumarkashyap 8 дней назад

    superb 🙏thanks a lot.

  • @bangladesh4026
    @bangladesh4026 8 дней назад

    It's great!

  • @ranganathanvelayudam5869
    @ranganathanvelayudam5869 9 дней назад

    Thank you very much, it's so simple

  • @claudehsu9869
    @claudehsu9869 9 дней назад

    Detailed explanation with useful examples. Good job dude.

  • @kousikdey62
    @kousikdey62 9 дней назад

    Today's dashboard and visualization is becoming very important please also add these in your tutorials. BI's

  • @journey01069
    @journey01069 9 дней назад

    It seems to work for everyone but It dose not work for me. I don't know what I am doing wrong with it.

  • @hakimali1497
    @hakimali1497 9 дней назад

    If collum B date and collum C is employee Id so what i do not allow double entry employee id same date

  • @venudesaraju6998
    @venudesaraju6998 10 дней назад

    Hello Sir I am using MacBook Air and Office 365. When I click on Data Tab I see Get Data (Power Query). I cannot see Get From File. I can see Import from Excel, Import from Txt/CSV, Import from XML etc, but cannot see Get From PDF. Please assist sir. Thanks and regards VENU