Excel Remix
Excel Remix
  • Видео 130
  • Просмотров 36 222
Sum Duplicate Values in Excel Using Formula | Easy Tutorial
In this video, I'll show you how to sum duplicate values in Excel using a powerful formula combination. We'll use the IF, COUNTIF, and SUMIF functions together to calculate the total for each duplicate item directly within the same table. This method allows you to quickly consolidate your data without needing to create a separate summary table. Whether you're working with sales data, inventory lists, or any other dataset with repeating entries, this tutorial will help you manage and analyze your data efficiently.
Watch now to learn this simple yet effective technique!
Просмотров: 78

Видео

Make same size of all selected Charts and Pictures in Excel2:34Make same size of all selected Charts and Pictures in Excel
Make same size of all selected Charts and Pictures in Excel
Просмотров 1034 месяца назад
#ExcelTips #exceltutorial #ExcelRemix Hello Everyone! Welcome back to Excel Remix. In today's tutorial, we'll learn how to make all selected charts and pictures the same size. If you've ever struggled with resizing multiple charts or images one by one, this video is for you. In this video, you'll learn: Resize all charts at the same time: 1. How to quickly resize multiple charts using the taskb...
2 Methods to Convert Angle between Degrees and Radians in Excel2:552 Methods to Convert Angle between Degrees and Radians in Excel
2 Methods to Convert Angle between Degrees and Radians in Excel
Просмотров 2134 месяца назад
#ExcelTips #DataAnalysis #ExcelRemix Hello Everyone! Welcome to Excel Remix. In this tutorial, we will learn how to convert angle between degrees and radians in Excel When you need to convert data between two angle units, such as degrees and radians, degrees and minutes, or degrees and seconds, Here I will introduce some quick tricks for you. In this video, you will learn: 1. Convert angle betw...
How to Use SUM, SUMIF, and SUMIFS in Excel: Complete Tutorial9:10How to Use SUM, SUMIF, and SUMIFS in Excel: Complete Tutorial
How to Use SUM, SUMIF, and SUMIFS in Excel: Complete Tutorial
Просмотров 1774 месяца назад
#ExcelTips #DataAnalysis #ExcelRemix Hello Everyone! Welcome to Excel Remix. In this tutorial, we will learn the powerful Excel formulas SUM, SUMIF, and SUMIFS. These formulas are essential for anyone looking to analyze data efficiently in Excel. Whether you are a beginner or looking to sharpen your Excel skills, this video is perfect for you. In this video, you will learn: 1. How to use the SU...
Complete Tutorial of COUNT Formulas in MS Excel9:38Complete Tutorial of COUNT Formulas in MS Excel
Complete Tutorial of COUNT Formulas in MS Excel
Просмотров 1084 месяца назад
#Excel #ExcelFormulas #excelremix Hello Everyone! Welcome back to Excel Remix. In today's video, we will learn Excel Count formulas. These powerful formulas will help you manage your data more effectively and gain valuable insights. In this video, you'll learn: 1. COUNT: How to count the number of cells with numbers. 2. COUNTA: How to count all non-empty cells, including text. 3. COUNTBLANK: Ho...
Top 4 Conditional Formatting Techniques for Excel Users5:12Top 4 Conditional Formatting Techniques for Excel Users
Top 4 Conditional Formatting Techniques for Excel Users
Просмотров 764 месяца назад
#Excel #ExcelTips #conditionalformatting Hello Everyone! Welcome to Excel Remix. In this video, we'll learn Conditional Formatting in Excel. This powerful feature can help you make your data more insightful and visually appealing. Whether you're a beginner or an experienced Excel user, these techniques will enhance your data analysis skills. In this tutorial, you'll learn: 1. Highlight Cells Ru...
How to Sort Data in Excel | Complete tutorial from Basic to Advance9:15How to Sort Data in Excel | Complete tutorial from Basic to Advance
How to Sort Data in Excel | Complete tutorial from Basic to Advance
Просмотров 1394 месяца назад
#excel #exceltutorial #excelremix Hello Everyone! Welcome to Excel Remix. In this video, we will learn methods of sorting, covering everything you need to know from basic manual sorting to advanced automatic sorting using formulas and VBA. In this tutorial, you'll learn: Manual Sorting: How to sort your data alphabetically by 'Sales Rep' How to sort your data by 'Total Sales' from largest to sm...
How to Quickly Sort Data by Color in Excel2:08How to Quickly Sort Data by Color in Excel
How to Quickly Sort Data by Color in Excel
Просмотров 1394 месяца назад
#Excel #ExcelTutorial #SortByColors Hello Everyone! Welcome back to Excel Remix. Today I'm going to show you How to sort data by color in excel? Sometimes we may fill the rows or cells with different colors to make the worksheet much readable. And sometimes we want to sort the cells by color in Excel. What You'll Learn: . How to sort data by color in excel . The benefits of sorting by colors in...
How to Select and Highlight all negative numbers in Excel3:44How to Select and Highlight all negative numbers in Excel
How to Select and Highlight all negative numbers in Excel
Просмотров 1184 месяца назад
How to Select and Highlight all negative numbers in Excel
How to write Formulas Using CHATGPT in Excel6:12How to write Formulas Using CHATGPT in Excel
How to write Formulas Using CHATGPT in Excel
Просмотров 464 месяца назад
How to write Formulas Using CHATGPT in Excel
How to Create Excel Formulas Using AI | AI formula Editor for Excel | AI formula add-in for excel5:53How to Create Excel Formulas Using AI | AI formula Editor for Excel | AI formula add-in for excel
How to Create Excel Formulas Using AI | AI formula Editor for Excel | AI formula add-in for excel
Просмотров 2605 месяцев назад
How to Create Excel Formulas Using AI | AI formula Editor for Excel | AI formula add-in for excel
Create Row Numbers for Each Group in Excel Using Power Query5:24Create Row Numbers for Each Group in Excel Using Power Query
Create Row Numbers for Each Group in Excel Using Power Query
Просмотров 2505 месяцев назад
Create Row Numbers for Each Group in Excel Using Power Query
Power Query for getting Folder & Sub-folder File Names #microsoftexcel4:36Power Query for getting Folder & Sub-folder File Names #microsoftexcel
Power Query for getting Folder & Sub-folder File Names #microsoftexcel
Просмотров 1335 месяцев назад
Power Query for getting Folder & Sub-folder File Names #microsoftexcel
3 Quick Advanced Concatenate Methods #powerquery5:043 Quick Advanced Concatenate Methods #powerquery
3 Quick Advanced Concatenate Methods #powerquery
Просмотров 555 месяцев назад
3 Quick Advanced Concatenate Methods #powerquery
Remove extra spaces within cells using kutools in Excel | remove indents space1:45Remove extra spaces within cells using kutools in Excel | remove indents space
Remove extra spaces within cells using kutools in Excel | remove indents space
Просмотров 2167 месяцев назад
Remove extra spaces within cells using kutools in Excel | remove indents space
how to apply superscript in excel | Superscript format in Microsoft Excel2:54how to apply superscript in excel | Superscript format in Microsoft Excel
how to apply superscript in excel | Superscript format in Microsoft Excel
Просмотров 1277 месяцев назад
how to apply superscript in excel | Superscript format in Microsoft Excel
How to add Border in Excel | Change Border Color #Exceltutorial 2023/20243:12How to add Border in Excel | Change Border Color #Exceltutorial 2023/2024
How to add Border in Excel | Change Border Color #Exceltutorial 2023/2024
Просмотров 1697 месяцев назад
How to add Border in Excel | Change Border Color #Exceltutorial 2023/2024
How to Hide and Unhide Worksheets in Excel #exceltips #exceltutorial #excelshortvideo1:50How to Hide and Unhide Worksheets in Excel #exceltips #exceltutorial #excelshortvideo
How to Hide and Unhide Worksheets in Excel #exceltips #exceltutorial #excelshortvideo
Просмотров 777 месяцев назад
How to Hide and Unhide Worksheets in Excel #exceltips #exceltutorial #excelshortvideo
How to Hide or Display Zero Values In Excel | Leave the Cell Blank If 0 | #microsoftexcel2:06How to Hide or Display Zero Values In Excel | Leave the Cell Blank If 0 | #microsoftexcel
How to Hide or Display Zero Values In Excel | Leave the Cell Blank If 0 | #microsoftexcel
Просмотров 1107 месяцев назад
How to Hide or Display Zero Values In Excel | Leave the Cell Blank If 0 | #microsoftexcel
How to use Format Painter In Excel | What is Format Painter | Copy cell formatting #exceltutorial3:35How to use Format Painter In Excel | What is Format Painter | Copy cell formatting #exceltutorial
How to use Format Painter In Excel | What is Format Painter | Copy cell formatting #exceltutorial
Просмотров 707 месяцев назад
How to use Format Painter In Excel | What is Format Painter | Copy cell formatting #exceltutorial
How to switch to full screen in Excel | Full screen trick | Exit from full screen view #exceltips1:39How to switch to full screen in Excel | Full screen trick | Exit from full screen view #exceltips
How to switch to full screen in Excel | Full screen trick | Exit from full screen view #exceltips
Просмотров 1887 месяцев назад
How to switch to full screen in Excel | Full screen trick | Exit from full screen view #exceltips
How to use Vlookup Function in Excel | MS Excel V-Lookup Formula5:50How to use Vlookup Function in Excel | MS Excel V-Lookup Formula
How to use Vlookup Function in Excel | MS Excel V-Lookup Formula
Просмотров 637 месяцев назад
How to use Vlookup Function in Excel | MS Excel V-Lookup Formula
How to add Mr and Mrs before name | Add Prefix according to gender #exceltutorial #exceltips4:15How to add Mr and Mrs before name | Add Prefix according to gender #exceltutorial #exceltips
How to add Mr and Mrs before name | Add Prefix according to gender #exceltutorial #exceltips
Просмотров 2747 месяцев назад
How to add Mr and Mrs before name | Add Prefix according to gender #exceltutorial #exceltips
How to add unit to cells in Excel | Add kg #microsoftexcel2:21How to add unit to cells in Excel | Add kg #microsoftexcel
How to add unit to cells in Excel | Add kg #microsoftexcel
Просмотров 997 месяцев назад
How to add unit to cells in Excel | Add kg #microsoftexcel
How to repeat number sequence in Excel | Repeat same number multiple times #exceltutorial1:20How to repeat number sequence in Excel | Repeat same number multiple times #exceltutorial
How to repeat number sequence in Excel | Repeat same number multiple times #exceltutorial
Просмотров 1937 месяцев назад
How to repeat number sequence in Excel | Repeat same number multiple times #exceltutorial
How to lock and protect cells in Excel | Fix and lock background color #exceltips #shorts2:03How to lock and protect cells in Excel | Fix and lock background color #exceltips #shorts
How to lock and protect cells in Excel | Fix and lock background color #exceltips #shorts
Просмотров 817 месяцев назад
How to lock and protect cells in Excel | Fix and lock background color #exceltips #shorts
How to highlight cells that contain Specific character #microsoftexcel2:09How to highlight cells that contain Specific character #microsoftexcel
How to highlight cells that contain Specific character #microsoftexcel
Просмотров 1347 месяцев назад
How to highlight cells that contain Specific character #microsoftexcel
Hide Picture within Columns or Rows in Excel | Move and Size with cells | Size & Properties1:26Hide Picture within Columns or Rows in Excel | Move and Size with cells | Size & Properties
Hide Picture within Columns or Rows in Excel | Move and Size with cells | Size & Properties
Просмотров 1,4 тыс.7 месяцев назад
Hide Picture within Columns or Rows in Excel | Move and Size with cells | Size & Properties
How to center text without merging cells | Merge and Center Text #microsoftexcel1:26How to center text without merging cells | Merge and Center Text #microsoftexcel
How to center text without merging cells | Merge and Center Text #microsoftexcel
Просмотров 937 месяцев назад
How to center text without merging cells | Merge and Center Text #microsoftexcel
Google sheets - Combine Date and Time columns into one column | Concatenate & Text Formula2:23Google sheets - Combine Date and Time columns into one column | Concatenate & Text Formula
Google sheets - Combine Date and Time columns into one column | Concatenate & Text Formula
Просмотров 1,1 тыс.7 месяцев назад
Google sheets - Combine Date and Time columns into one column | Concatenate & Text Formula

