Add-in - Get Digital Help

Get Digital Help

<a href="//pixfuture-d.openx.net/w/1.0/rc?cs=5e204d84f8&cb=INSERT_RANDOM_NUMBER_HERE" ><img src="//pixfuture-d.openx.net/w/1.0/ai?auid=538803744&cs=5e204d84f8&cb=INSERT_RANDOM_NUMBER_HERE" border="0" alt=""></a>

Add-in

Excel » Add-in »

Vlookup across multiple sheets

This blog post describes how to search two tables on two sheets and return multiple results. Sheet1 contains table1 and […]

Split data across multiple sheets [VBA]

In this post I am going to show how to create a new sheet for each airplane using vba. The […]

Advanced formulas

Based on a condition

Unique distinct values

Join without TEXTJOIN

Lookup & return values

Criteria, two lists

Sums, return unique

Extract missing values

Common values 3 lists

Records in Excel tables

Two Excel tables

Two price lists

Records in two tables

Missing values two cols

Common text 2 ranges

Missing text 2 ranges

Update recent values

Sum unique 2 columns

Values shared by 2 rngs

Vals not shared 2 rngs

Values shared by 3 rngs

Two ranges combined

Count shared values

Extract not shared vals

Shared values 2 cols

Missing values 2 cols

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)

Contiguous values

Inventory consumption

Count filtered table

Groups of each value

Weekday in date range

Weekday date range(2)

Cells between value

Count based on date

Entries date & time rng

Unique distinct - criteria

Unique dist. rec. criteria

Digits - no duplicates

Based on criteria

Records in date range

Count cell blocks

Uniq. dist. based dates

Count based on date

Numbers across sheets

Cells between values

More than n dupes

Unique in two lists

Common val in range

Most freq/date range

Uniq. dist. year/rng

Common betw. 2 lists

Uniq. dist. in rng

Uniq. dist. text in rng

Uniq. dist. rec. date rng

Unique distinct months

Condition past 90 days

Uniq. disti. vals 3 rngs

Uniq. dist. vals 2 rngs

Uniq. dist. nums in rng

Uniq. dist. - date criteria

Uniq. dist. 3 cols

Uniq. dist. 2 cols

Unique dist. values

Count shared values

Schedule -> date rngs

Overlapping time

Count overlapping days

Date from week & day

Count overlap. days(2)

Count overlap. days(1)

Overlap. date ranges

Overlapping ranges

Find overlap. ranges

Min/max date overlap.

Date ranges overlap

Consecutive dates

Count overlap days

Overlap holidays

Prevent overlapping

Find date range

Inventory consumption

Search related data

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

Random uniq dates

Highlight overlap rngs

Records in date range

Count cell blocks

Count overlapping dates

Dates from overlap rngs

Dates from date rngs

Date rngs from dates

Dates not in rngs

Plot date ranges

Highlight overlap rngs

Overlapping ranges

Based on date criteria

Date, week, month

Dupes - date, wk, month

Year - month from dates

Match date in date rng

Latest date - condition

Odd/even months

Common val in range

Most freq/date range

Largest based on date

Find min/max date rng

Blank between quarters

Items past date

Condition past 90 days

Dupe recs by date

Create date range

Lookup the nearest date

Based on a date range

Sort based on dates

Machine utilization

Date based on wkday

Find latest date in a list

Duplicate values

Dupes A-Z condition

Dupes w. exceptions

Filter duplicate values using critera

Easily identify groups of duplicate rows

From a large data set

Filter duplicate words from a cell range [UDF]

Dupes - date, wk, month

Remove based on week

Dupes from rng contain

Filter dupes begins w.

Validate duplicates

Extract duplicate text values from a range containing both numerical and text values

Sort dupes 2 cols A-Z

Find min and max unique and duplicate numerical values

Dupe recs by date

Extract duplicates from a range using excel array formula

Extract a list of duplicates from three columns combined using array formula in excel

Extract a list of duplicates from a column

Extract a list of duplicates from two columns combined

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

How to extract a list of duplicates from a column in excel

Duplicate records

Filter duplicate records

Extract duplicate records

Unique distinct values

Uniq. dist. - condition

Adjacent contains string

Adjacent has text

Begins with criterion

Contains string

Based on a condition

Based on criteria

Sorted alphabetically

Sorted & no blanks - rng

From a cell range

Uniq. dist. rng condition

From multi-cols (2)

Sorted A-Z from range

From two ranges

Extract text from range

Contains string in rng

Based on a date range

Year - month from dates

Based on date criteria

Extract filtered table

Sums, return unique

Extract & sum condition

Sum uniq. dist. rec.

Numbers from sheets

From a large data set

Assign randomly unique

Sort a column A-Z

Sort from 2 cols A-Z

Sort rng frequency

Sort count freq. condi.

Sort txt from rng

Sort from rng A-Z

Sort parallel (1)

Sort parallel (2)

Sort adj. txt horiz. (1)

Sort table custom

Lookup/Sort custom

Sort random order

Sort based on length

Sort dupes 2 cols A-Z

Sort unique A-Z

Sort cell delimiter [VBA]

Sort Excel table [VBA]

5 smallest values

Top values - criteria

Sort based on proximity

Sort dates - criteria

Sort based on dates

Sort digits in rng

Vlookup function

VLOOKUP function

Discount percentages

Multiple conditions

Lookup value in rng

Vlookup and return multiple values

Multiple conditions

Sorted from A to Z

Sorted A-Z - condition

Multiple conditions

Vlookup criteria rng

Vlookup criteria rng (2)

Vlookup rng - records

Vlook col - return rng

1 result per search

Horizontal vlookup

Vlookup - Drop-down

Multiple sheets

Formula categories

Index and Match

String manipulation