get-digital-help.com

Concatenate

Excel » Concatenate »

Concatenate cell values based on a condition [No VBA]

Add cell values to a single cell with a condition, no VBA in this article.

Concatenate unique distinct values

The new TEXTJOIN function in excel 2016 lets you do some amazing things with arrays. This post demonstrates how to […]

Use a drop down list to filter and concatenate unique distinct values

Question: Is there a way to have a unique list generated from a list? Meaning I have a sheet that […]

Concatenate cell values

Joining multiple cell values in Excel is not easy, for example, the CONCATENATE function allows you to only reference a […]

Lookup and return multiple values concatenated into one cell

This article demonstrates how to find a value in a column and concatenate corresponding values on the same row. The […]

Unique distinct values

Drop-down list

Join without TEXTJOIN

Lookup & return values

Compare

Criteria, two lists

Sums, return unique

Extract missing values

Common values 3 lists

Two price lists

Records in two tables

Common records

Update recent values(2)

Missing values two cols

Update recent values

Values shared by 2 rngs

Vals not shared 2 rngs

Values shared by 3 rngs

Extract not shared vals

Shared values 2 cols

Missing values 2 cols

Combine merge

Merge tables

Merge rows - condition

Combine ranges [UDF]

Merge matching rows

Merge 2 cols w. blanks

Pattern in cell value

Overlapping time

Containing any list value

Unique distinct/condition

Count colored cells

Equal values per row

Count overlapping days

Sort count freq. condi.

Count overlap. days(2)

Count overlap. days(1)

Weekday in date range

Weekday date range(2)

Cells between value

Entries date & time rng

Unique distinct - criteria

Unique dist. rec. criteria

Digits - no duplicates

Based on criteria

Count groups in calendar

Uniq. dist. based dates

Count based on date

Numbers across sheets

Cells between values

Most freq/date range

Unique distinct months

Uniq. dist. 2 cols

Unique dist. values

Dates

Schedule -> date rngs

Overlapping time

Count overlapping days

Date from week & day

Count overlap. days(2)

Count overlap. days(1)

Min/max date overlap.

Find date range based on a date

Create date ranges

Weekday in date range

Calc dates in project

Weeks from ranges

Weekday date range(2)

Entries date & time rng

Overlap. date ranges

Overlap rngs - condition

Count groups in calendar

Dates from overlap rngs

Based on date criteria

Date, week, month

Dupes - date, wk, month

Year - month from dates

Match date in date rng

Latest date - condition

Most freq/date range

Find min/max date rng

Blank between quarters

Dupe vals sorted date

Create date range

Lookup the nearest date

Based on a date range

Machine utilization

Date based on wkday

Find numbers in sum

Numbers closest to sum

Count overlapping days

Count overlap. days(2)

Count overlap. days(1)

Min/max date overlap.

Overlap rngs - condition

Based on date criteria

Unique distinct values

Uniq. dist. - condition

Adjacent contains string

Sorted alphabetically

Sorted A->Z

Sorted & no blanks - rng

Sort length

From a cell range

Sorted A-Z from range

Contains string in rng

Begins with criterion

Based on a date range

Based on dates

Year - month from dates

Based on date criteria

Extract filtered table

Extract & sum condition

Two conditions

Sum uniq. dist. rec.

Assign randomly unique

Sums, return unique

Sorted, no blanks - rng

Duplicate values

Dupes A-Z condition

Dupes w. exceptions

Filter duplicate values using critera

Common values 3 lists

Label duplicate records

Dupes - date, wk, month

Dupes from rng contain

Filter dupes begins w.

Min unique number

Dupe vals sorted date

Create a list of duplicates where adjacent cell value meets a condition

Sort column - frequency

Frequency - criteria

Sort rng - frequency

Sort count freq. condi.

Sort two columns

Sort records

Sort table

Sort adj. txt horiz. (1)

Sort unique A-Z blanks

Sort cell delimiter [VBA]

Sort Excel table [VBA]

Sort based on proximity

Sort dates - criteria

Vlookup and return multiple values

5 easy ways

Multiple conditions

Sorted from A to Z

Sorted A-Z - condition

Multiple conditions

Vlookup range

Vlookup rng - records

Vlook col - return rng

Search and return multiple values

Strings in any 2 cols

Strings in 2 cols each

Strings in column

Contains string - column

Filter records

Extract using criteria

Extract using criteria(2)

Extract using criteria(3)

Recs betw. this & that

Records betw. 2 dates

Date range & condition

Records in two tables

Unique records

Common records

Duplicate columns

Unique distinct records

Extract unique distinct records from two data sets

Sort based on freq.

Filter unique distinct records using criteria

Count uniq. dist. [2010]

Unique dist. rec. criteria

Records - condition(2)

Records - condition(1)

Filter unique distinct records

Count unique distinct records

Duplicate records

Extract duplicate records

Count records

Weekly Blog EMAIL

Get a FREE PDF book!