Комментарии

  • @candiezPIE
    @candiezPIE 16 дней назад

    Awesome! Exactly what I was looking for. I appreciated you showing us this! <3

  • @markodimitrijevic8231
    @markodimitrijevic8231 24 дня назад

    You have 5 "Yes" and 4 "No" in the example and it calculates as 50% which is wrong

  • @Zam-x4p
    @Zam-x4p Месяц назад

    Thanks you so much. Is it possible to sum them in the same table rather than creating a new one?

    • @ExcelRemix
      @ExcelRemix Месяц назад

      Thank you for your comment! Yes, it's possible to sum duplicate values within the same table without creating a new one. we can sum duplicates by using the SUMIF function or a Pivot Table. I'll show you the solution soon in an upcoming video. Stay tuned!☺

  • @AsadKhan-cf9sl
    @AsadKhan-cf9sl 2 месяца назад

    Best

  • @HappyCoffee-kb4oh
    @HappyCoffee-kb4oh 2 месяца назад

    Nice sharing 😊

  • @STARGAMERGAMERs
    @STARGAMERGAMERs 2 месяца назад

    ❤❤❤

  • @AffectionateCatfish-vj9wj
    @AffectionateCatfish-vj9wj 2 месяца назад

    Best ❤

  • @jarwarkhan5754
    @jarwarkhan5754 2 месяца назад

    Awesome very nice

  • @mksk4395
    @mksk4395 2 месяца назад

    The issue is that "fill" literally fills the cell as best as it can. So if you have a short word like "cat", this formatting makes it "catcatcatcatcatcat". This doesn't solve what you wanted reliably, it only works if every word is shorter than the cell itself. It doesn't work if you apply it to a whole row

    • @ExcelRemix
      @ExcelRemix 2 месяца назад

      @mksk4395 Thanks for highlighting this point! You’re absolutely right, the "Fill" option isn't suitable for all cases, especially with shorter words. I'll upload a video soon with a solution that prevents text overflow without changing the row height or column width.

  • @HasifAhmed-e3m
    @HasifAhmed-e3m 3 месяца назад

    Helpful

  • @PradipRao-nu5kv
    @PradipRao-nu5kv 3 месяца назад

    Useful

    • @ExcelRemix
      @ExcelRemix 2 месяца назад

      Glad to hear that

  • @DepaakSinghYadav
    @DepaakSinghYadav 3 месяца назад

    Very informative

    • @ExcelRemix
      @ExcelRemix 2 месяца назад

      Glad it was helpful!

  • @GavindarMaula
    @GavindarMaula 3 месяца назад

    Helpful

  • @RasmikaChaurasia
    @RasmikaChaurasia 3 месяца назад

    Nice video

  • @ArghoMaitra-op3ii
    @ArghoMaitra-op3ii 3 месяца назад

    Great video

  • @JericRosales-d6h
    @JericRosales-d6h 3 месяца назад

    Nice sharing

    • @ExcelRemix
      @ExcelRemix 2 месяца назад

      Thanks for visiting

  • @ahsansaeed5757
    @ahsansaeed5757 3 месяца назад

    wow

  • @AftabJavaid-xh9mq
    @AftabJavaid-xh9mq 3 месяца назад

    Nice

  • @AfuHarry
    @AfuHarry 3 месяца назад

    Nice info

  • @ZohanMehar_724
    @ZohanMehar_724 3 месяца назад

    Good info

  • @Rainbow53539
    @Rainbow53539 3 месяца назад

    ❤❤

  • @JeffreyMonderondo
    @JeffreyMonderondo 3 месяца назад

    Nice sharing

  • @ImtiazUrRahman-ok7iw
    @ImtiazUrRahman-ok7iw 3 месяца назад

    Niceeee g good very ❤❤❤❤❤

  • @AnneeMalik-fp8rd
    @AnneeMalik-fp8rd 4 месяца назад

    This knowledge is great, thanks for sharing

    • @ExcelRemix
      @ExcelRemix 2 месяца назад

      Glad it was helpful!

  • @NzambimanaMoise
    @NzambimanaMoise 4 месяца назад

    You are doing good

  • @SamuelIrakoze-oh2wj
    @SamuelIrakoze-oh2wj 4 месяца назад

    Great teaching

  • @letsmoneycome
    @letsmoneycome 4 месяца назад

    Great teaching

  • @BrandonRa
    @BrandonRa 4 месяца назад

    Mine is not calculating right it is 9% off

    • @ExcelRemix
      @ExcelRemix 3 месяца назад

      maybe you have different data set

  • @David_Baxendale
    @David_Baxendale 4 месяца назад

    Many thanks for this. The amount of forums and threads I went through and had to read exhaustive questions when this is all I (and the people asking on said forums) needed. This method didn't help me 100% as I had empty cells in both columns and rows (and I needed to sort on rows).. I was able to just select the empty rows and use the ctrl+9/sort/ctrl+shift+9.

  • @ThomasKane-bx8ys
    @ThomasKane-bx8ys 4 месяца назад

    Thank you!

    • @ExcelRemix
      @ExcelRemix 4 месяца назад

      Welcome keep watching

  • @Azaan_Akhtar
    @Azaan_Akhtar 4 месяца назад

    Good

  • @abidhussain-ko2qu
    @abidhussain-ko2qu 4 месяца назад

    Thanks you so much i was searching such formula from many months love from PAKISTAN and love from my heart God bless you more

    • @ExcelRemix
      @ExcelRemix 4 месяца назад

      Ameen thanks for your valuable words

  • @Muhammadkhan-j8e
    @Muhammadkhan-j8e 5 месяцев назад

    Dear madam how can I download MS office latest version free.

    • @ExcelRemix
      @ExcelRemix 5 месяцев назад

      To download the latest version of Microsoft Office, you can visit the official Microsoft website or use the Microsoft Store app on your device. From there, you can purchase and download the latest version of Office that suits your needs.

  • @NextGen-gl1tc
    @NextGen-gl1tc 6 месяцев назад

    good work

  • @CallXBpo
    @CallXBpo 6 месяцев назад

    keep it up

  • @sterlingleads
    @sterlingleads 6 месяцев назад

    nice explain

  • @SananAli419
    @SananAli419 6 месяцев назад

    Very interesting

  • @adilshaikh2464
    @adilshaikh2464 6 месяцев назад

    Nice one

  • @King_biharigamers528
    @King_biharigamers528 6 месяцев назад

    Nice

  • @umarpyara8836
    @umarpyara8836 6 месяцев назад

    Greatest information

    • @ExcelRemix
      @ExcelRemix 2 месяца назад

      @unmarpyara8836 Glad it was helpful

  • @aliyakhan1033
    @aliyakhan1033 6 месяцев назад

    Great video

  • @dangerousqueen6940
    @dangerousqueen6940 6 месяцев назад

    I am beginner 🔰

    • @ExcelRemix
      @ExcelRemix 2 месяца назад

      I hope you learn many Excel tricks from this channel. Stay tuned!

  • @RAHULKUMAR-w2q6o
    @RAHULKUMAR-w2q6o 6 месяцев назад

    ❤❤❤

  • @Rashidali-eq6ku
    @Rashidali-eq6ku 6 месяцев назад

    Thanks for.ideas.

    • @ExcelRemix
      @ExcelRemix 2 месяца назад

      Most welcome 😊

  • @toqeerpirzada
    @toqeerpirzada 6 месяцев назад

    😊😊 good work

  • @2explorewithneelam
    @2explorewithneelam 7 месяцев назад

    Informative

  • @JavaScriptAli
    @JavaScriptAli 7 месяцев назад

    Thanks I am beginner

    • @ExcelRemix
      @ExcelRemix 2 месяца назад

      I hope you learn many Excel tricks from this channel. Stay tuned!

  • @NavedAli-b8r
    @NavedAli-b8r 7 месяцев назад

    Exilent bro

  • @JustJob-k3s
    @JustJob-k3s 7 месяцев назад

    Hard work💪💼 😢

    • @ExcelRemix
      @ExcelRemix 2 месяца назад

      Thank you! Your support and appreciation mean a lot. 😊

  • @NapAli-v1y
    @NapAli-v1y 7 месяцев назад

    Good job👌👍👏