Excel UNIQUE Across Columns

by

There may be a better approach, but here is one using TEXTJOIN and FILTERXML to create an array that you can call UNIQUE on:

=SORT(UNIQUE(FILTERXML("<t><s>"&TEXTJOIN("</s><s>",TRUE,A1:C6)&"</s></t>","//s")))

enter image description here

More Related Contents:

  1. Excel VBA – How to add dynamic array formula
  2. Using UNIQUE with non-adjecent columns on different sheets
  3. How to split texts from dynamic range?
  4. Excel: How to gather unique values in one column that are associated with duplicates in another column?
  5. How to convert to percentage [closed]
  6. Sequence of numbers based on start and end value of 2 cells [closed]
  7. I have an Excel data sheet that I would like to extract data from into a new sheet
  8. Error in finding last used cell in Excel with VBA
  9. Convert matrix to 3-column table (‘reverse pivot’, ‘unpivot’, ‘flatten’, ‘normalize’)
  10. Getting unique values in Excel by using formulas only
  11. Vlookup using 2 columns to reference another
  12. Excel: last character/string match in a string
  13. Referencing value in a closed Excel workbook using INDIRECT?
  14. Simple Pivot Table to Count Unique Values
  15. Filling any empty cells with the value above
  16. How to create a string or formula containing double quotes in Excel?
  17. Find last used cell in Excel VBA
  18. Remove leading or trailing spaces in an entire column of data
  19. Two column lookup in table array using INDEX and MATCH
  20. PowerQuery: How can I concatenate grouped values?
  21. Excel Date to String conversion
  22. Excel: Searching for multiple terms in a cell
  23. Three Dimensional Lookup Using INDEX/MATCH
  24. Optimizing Excel formulas – SUMPRODUCT vs SUMIFS/COUNTIFS
  25. Countif With Multiple OR Criteria
  26. Dynamic chart range using INDIRECT: That function is not valid (despite range highlighted)
  27. Convert from US to UK format
  28. How to roundup a number to the closest ten?
  29. Convert an Array Formula’s Text Results into a Usable Format
  30. Can’t pass a range to a lambda using Let and Makearray functions

Leave a Comment