'Combine Merge' category



Merge tables based on a condition
This article demonstrates techniques on how to merge or combine two data sets using a condition. The top left data […]
Group rows based on a condition
This article explains how to merge values row by row based on a condition in column A using an array […]
Combine cell ranges ignore blank cells
The image above demonstrates a¬†user defined function that merges up to 255 cell ranges and removes blanks. I will also […]
Merge matching rows
Question: I'm using excel 2003. This is my problem.Sheet 1 COL A contains fruits, col B to H contains there […]
Merge two columns with possible blank cells
This article demonstrates two formulas, they both accomplish the same thing. The Excel 365 formula is much smaller and is […]
Consolidate sheets [vba]
Question: I have multiple worksheets in a workbook. Each worksheets is project specific. Each worksheet contains almost identical format. The […]
Merge Ranges Add-In
Merge Ranges is an add-in for Excel that lets you easily merge multiple ranges into one master sheet. The Master […]
Merge two columns
The picture above shows how to merge two columns into one list using a formula. Table of Contents Merge two […]
Merge three columns into one list
The above image demonstrates a formula that adds values in three different columns into one column. Table of Contents Merge […]

Excel formula categories

AverageChooseCombine MergeCompareConcatenateConditional FormattingCountCount valuesDatesDuplicatesExtractFilterFilter recordsFiltered valuesFilterxmlHyperlinkIf cellIndex MatchLogicLookupsMatchMaxMinNumbers in sumOR logicOverlappingPartial matchRecordsSequenceSmallSort bySort valuesSumSumifsSumproductString manipulationTimeUnique distinct recordsUnique distinct valuesUnique recordsUnique valuesVlookupVlookup return values

Excel categories