Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/
In this video, we learn how to use a formula to return unique combinations of values from columns that are non-adjacent.
If you’d like to read the accompanying blog post on my website, you can access it here: https://www.excelcampus.com/functions/unique-non-adjacent-columns

Related Videos:

FILTER to Return Non-Adjacent Columns in Any Order in Excel:
https://www.excelcampus.com/functions/unique-non-adjacent-columns

New Excel Features: Dynamic Array Functions & Formulas that Spill: https://www.youtube.com/watch?v=1HF0UGMF070&t=50s

#MsExcel #ExcelCampus
00:00 Introduction
01:01 Write the Formula
01:24 Create a list of row numbers
03:00 Unique Function
03:20 Sort Function
03:45 Array
03:55 Summary