Multiple Column Ranges
to search For values in the intersection of the row and column you want the table of a special type: in the header row and the leftmost column should be non-repeating values.
Combine the values located in multiple columns into a single column.
Sometimes, you need to combine three or more list of values into one.
Having two lists with the same type of repetitive values, we will create a list containing only distinct values.
Having two lists with the same type of duplicate values, create a list of them, containing only unique values.
Find the number of unique numeric values in the specified multi-column range.
Find the number of non-repeating numeric values in the specified multi-column range.