Get Digital Help
  • Home
  • Templates
  • Products
  • Categories
    • Advanced Filter
    • Automate
    • Combine/Merge
    • Compare
    • Conditional Formatting
    • Count Values
    • Dates
    • Drop Down Lists
    • Duplicate Values
    • Finance
    • Misc
    • Pivot Table
    • Random
    • Records
    • Search/Lookup
    • Sort Values
    • Templates
    • Unique Distinct Values
    • Unique Values
    • Unique Values
    • User Defined Functions
    • VBA
    • VLookup
    • Unique/Duplicates
    • Sort values
    • Count values
    • Search/Lookup
    • Microsoft Excel
  • Archive
  • Contact
    • Contact me
  • About Me
    • About me
    • Blogs I read
      Popular categories

       Automate

       Charts

       Compare

       Conditional formatting

       Count values

       Dates

       Drop down lists

       Misc

       Pivot tables

       Search/Lookup

       Sort values

       Tables

       Templates

       UDF

       VBA

       Vlookup

      • Advertise Here

      Dashboard reporting with excel This e-book teaches you how to create your own Excel dashboard reports, starting from scratch. Learn how to create mini-charts, how to use Excel's Camera tool, how to set up Excel databases, and a lot more.


      Excel Worksheet-Formula Add-Ins allows worksheet formulas to change chart settings. For the first time ever, your formulas can create traffic-light charts, highlight chart elements, assign number formats, and much more.


    Get Digital Help > Excel > Combine/Merge

    Archive for the ‘Combine/Merge’ Category

    Merge two related tables
    Group a number of rows together by the first column
    Auto populate a sheet
    Merge matching rows in excel (text values)
    Sum unique distinct invoices in excel 2007
    Excel udf: Combine cell ranges into a single range while eliminating blanks
    Merge matching rows in excel
    Tracking a stock portfolio #2 in excel
    Tracking a stock portfolio in excel (auto update)
    Automate excel: Update list with new values
    Merge two columns with possible blank cells in excel (formula)
    Consolidate sheets in excel (vba)
    Categorize values into multiple columns (excel formulas)
    Combine data from multiple sheets in excel
    Filter duplicates from two columns combined and sort from A to Z using array formula in excel
    Sort text cells alphabetically from two columns using excel array formula
    Merge two columns into one list in excel
    Merge three columns into one list in excel
    How to find common values from two lists
    « previous entries
    Next Page »
    • Subscribe subscribe  
    • Blog updates by email:

    • Welcome! I am Oscar and here to help you! Feel free to comment and ask excel questions.
      Don´t forget to add my RSS feed and subscribe to new blog articles by email.
    • Recent Comments

      • Alaa Abdullnabi on Merge two columns with possible blank cells in excel (formula)
      • Oscar on Merge two columns with possible blank cells in excel (formula)
      • Oscar on Calculate your stock portfolio performance in excel
      • Oscar on Formula for matching a date within a date range in excel
      • Ag on Excel vba: Save invoice data
      • Oscar on Create a unique distinct list of a long list without sacrificing performance using vba in excel
      • William on Create a unique distinct list of a long list without sacrificing performance using vba in excel
      • Jan on Formula for matching a date within a date range in excel
      • Durgesh on Calculate your stock portfolio performance in excel
      • Durgesh on Calculate your stock portfolio performance in excel
    • Recent Posts

      • Count students
      • Use a map in an excel chart
      • SEARCH and FIND functions
      • Yet another excel calendar
      • MMULT function – Matrix multiplication
      • SMALL function and LARGE function
      • Copy/Rename a file (excel vba)
      • Assign each person with randomly unique objects as a daily activity
      • ROW function explained
      • Highlight duplicates in a filtered excel defined table
    Oscar Cronquist